Thanks for all help of everyone.
I have tried to change effective_cache_size = 24GB and it run well.
Tuan Hoang Anh
Hello
I have a bad query on PostgreSQL 9.0.23 - 64bit - Windows 2012 R2 - 48GB Ram
explain analyze select d.data_id, d.table_name, d.event_type, d.row_data,
d.pk_data, d.old_data, d.create_time, d.trigger_hist_id, d.channel_id,
d.transaction_id, d.source_node_id, d.external_data, '' from sym_data
Thanks for all.
I will try pgpool-II & pgbouncer . Hope it is good solution.
Tuan Hoang Anh
On Wed, Jan 7, 2015 at 8:30 AM, Sameer Kumar
wrote:
>
> On 6 Jan 2015 03:02, "tuanhoanganh" wrote:
> >
> > Hello everybody
> >
> > Does anyone user pg-po
Hello everybody
Does anyone user pg-pool II on real production ?
How many slave do you have? and how many size of database ?
I need config my old retail system to support ~ 1500 user with 1000GB over
4 years. I want to try pgpool-II but don't found real system use it.
My system use direct SQL SE
You can test with SymmetricDS (www.*symmetricds*.org)
On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh wrote:
> You can test with SymmetricDS (www.*symmetricds*.org)
>
>
> On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar wrote:
>
>>
>> Thanks alot everyone!
>>
>&
I installed pyodbc-3.0.7.win-amd64-py3.2.exe from
http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc then it work well
On Fri, Sep 27, 2013 at 10:00 AM, tuanhoanganh wrote:
> Hello all.
>
> I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit.
> But my plpyt
quot;help", "copyright", "credits" or "license" for more information.
>>> exit()
tuan@tuan-VirtualBox:/$
On Fri, Sep 27, 2013 at 11:53 AM, tuanhoanganh wrote:
> If i run import pyodbc from python command and run pyodbc sql command,
> everything w
If i run import pyodbc from python command and run pyodbc sql command,
everything work well.
Please help me.
Tuan Hoang Anh
On Fri, Sep 27, 2013 at 10:05 AM, John R Pierce wrote:
> On 9/26/2013 8:00 PM, tuanhoanganh wrote:
>
>>
>> I updated my laptop to windows 8.1, my Pos
Hello all.
I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit.
But my plpython function have "ERROR: ImportError: DLL load failed: A
dynamic link library (DLL) initialization routine failed." after import
pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc ver
On Thu, Jan 3, 2013 at 11:52 AM, Craig Ringer wrote:
> What's your host Windows OS? Windows Server 2008 R2? Windows 7?
>
I am runing Windows Server 2008 R2
On Thu, Jan 3, 2013 at 11:04 AM, John R Pierce wrote:
> of course, a pooler only works right if the client applications are
> modified to open a connection, do a transaction, and close the connection.
> if the clients continue to hold idle connections, the pooler won't do
> anything useful for y
On Thu, Jan 3, 2013 at 10:45 AM, Craig Ringer wrote:
> Running PostgreSQL directly via pg_ctl, not as a service, will not
> change how it performs under load at all. It will not help you service
> more than 500 concurrent connections.
>
> You really need to put a connection pool in place to limit
Hello all.
I have more than 500 users connect to Postgres in windows 2008 R2. I
change registry make postgres service support 512 connect. But is there any
good way make postgres run as process not service. Is it safe run postgres
as process in windows.
Thank you very much (sorry for my English)
Is there link to download pldbgapi.dll on postgresql 9.2 x64 on windows
Thanks in advance
Tuan Hoang Anh
On Fri, Sep 14, 2012 at 9:29 PM, Albe Laurenz wrote:
> Fabrízio de Royes Mello wrote:
> >> Has it moved somewhere else?
>
> > Look at the pldebugger git repository in [1].
>
> Thanks!
>
> La
I had same problem too.
My laptop : Windows 7 Pro 64bit and postgresql-9.2.0-1-windows-x64.exe.
But it ok when I install postgresql-9.2.0-1-windows.exe on my server
windows 2003 Ent 32 bit.
On Thu, Sep 13, 2012 at 12:59 PM, John R Pierce wrote:
> On 09/12/12 10:42 PM, Dann Corbit wrote:
>
>>
>
;logging_collector";"on"
"maintenance_work_mem";"1GB"
"max_connections";"100"
"max_locks_per_transaction";"2000"
"max_stack_depth";"2MB"
"max_wal_senders";"5"
"port";"5433"
&qu
700, tuanhoanganh wrote:
> > Hello
> > I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
> > When i view Postgresql status, there are some autovaccum alway run.
> > Ex VACUUM ANALYZE pg_catalog.pg_attribute.
> >
> >
> > Is it problem of PostgreSQL? Pl
Hello
I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
When i view Postgresql status, there are some autovaccum alway run.
Ex VACUUM ANALYZE pg_catalog.pg_attribute.
Is it problem of PostgreSQL? Please help me.
Tuan Hoang Anh.
I have same problem too.
Tuan Hoang Anh
On Thu, Apr 19, 2012 at 10:43 PM, Efraín Déctor
wrote:
> Any help will be appreciated.
>
> Thanks.
>
> *From:* Efraín Déctor
> *Sent:* Wednesday, April 18, 2012 1:32 PM
> *To:* pgsql-general@postgresql.org
> *Subject:* pgstat wait timeout
>
> Hello l
I am running windows 2003 R2 (64 bit) - PostgreSQL 9.0.6 - 64bit.
Today PostgreSQL has alot pgstat wait timeout in log.
How to fix the PostgreSQL WARNING??
Tuan Hoang ANh
http://winpg.jp/~saito/pgbouncer/
On Fri, Jan 20, 2012 at 11:01 PM, Edison So wrote:
> Hello,
>
> Can anyone please tell me where I can find the PGbouncer executable and
> tutorial for Windows 2008? I found one but need to recompile on Windows. I
> also need intuitive instructions to configure i
lease let us know what problem you are facing.
>
> Thanks
> Venkat
>
>
> On Tue, Sep 27, 2011 at 12:08 PM, tuanhoanganh wrote:
>
>> I am running PostgreSQL 9.0.1 32bit on windows 2003. Last night my disk
>> had some problem and i lost some file in data\global.
>> Is there anyway to recovery postgresql.
>>
>> Thanks in advance. Sorry for my English.
>>
>> Tuan Hoang Anh
>>
>
>
I am running PostgreSQL 9.0.1 32bit on windows 2003. Last night my disk had
some problem and i lost some file in data\global.
Is there anyway to recovery postgresql.
Thanks in advance. Sorry for my English.
Tuan Hoang Anh
You can use SymmetricDS to replicate on PostgreSQL, Oracle, SQL Server
database.
On Thu, Aug 25, 2011 at 11:07 AM, Shoaib Mir wrote:
> On Thu, Aug 25, 2011 at 2:03 PM, Adarsh Sharma
> wrote:
>
>> Dear all,
>>
>> I am using PostgresPlus-8.4SS version of Postgres on Linux & Windows
>> Systems.
>
I am running PostgreSQL 9.01 on windows 2008, RAID 10 with 4 disk.
Yesterday, one of 4 disks RAID 10 error and I copy data directory to
USB.
Today, When I start postgresql i have error log
2011-05-24 17:20:01 ICT LOG: database system was shut down at
2011-05-24 02:40:49 ICT
2011-05-24 17:20:01 I
Yesterday, I had some problem with postgresql 9.0.2. Today i backup postgres
and has error
pg_dump: reading dependency data
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 299
of relation "pg_depend_depender_index"
pg_dump: The command was: SELE
I have postgresql 8.3.9 install on my server, this service run with user
postgres and it start well
On Wed, Jan 26, 2011 at 3:58 PM, tuanhoanganh wrote:
> Yesterday, my postgresql 9.0 service run well with user postgres. But today
> when it start, it have error "The service did not
Yesterday, my postgresql 9.0 service run well with user postgres. But today
when it start, it have error "The service did not respond to the start or
control request in a timely fashion."
When I change my user start service to "Local System Account" and check
"Allow service to interact with deskto
21, 2011 at 8:58 PM, Christian Ullrich wrote:
> * tuanhoanganh wrote:
>
> Here is procmon i thinks error
>>
> [some procmon events]
>
> No, that is all OK. The event at 2:39:55.7588651 is where Postgres starts
> cmd.exe to perform the copy. The really interesting data would
hen PostgreSQL runs, it will shed any rights given through
>> "Administrators" or "Power Users" group. So this is not an identical
>> test.
>>
>
> We cannot assume that the one-click installer was used, but if it was, the
> service account it creates will be a member of the Users group only.
>
> tuanhoanganh, what did you download to install Postgres?
>
> --
> Christian
>
NO, D is local driver.
I setup PITR from 01/01/2011. It work well from 01->05/01/2011
(D:/3SDATABACKUP/PITR/WAL has 00010004005D) but error from
06/01/2011
On Thu, Jan 20, 2011 at 3:56 AM, John R Pierce wrote:
> On 01/19/11 9:23 AM, tuanhoanganh wrote:
>
>>
>>
:
> * tuanhoanganh wrote:
>
> My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011
>> postgresql log have issue
>>
>
> 2011-01-06 08:27:54 ICT LOG: archive command failed with exit code 1
>> 2011-01-06 08:27:54 ICT DETAIL: The failed arc
My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011 postgresql
log have issue
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table
"pg_temp_19"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table
"pg_temp_49"."tmpct70s" i
120: 5 unresolved externals
My ActivePerl version :"This is perl, v5.10.1 built for
MSWin32-x86-multi-thread"
How to fix it?
Please help me. Thanks in advance
Tuan Hoang ANh
On Wed, Jan 5, 2011 at 10:32 AM, tuanhoanganh wrote:
> Thanks you very much
> Here is my config.pl
>
Can PLPerl make ODBC connect.
I have perl test connect. It work well
use DBI;
my $h = DBI->connect(
'dbi:ODBC:DRIVER=SQL
Server;Server=127.0.0.1;Database=TEST;Uid=sa;Pwd=abc123ABC;Port=1433',
'sa',
'abc123ABC',
{ AutoCommit => 1, RaiseError => 1, }
) or die "Did not connect to db.";
On Tue, Jan 4, 2011 at 19:27, tuanhoanganh wrote:
> > Thanks for answer me but it have error
> >
> > Detected Visual Studio version 8.00
> > Detected hardware platform: Win32
> > Generating win32ver.rc for src\backend
> > Building src\pl\plperl\SPI.c..
eate SPI.c.
Please help me.
Tuan Hoang ANh
On Wed, Jan 5, 2011 at 9:14 AM, Alex Hunsaker wrote:
> On Tue, Jan 4, 2011 at 10:12, tuanhoanganh wrote:
> > I has set config.pl to
> > $config->{perl};
> > 1;
>
> I don't know anything about the windows build s
I has set config.pl to
$config->{perl};
1;
and run build.bat, everything is ok, there is plpgsql.dll but don't found
plperl.dll.
I use strawberry perl 5.10 or must I use ActiveState Perl.
Please help me. Thank in advance
Tuan Hoang ANh
postgers to full
access. Everything work fine.
Thanks you very much. Sorry for my English.
Tuan Hoang ANh.
On Sat, Jan 1, 2011 at 5:18 PM, John R Pierce wrote:
> On 01/01/11 1:50 AM, tuanhoanganh wrote:
>
>> Is by any chance D: a network mapped drive in Windows ?
>> No, D is
Is by any chance D: a network mapped drive in Windows ?
No, D is a driver on master computer. I can copy 000100030056
file from postgresql data\pg_xlog to D:/3SDATABACKUP/PITR
On Sat, Jan 1, 2011 at 4:30 PM, John R Pierce wrote:
> On 01/01/11 1:23 AM, tuanhoanganh wr
I setup my PostgreSQL 9.0.1 Stream Replication.
Here is my config of master database address 192.168.5.4
pg_hba.conf
# IPv4 local connections:
hostall all 0.0.0.0/0trust
# IPv6 local connections:
hostall all
You can test restore by change CREATE OR REPLACE PROCEDURAL LANGUAGE
plpgsql; to CREATE PROCEDURAL LANGUAGE plpgsql;
Tuan Hoang Anh
2010/12/15 Andrus Moor
> Server is
>
> PostgreSQL 8.4.3 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian
> 4.3.2-1.1) 4.3.2, 32-bit
>
> Backup is created
e, Dec 14, 2010 at 8:55 PM, Ivan Voras wrote:
> On 14/12/2010 14:51, tuanhoanganh wrote:
>
>> Thanks for your help.
>> Is there any .Net or VB tutorial new 9.0 bytea?
>>
>
> You do not need to change your code if you add
>
> bytea_output = 'e
Thanks for your help.
Is there any .Net or VB tutorial new 9.0 bytea?
Tuan Hoang Anh
On Tue, Dec 14, 2010 at 1:27 PM, Mark Felder wrote:
> On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh
> wrote:
>
> I have program work with bytea, this field store image. Program wor
I have program work with bytea, this field store image. Program work well in
postgresql 8.3.9 but error in postgresql 9.0
Here is code to write image to database
FileStream srcStream = new FileStream(file_name, FileMode.Open,
FileAccess.Read);
byte[] arrImage = new byte[srcStream.Length];
int read
I have program work with bytea, this field store image. Program work well in
postgresql 8.3.9 but error in postgresql 9.0
Here is code to write image to database
FileStream srcStream = new FileStream(file_name, FileMode.Open,
FileAccess.Read);
byte[] arrImage = new byte[srcStream.Length];
int read
I have same question
My Computer is running POS with Postgres 8.9.11 database
Ram : 16GB
OS : Windows 2008 R2
CPU XEON 2G
User : 50-60 user (connect ~ 200 connects, I increase Windows
SharedSection=1024,20480,1024 for > 125 connects).
DISK : RAID 1
What will be good settings for DB parameter
Can anyone answer me ?
Thanks you very much
Tuan Hoang Anh
On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh wrote:
> I tried to do pitr backup using Postgres 8.3.9 on windows. So I issued
> SELECT pg_start_backup('test');
> After I put the db in backup mode I tried to zip
I tried to do pitr backup using Postgres 8.3.9 on windows. So I issued
SELECT pg_start_backup('test');
After I put the db in backup mode I tried to zip the data directory files
with 7z. However I encountered the following errors:
The process cannot access the file because it is being used by anoth
What is the name of DW in --type=DW
Sorry for my English.
Tuan Hoang Anh
On Mon, Aug 9, 2010 at 6:21 PM, Amitabh Kant wrote:
> 2010/8/9 Sim Zacks
>
>
>>
>> I just found out about pgtune and am trying it out on my server.
>>
>>
>> I have 2.5 questions:
>>
>> 1) Are these settings the maximum th
I have checked SHOW fsync, It is ON.
When I view table dmvt on PgAdmin, it only has 1332 rows, but command
"SELECT count(*) FROM dmvt" return 2449 rows.
My postgresql.conf is default of EnterpriseDB Postgres 8.3.9.
Please help me. Sorry for my English.
Tuan Hoang Anh.
On Mon, Jul 19, 2010 at 9:
xisting shared memory block is still in
use
2010-07-19 17:32:46 ICTHINT: Check if there are any old server processes
still running, and terminate them.
Is there anyway to fix it.
On Mon, Jul 19, 2010 at 5:00 PM, tuanhoanganh wrote:
> Yes, I don't have backup.
>
> On
Yes, I don't have backup.
On Mon, Jul 19, 2010 at 4:24 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to tuanhoanganh :
> > Is there anyway to rescue data afer power off.
> > I have postgres database version 8.3.9 on windows 2003.
> >
Is there anyway to rescue data afer power off.
I have postgres database version 8.3.9 on windows 2003.
Yesterday my server is power off, when i start server, some of table is
blank. Is there anyway to rescue it.
Please help me. I am very confuse.
Tuan Hoang Anh
ogram Files\PostgreSQL\8.3\bin\pg_dump.exe" -h192.168.0.1 -Upostgres
-W -p5433 -Fp -C -fmyacc.out myacc --> have error
I test with dump on PgAdmin. It have error too.
Please help me.
Thank you.
Sorry for my english.
On Wed, Aug 20, 2008 at 2:40 AM, Alvaro Herrera
<[EMAIL PROTECTED]>wr
I have a problem with pg_dump on 2 computers. On the first computer, pg_dump
runs very well, but on the second pg_dump has a error :
pg_dump: reading triggers for table "ph57"
pg_dump: reading triggers for table "phts"
pg_dump: reading dependency data
pg_dump: SQL command failed
pg_dump: Error mess
I have a array function
CREATE OR REPLACE FUNCTION "temp".rowfromarray(text[])
RETURNS SETOF text AS
$BODY$DECLARE
_returntext;
BEGIN
for i in 1..array_upper($1,1) loop
_return := $1[i];
return next _return;
end loop;
return;
END;$BODY$
LANGUAGE 'plpgsql' VOL
On 2/22/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> tuanhoanganh <[EMAIL PROTECTED]> writes:
> > ... But when I dump database and restore to 8.3 this function change to
>
> > CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
>
> It works as expected for me. P
I have function in PostgreSQL 8.2
CREATE OR REPLACE FUNCTION post_ctpxd(ud_stt_rec)
RETURNS void AS
$BODY$DECLARE
...
BEGIN
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
My domain in 8.2
CREATE DOMAIN ud_stt_rec
AS character(20)
DEFAULT ''::bpchar
NOT NULL;
But when I dump databa
59 matches
Mail list logo
