Re: [HACKERS] Major Problem, need help! Can't run our website!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Tim Allen <tim(at)proximity(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] Major Problem, need help! Can't run our website!
Date: 2005-11-15 04:17:58
Message-ID: 6227.1132028278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Would it be wise or insane for us to to mention in the startup error a
> HINT that if you've removed such files, only hope is full restore from
> backup or pg_resetxlog with data loss?

Not sure that we should have a HINT recommending a worst-case-scenario
course of action as the first resort. We'll have people blowing away
their data for what might be relatively fixable problems (eg, bogus
permissions on the pg_xlog directory, which I think was an issue that
just came up a day or two ago ...)

(We're all really jumping to conclusions here anyway. The guy may have
been foolish to remove xlog files, but that doesn't explain why his
postmaster isn't running. There's some facts missing in that report.)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rod Taylor 2005-11-15 04:32:14 Re: [HACKERS] Major Problem, need help! Can't run our
Previous Message ITS ONT Alcazar, Jose Aguedo C 2005-11-15 04:08:55 Re: Major Problem, need help! Can't run our website!

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2005-11-15 04:32:14 Re: [HACKERS] Major Problem, need help! Can't run our
Previous Message Christopher Kings-Lynne 2005-11-15 04:05:17 Re: [HACKERS] Major Problem, need help! Can't run our website!