Re: Trigger File Behaviour

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.fr
 http://dalibo.com