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.
