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

From: jgenoese <john(at)memoriesdreamsandreflections(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Ubuntu 11.10 Postgres 9.1.3 is missing pg_resetxlog; where can I get it?
Date: 2012-03-18 18:41:15
Message-ID: 1332096075287-5575465.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings.

I installed postgresql-9.1 via apt-get on ubuntu 11.10.

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

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"?

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2012-03-18 18:45:19 Re: How to perform full text search
Previous Message Janning Vygen 2012-03-18 17:00:37 Anonymized database dumps