Re: [ADMIN] Point in time recovery

2011-11-23 Thread Craig Ringer
On 11/23/2011 08:39 PM, Karuna Karpe wrote: Hello, Can any one please explain me how to use PITR? Are you struggling with one particular issue with PITR setup where the documentation isn't helping? If so, please explain in more detail, making sure to include all the appropriate infor

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-23 Thread Tom Lane
David Schnur writes: > Sure; the function is created programmatically as part of schema creation, > by the same user who owns (almost) everything else in the database. The > definition looks like this: > CREATE OR REPLACE FUNCTION datastore_unpack( > data_times TIMESTAMP WITH

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-23 Thread David Schnur
Sure; the function is created programmatically as part of schema creation, by the same user who owns (almost) everything else in the database. The definition looks like this: CREATE OR REPLACE FUNCTION datastore_unpack( data_times TIMESTAMP WITH TIME ZONE[], data_v

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-23 Thread Tom Lane
David Schnur writes: > I'm seeing pg_dump [8.3.15 Windows] crash reproducibly against a particular > database. Can you provide a stack trace from the crash? There's some info about that here: http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows though

[ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-23 Thread David Schnur
I'm seeing pg_dump [8.3.15 Windows] crash reproducibly against a particular database. Searching the web, I found [ http://grokbase.com/t/postgresql.org/pgsql-general/2001/02/pg-dump-crash/06ss55h5l35jh4bnnqfigxisy534] with a response from Tom Lane suggesting that it was probably due to a bug in pg

Re: [ADMIN] Point in time recovery

2011-11-23 Thread Ian Lea
> Can any one please explain me how to use PITR? http://lmgtfy.com/?q=postgres+pitr -- Ian. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Point in time recovery

2011-11-23 Thread Simon Riggs
On Wed, Nov 23, 2011 at 12:39 PM, Karuna Karpe wrote: > Can any one please explain me how to use PITR? Yes, the docs contain a great explanation. --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin m

[ADMIN] Point in time recovery

2011-11-23 Thread Karuna Karpe
Hello, Can any one please explain me how to use PITR? Regards, karuna karpe.

Re: [ADMIN] Reg: unexpected EOF on client connection

2011-11-23 Thread white.heron white
Dear All, Since you have postgres database server. You may need to check at client desktop PCs which is connected to Postgres database. Especially the physical ethernet connection from clients Desktop PCs to ethernet connection. (if its works within company local area network) You have option:

Re: [ADMIN] Reg: unexpected EOF on client connection

2011-11-23 Thread Ian Lea
> I am new to Postgres Administration. I am getting this below mentioned error > in my pg_log and server looks in hanged state whenever this error is getting > logged. > OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server > - Jboss. > > 2011-11-22 16:57:55 IST LOG:  unexpec

[ADMIN] Reg: unexpected EOF on client connection

2011-11-23 Thread Hariraman Jayaraj
Dear Friends, I am new to Postgres Administration. I am getting this below mentioned error in my pg_log and server looks in hanged state whenever this error is getting logged. OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server - Jboss. 2011-11-22 16:57:55 IST LOG: unexp