| From: | Mike Broers <mbroers(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | starting postgres with an empty px_xlog folder | 
| Date: | 2012-06-23 12:01:08 | 
| Message-ID: | CAB9893hwy2z+g9KFGbZP7uao9+5Wq2Kc9o8r6d=-X=NF_bE+YA@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Hello,
We shut down our postgres 8.3 server last night cleanly for some hosted
services maintenance.  When we got our server back, it didnt have the
pg_xlog mount with files and now when we start the server, it complains:
2012-06-23 06:06:04 CDT [18612]: [1-1] user=,db= LOG:  database system was
shut down at 2012-06-22 23:56:16 CDT
2012-06-23 06:06:04 CDT [18612]: [2-1] user=,db= LOG:  could not open file
"pg_xlog/0000000100000A0100000040" (log file 2561, segment 64): No such
file or
 directory
2012-06-23 06:06:04 CDT [18612]: [3-1] user=,db= LOG:  invalid primary
checkpoint record
2012-06-23 06:06:04 CDT [18612]: [4-1] user=,db= LOG:  could not open file
"pg_xlog/0000000100000A0100000040" (log file 2561, segment 64): No such
file or
 directory
2012-06-23 06:06:04 CDT [18612]: [5-1] user=,db= LOG:  invalid secondary
checkpoint record
2012-06-23 06:06:04 CDT [18612]: [6-1] user=,db= PANIC:  could not locate a
valid checkpoint record
2012-06-23 06:06:04 CDT [18609]: [1-1] user=,db= LOG:  startup process (PID
18612) was terminated by signal 6: Aborted
2012-06-23 06:06:04 CDT [18609]: [2-1] user=,db= LOG:  aborting startup due
to startup process failure
Since we had a clean shut down is there an easy or relatively clean way to
start back up?  the pg_xlog folder is there, just with no files.  i wouldnt
think it would be needed for a clean restart.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Broers | 2012-06-23 12:49:25 | Re: starting postgres with an empty px_xlog folder | 
| Previous Message | Craig Ringer | 2012-06-23 11:12:24 | Re: [ADMIN] Issue in save and retreive file in postgres |