| Lists: | pgsql-admin |
|---|
| From: | -=TopCat=- <topcat(at)admin(dot)net(dot)pl> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Help I ve just delete pg_xlog |
| Date: | 2002-03-29 12:29:20 |
| Message-ID: | Pine.LNX.4.44.0203291323570.28930-100000@gnom.troll.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
and now I ve got ...
DEBUG: database system was shut down at 2002-03-29 09:37:28 CET
DEBUG: open(logfile 15 seg 167) failed: Nie ma takiego pliku ani katalogu
DEBUG: Invalid primary checkPoint record
DEBUG: open(logfile 15 seg 165) failed: Nie ma takiego pliku ani katalogu
DEBUG: Invalid secondary checkPoint record
FATAL 2: Unable to locate a valid CheckPoint record
/usr/local/pgsql/bin/postmaster: Startup proc 19828 exited with status 512 - abort
What can I do
I know I should have backup but I have a liitle damage with this
SO
...
I initdb new directory and I will start to recovery everything step by
step
but maybe there is any option to restore this from old directory (all data
I have - I cannot start postmaster only)
+------------------+----------------------------------------------------+
| .--. | Andrzej Slomka |
| |o_o | | topcat(at)admin(dot)net(dot)pl |
| /_ / | | topcat(at)troll(dot)com(dot)pl |
| // \ \ | |
| (| | ) +----------------------------------------------------+
| (~\- -/~) | |
| \###)==(###/ | To be root or not be ...........??!! |
+------------------+----------------------------------------------------+
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | topcat(at)admin(dot)net(dot)pl |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Help I ve just delete pg_xlog |
| Date: | 2002-04-02 20:39:42 |
| Message-ID: | 27615.1017779982@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
That was a bad move ... but you might be able to recover, at least in
part, by running contrib/pg_resetxlog.
regards, tom lane