Re: Problems starting the database - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problems starting the database
Date
Msg-id 29987.1047509191@sss.pgh.pa.us
Whole thread Raw
In response to Problems starting the database  (gborges@radiumsystems.com.br)
List pgsql-admin
gborges@radiumsystems.com.br writes:
> A kernel panic ocurred with my machine.

> So, I have to recover my postgresql data directory. I copy the data directory to a new instalation (same version that
Iused before). 

Did you forget to copy pg_xlog/ ?  Or did the kernel crash lose those files?

> There is some way to ignore this problem and start the postgres? I only want to start the database to do a pg_dump.

You can run pg_resetxlog, but you'll need to manually inspect your
dumped data to see if you have any partially-committed recent
transactions.

            regards, tom lane

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Help with determining a database's size
Next
From: Tom Lane
Date:
Subject: Re: I cannot get the db to initialize. Please help.