Hi all;
I'm trying to restore from a tar of the filesystem on a debian box and I get
xlog errors.
I suspect I need to run pg_resetxlog but I cannot find it anywhere, where would
I find pg_resetxlog on a debian box that was installed via the deb packages ?
or how do I get it ?
Thanks in advance.. here's my log startup messages in case it helps:
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16042]: [1-1] time:2009-07-25
18:40:17.446 UTC database: LOG: could not load root certificate file
"root.crt": no SSL error reported
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16042]: [1-2] time:2009-07-25
18:40:17.446 UTC database: DETAIL: Will not verify client certificates.
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [2-1] time:2009-07-25
18:40:17.653 UTC database: LOG: database system was shut down at 2009-07-23
01:18:04 UTC
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [3-1] time:2009-07-25
18:40:17.653 UTC database: LOG: could not open file
"pg_xlog/00000001000004B6000000C7" (log file 1206, segment
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [3-2] 199): No such file or
directory
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [4-1] time:2009-07-25
18:40:17.653 UTC database: LOG: invalid primary checkpoint record
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [5-1] time:2009-07-25
18:40:17.653 UTC database: LOG: could not open file
"pg_xlog/00000001000004B6000000C7" (log file 1206, segment
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [5-2] 199): No such file or
directory
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [6-1] time:2009-07-25
18:40:17.653 UTC database: LOG: invalid secondary checkpoint record
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16043]: [7-1] time:2009-07-25
18:40:17.653 UTC database: PANIC: could not locate a valid checkpoint record
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16042]: [2-1] time:2009-07-25
18:40:17.653 UTC database: LOG: startup process (PID 16043) was terminated by
signal 6: Aborted
Jul 25 18:40:17 ux-dbs01-atl2 postgres[16042]: [3-1] time:2009-07-25
18:40:17.653 UTC database: LOG: aborting startup due to startup process
failure