Le 21/02/2011 02:04, Selva manickaraja a écrit :
> I encountered a small issue when I run the script in the old-primary. The
> "SELECT pg_start_backup...." part of the script will fail since the
> postgres service has been stopped. Is this error meant to happen?
>
The "SELECT pg_start_backup... rsync... SELECT pg_stop_backup" must
happen on the new primary. The psql comand probably needs a "-h
new.primary.hostname" switch.
--
Guillaume
http://www.postgresql.frhttp://dalibo.com