| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Kyle Wilcox" <Kyle(dot)Wilcox(at)noaa(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fail to connect after server crash |
| Date: | 2008-01-04 18:41:22 |
| Message-ID: | dcc563d10801041041u14c53590o421002e9de40f473@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jan 4, 2008 11:46 AM, Kyle Wilcox <Kyle(dot)Wilcox(at)noaa(dot)gov> wrote:
> Checked some logs and a backup job was running at the same time as the
> insertions. Must have been the backup job locking a file. Is there a
> way to get the server to restart or should I reinstall?
Seeing as your backup program appears to have corrupted your database,
I'd say blowing away the PGDATA dir and running a new initdb is the
answer (not reinstalling).
Then you need to disable your backup job that caused this problem.
And shoot the person who set it up. Or not. That last step is
strictly optional. :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | O'Shea, Brendan | 2008-01-04 18:42:31 | Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 |
| Previous Message | Andrew Sullivan | 2008-01-04 18:08:42 | Re: [OT] Slony (initial) Replication - Slow |