restore_command is not running on my standby

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: restore_command is not running on my standby
Date: 2012-03-14 02:07:26
Message-ID: jjougv$2e8d$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have twice set up pg hot standbys ala the docs at
http://www.postgresql.org/docs/9.1/interactive/hot-standby.html

The third time I'm trying this I'm running into trouble. The first two
times were with actual servers. This time I'm trying to set up two pg
instances on my desktop for testing.

First I create the secondary:

[jks(at)jks-desktop ~/work/pgmon]{f15}$ time pg_basebackup -D repl-db -P -h
localhost -U replicator
59303/59303 kB (100%), 1/1 tablespace
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived

real 0m1.725s
user 0m0.061s
sys 0m0.265s

Then I copy in recovery.conf and the replacement postgresql.conf and try
to start up. I get:

LOG: database system was interrupted; last known up at 2012-03-13
21:29:32 EDT
LOG: could not open file "pg_xlog/00000001000000000000003D" (log file
0, segment 61): No such file or directory
LOG: invalid checkpoint record
FATAL: could not locate required checkpoint record
HINT: If you are not restoring from a backup, try removing the file
"/home/jks/work/pgmon/repl-db/backup_label".
LOG: startup process (PID 28220) exited with exit code 1
LOG: aborting startup due to startup process failure

Now the file 00000001000000000000003D does exist in the archive
directory, but it appears that restore_command is not being run.
Originally it was:
'cp /home/jks/work/pgmon/wal_drop/%f %p'

Then I changed it to:

restore_command = 'echo f %f p %p >> /tmp/rc.log ; cp
/home/jks/work/pgmon/wal_drop/%f %p'

/tmp/rc.log was never created, so I assume the whole thing isn't being
run for some reason. Any clues where I should look?

version is:
PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.6.1 20110908 (Red Hat 4.6.1-9), 64-bit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fujii Masao 2012-03-14 02:30:05 Re: restore_command is not running on my standby
Previous Message John R Pierce 2012-03-14 01:32:03 Re: Upgrade questions