Re: Ubuntu 11.10 Postgres 9.1.3 is missing pg_resetxlog; where can I get it?

On 03/18/2012 11:41 AM, jgenoese wrote:
> Greetings.
>
> I installed postgresql-9.1 via apt-get on ubuntu 11.10.

Was there another Postgres instance already installed on this machine?

>
> At first, it wouldn't start because of a missing pg_xlog directory. So I
> manually created it.

Did you initdb a new data directory?

>
> Then, it wouldn't start, because of the following:
>
>
> 2012-03-18 13:18:20 EDT LOG: database system was interrupted; last known up
> at 2012-03-18 12:17:07 EDT
> 2012-03-18 13:18:20 EDT LOG: creating missing WAL directory
> "pg_xlog/archive_status"
> 2012-03-18 13:18:20 EDT LOG: could not open file
> "pg_xlog/000000010000000000000001" (log file 0, segment 1): No such file or
> directory
> 2012-03-18 13:18:20 EDT LOG: invalid primary checkpoint record
> 2012-03-18 13:18:20 EDT LOG: could not open file
> "pg_xlog/000000010000000000000001" (log file 0, segment 1): No such file or
> directory
> 2012-03-18 13:18:20 EDT LOG: invalid secondary checkpoint record
> 2012-03-18 13:18:20 EDT PANIC: could not locate a valid checkpoint record
> 2012-03-18 13:18:20 EDT LOG: startup process (PID 3343) was terminated by
> signal 6: Aborted
> 2012-03-18 13:18:20 EDT LOG: aborting startup due to startup process
> failure
>
> After searching, I found a recommendation to execute 'pf_resetxlog', but
> that utility is nowhere to be found, even by using 'find' on the entire HDD.
>
> Now I am at a standstill.
>
> Where can I find ''pg_resetxlog"?

Should be in the $PG_BIN/ with the other commands initdb, psql, creatdb,
etc.
Before you do that I would spend some time determining exactly what your
situation is. The missing pg_xlog error earlier would seem to indicate
potentially bigger issues.

>
>
> Many thanks for any help.
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Ubuntu-11-10-Postgres-9-1-3-is-missing-pg-resetxlog-where-can-I-get-it-tp5575465p5575465.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com