| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Selva manickaraja <mavles78(at)gmail(dot)com> |
| Cc: | "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Trigger File Behaviour |
| Date: | 2011-02-21 06:19:20 |
| Message-ID: | 4D6203E8.1050400@lelarge.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jody McIntyre | 2011-02-21 17:26:45 | Heartbeat + pacemaker configuration for PostgreSQL log shipping |
| Previous Message | Selva manickaraja | 2011-02-21 01:04:43 | Re: Trigger File Behaviour |