Thread: Ubuntu 11.10 Postgres 9.1.3 is missing pg_resetxlog; where can I get it?
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.
Problem solved...user error. I can't say what was wrong, bur after the third re-install everything worked. -- 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-tp5575465p5575486.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: Ubuntu 11.10 Postgres 9.1.3 is missing pg_resetxlog; where can I get it?
From
Adrian Klaver
Date:
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.klaver@gmail.com