starting postgres with an empty px_xlog folder

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-admin by date

  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