| From: | Ravi Kumar <postgres(dot)query(at)yahoo(dot)in> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How to restore backup |
| Date: | 2012-11-15 10:18:22 |
| Message-ID: | 1352974702.81341.YahooMailNeo@web193105.mail.sg3.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Dear all ,
when i am trying to restore backup from WAL files ,the following error came:
cannot stat `/opt/pgsqlbackup/wals/00000001.history': No such file or directory
LOG: restored log file "000000010000000000000003" from archive
LOG: unexpected pageaddr 0/A000 in log file 0, segment 3, offset 40960
LOG: invalid primary checkpoint record
LOG: restored log file "000000010000000000000003" from archive
LOG: invalid xl_info in secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 5883) was terminated by signal 6: Aborted
LO:: aborting startup due to startup process failure
LOG: database system was shut down at 2012-11-16 11:56:34 IST
LOG: starting archive recovery
can you help me?
with regards
ravi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2012-11-15 16:24:30 | Re: Failed Login Attempts parameter |
| Previous Message | Albe Laurenz | 2012-11-15 09:59:24 | Re: Query Stuck in running server |