Le 2013-06-07 à 12:00, François Beausoleil a écrit :
Le 2013-06-07 à 07:00, François Beausoleil a écrit :
Le 2013-06-06 à 18:40, Michael Paquier a écrit :
I believe I know what my mistake is: I set trigger_file to /var/lib/postgresql/9.1/main/recovery.done -- and PostgreSQL doesn't seem to like that name. I should set to another name and retry.
It's still strange that pg_ctl promote didn't work though. Maybe because recovery.done existed at the time I tried.
I'll try again today, with better names.
Okay, here's my new recovery.conf:
standby_mode = on
restore_command = '/usr/local/omnipitr/bin/omnipitr-restore -D /var/lib/postgresql/9.1/main/ --source gzip=/var/backups/seevibes/wal/dbanalytics.production/ --remove-unneeded --temp-dir /var/tmp/omnipitr -l /var/log/omnipitr/restore.log --error-pgcontroldata hang --pgcontroldata-path /usr/lib/postgresql/9.1/bin/pg_controldata "%f" "%p"'
trigger_file = '/var/lib/postgresql/9.1/main/trigger-promotion'
archive_cleanup_command = '/usr/local/omnipitr/bin/omnipitr-cleanup --log /var/log/omnipitr/cleanup.log --archive gzip=/var/backups/seevibes/wal/dbanalytics.production "%r"'
Notice trigger_file has a better name. I touch the file using:
sudo -u postgres touch /var/lib/postgresql/9.1/main/trigger-promotion
and nothing happens: no messages appear in the log, PostgreSQL continues to apply WAL records.
I've just retried pg_ctl promote, and that too didn't do anything. I'm really at a loss to explain what happens.
I answered my question. I use OmniPITR, and I forgot to include the --finish-recovery flag, pointing to the trigger file.
Bye,
François
