From: | Mário Gamito <gamito(at)netual(dot)pt> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Serious trouble with my postgresql |
Date: | 2004-09-14 10:06:42 |
Message-ID: | 4146C2B2.5080106@netual.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Amin | 2004-09-14 13:27:16 | Re: pg_class / missing tables |
Previous Message | Joepie Platteau | 2004-09-14 07:43:43 | Re: Trigger set to backup to other table NOT FUNCTIONING... |