where is pg_resetxlog ?

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

Responses

Browse pgsql-general by date

  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