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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
