Re: Trigger File Behaviour - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Trigger File Behaviour
Date
Msg-id 4D6203E8.1050400@lelarge.info
Whole thread Raw
In response to Re: Trigger File Behaviour  (Selva manickaraja <mavles78@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Selva manickaraja
Date:
Subject: Re: Trigger File Behaviour
Next
From: Jody McIntyre
Date:
Subject: Heartbeat + pacemaker configuration for PostgreSQL log shipping