Serious trouble with my postgresql

[Mário Gamito]

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:

# [***@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
[***@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Tom Lane]

Post by Mário Gamito
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org