Re: Problems starting the database

gborges(at)radiumsystems(dot)com(dot)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 I used 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