Re: [GENERAL] Pgpool starting problem

2014-09-09 Thread Ellen
Hi Jay, Can you pls tell me how you resolved this issue. We are running pgpool-II version 3.3.3 Thanks. Ellen -- View this message in context: http://postgresql.1045698.n5.nabble.com/Pgpool-starting-problem-tp5803276p5818354.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread Mary Ellen Fitzpatrick
I ran the pg_resetxlog -n to test and it found the correct values. Ran it for real and it worked. Thank you for the info/help Mary Ellen BRUSSER Michael wrote: Some time ago I had a similar problem with Postgresql 7.3. If I remember correctly running pg_resetxlog helped; check out http

[GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread Mary Ellen Fitzpatrick
database. Any advise (other than not deleting important dirs) would be greatly appreciated. -- Thanks Mary Ellen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PITR for postgresql-7.3

2007-08-13 Thread Mary Ellen Fitzpatrick
100, offset 81920 failed: Success server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Do I have any options for getting around this error? Thanks Mary Ellen Scott Marlowe wrote: On 8/10/07, Mary Ellen

[GENERAL] PITR for postgresql-7.3

2007-08-10 Thread Mary Ellen Fitzpatrick
wondering if there is anyway to recover the data. The error we get when trying to access a very important table is "Invalid page header in block 51 of vuser" Any help would be appreciated. (upgrades and backups lessons learned) -- Thanks Mary Ellen ---(end of

[GENERAL] Comparing dates in 7.x

2000-11-17 Thread Ellen Spertus
After upgrading from 6.x to 7.x, the following query broke, I lost the ability to check how many days apart two DATEs are by subtracting them. What is the correct way to determine the difference between two dates in 7.x? Thank you. Ellen Spertus

[GENERAL] Is tab whitespace?

2000-08-19 Thread ellen
ROR: parser: parse error at or near ";" It succeeds if there is a space instead of a tab: ezmlm=> create table foo (bar int); CREATE Ellen Spertus