> > 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
Don't do pg_resetlogs. If you have archives, please find for the file which has pointed in logs copy it to $PGDATA/pg_xlog location and start the server. Sometime, server will throw the sequence of files like 41,42...., not existing, you need to copy all of them to pg_xlog location and start it. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Sat, Jun 23, 2012 at 6:19 PM, Mike Broers <mbro...@gmail.com> wrote: > 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 <mbro...@gmail.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]: [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. >> >> >> >
