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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin