From: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | where is pg_resetxlog ? |
Date: | 2009-07-25 18:55:54 |
Message-ID: | 200907251255.54914.kevink@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-07-25 19:02:52 | Re: where is pg_resetxlog ? |
Previous Message | Dennis Gearon | 2009-07-25 18:12:15 | Content-Type in form variables |