Serious trouble with my postgresql
Serious trouble with my postgresql
От:
Mário Gamito <gamito@netual.pt>
Дата:
Hi, After i've imported a text file into postgresql, apparently with success, because it responded "COPY", postgresql died after i left its prompt and never restarted again. Meanwhile, i guess i've screwed up :( and erased two files with 0 bytes, something like 0000000000000001, i can't remember quite well. Now, if i run as user postgres the command: # [postgres@nau pg_xlog]$ /usr/bin/postmaster -D /usr/bin/postmaster -D /var/lib/pgsql/data i get this error: "LOG: could not create IPv6 socket: Address family not supported by protocol LOG: database system was shut down at 2004-09-08 16:09:16 WEST LOG: could not read from log file 0, segment 1 at offset 4153344: Success LOG: invalid primary checkpoint record LOG: could not read from log file 0, segment 1 at offset 4112384: Success LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 15082) was terminated by signal 6 LOG: aborting startup due to startup process failure [postgres@nau pg_xlog]$" Is this recoverable ? At least, can i recever the contents of the databases (remember i cannot start postgresql) in some way, so i can reinstall postgresql from scratch and insert the databases again ? How ? Any help would be appreciated. Warm Regards, Mário Gamito
Re: Serious trouble with my postgresql
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
=?ISO-8859-1?Q?M=E1rio_Gamito?= writes: > Meanwhile, i guess i've screwed up :( and erased two files with 0 bytes, > something like 0000000000000001, i can't remember quite well. That was a bad move. Start over, and next time don't assume that you can remove random pieces of the database without consequence. (You could possibly try pg_resetxlog, but given that you were having problems before you did that, I wouldn't care to assume that you'll get a consistent database that way.) regards, tom lane