Skip site navigation (1) Skip section navigation (2)

Re: starting postgres with an empty px_xlog folder

From: Mike Broers <mbroers(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: starting postgres with an empty px_xlog folder
Date: 2012-06-23 12:49:25
Message-ID: CAB9893ii=xiKhSWpJCOsFUO3Lk18-OgnAPJa3B6KyU21SUGj=Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I was able to duplicate the error in a test environment and get the
database started back up wtih the pg_resetxlog $PGDATA command, but i am
concerned about the fallout and not sure if i need to use any of the option
switches.  We also have archived log files up to the point of server
shutdown if that provides a better option.



On Sat, Jun 23, 2012 at 7:01 AM, Mike Broers <mbroers(at)gmail(dot)com> wrote:

> 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.
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: RaghavendraDate: 2012-06-23 13:36:34
Subject: Re: starting postgres with an empty px_xlog folder
Previous:From: Mike BroersDate: 2012-06-23 12:01:08
Subject: starting postgres with an empty px_xlog folder

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group