Search Postgresql Archives

Re: Fail to connect after server crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jan 4, 2008 11:46 AM, Kyle Wilcox <Kyle.Wilcox@xxxxxxxx> 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.  :-)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux