Re: [ADMIN] Validade dump file

2010-10-04 Thread Guillaume Lelarge
Le 05/10/2010 05:28, Fábio Gibon - Comex System a écrit : > [...] > are there some tool or internal program that read a dump file (created by > pg_dump) and list all tables and number of tuples (without > restore) in this file? > That command should give you the number of tables in your plain d

Re: [ADMIN] [GENERAL] Data Not replicating

2010-10-04 Thread Devrim GÜNDÜZ
On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote: > LOG: unexpected EOF on client connection > ERROR: schema "_testcluster" does not exist at character 30 Did you run slonik_init_cluster? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository:

[ADMIN] Validade dump file

2010-10-04 Thread Fábio Gibon - Comex System
Hi everybody, are there some tool or internal program that read a dump file (created by pg_dump) and list all tables and number of tuples (without restore) in this file? And too, are there some tool to check the physical file integrity? (S.O. Windows) thanks Fábio Henrique Gib

Re: [ADMIN] Default session timeout in PG?

2010-10-04 Thread Scott Marlowe
On Mon, Oct 4, 2010 at 11:52 AM, Craig James wrote: > On 10/4/10 10:36 AM, Lou Picciano wrote: >> >> (Think I've seen the answer to this already, but:) is there any 'innate', >> or >>  'default' session timeout function built in to PG? >> >> We have certain clients who seem to timeout pretty frequ

Re: [ADMIN] ECPG: AUTOCOMMIT and CURSORs

2010-10-04 Thread Kevin Grittner
A J wrote: > I am seeing some funny behavior on using both: > EXEC SQL SET AUTOCOMMIT TO ON; > and > CURSORS (EXEC SQL DECLARE ., EXEC SQL FETCH NEXT FROM > .) > > On autocommit on (either through above method or precompiling with > -t option), > the cursor does not re

[ADMIN] ECPG: AUTOCOMMIT and CURSORs

2010-10-04 Thread A J
I am seeing some funny behavior on using both: EXEC SQL SET AUTOCOMMIT TO ON; and CURSORS (EXEC SQL DECLARE ., EXEC SQL FETCH NEXT FROM .) On autocommit on (either through above method or precompiling with -t option), the cursor does not return any rows. On disabling autoc

Re: [ADMIN] Default session timeout in PG?

2010-10-04 Thread Tom Lane
Lou Picciano writes: > We have certain clients who seem to timeout pretty frequently, while others > seem to never time out at all; before we start diagnosing networks, I want to > be sure there's nothing we can do server-side to ameliorate/control the > problem. > If I recall correctly, PG d

Re: [ADMIN] Default session timeout in PG?

2010-10-04 Thread Craig James
On 10/4/10 10:36 AM, Lou Picciano wrote: (Think I've seen the answer to this already, but:) is there any 'innate', or 'default' session timeout function built in to PG? We have certain clients who seem to timeout pretty frequently, while others seem to never time out at all; before we start di

[ADMIN] Default session timeout in PG?

2010-10-04 Thread Lou Picciano
Gang, (Think I've seen the answer to this already, but:) is there any 'innate', or 'default' session timeout function built in to PG? We have certain clients who seem to timeout pretty frequently, while others seem to never time out at all; before we start diagnosing networks, I want to b

Re: [ADMIN] Why are some WAL files in pg_xlog symlinks to old files?

2010-10-04 Thread Fujii Masao
On Wed, Sep 29, 2010 at 11:17 PM, Nigel wrote: > To get out of this situation, I guess I should replace the symlink in > pg_xlog with the file that's the target of the symlink, renamed with the > name of the symlink? Yes. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT O