Thread: Problems starting the database

Problems starting the database

From
gborges@radiumsystems.com.br
Date:
Hi!

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
usedbefore). 

When I try to start the message below appers in my log file.

DEBUG:  database system was interrupted at 2003-03-05 23:28:13 BRT
DEBUG:  open of /var/lib/pgsql/data/pg_xlog/00000000000000DE (log file 0, segment 222) failed: No such file or
directory
DEBUG:  invalid primary checkpoint record
DEBUG:  open of /var/lib/pgsql/data/pg_xlog/00000000000000DE (log file 0, segment 222) failed: No such file or
directory
DEBUG:  invalid secondary checkpoint record
FATAL 2:  unable to locate a valid checkpoint record
DEBUG:  startup process (pid 8370) exited with exit code 2
DEBUG:  aborting startup due to startup process failure

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

Thnks a lot.
Gustavo B. Oliveira
RadiumSystems.com

Re: Problems starting the database

From
Tom Lane
Date:
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