Skip site navigation (1) Skip section navigation (2)

Re: Trigger File Behaviour

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Jody McIntyreDate: 2011-02-21 17:26:45
Subject: Heartbeat + pacemaker configuration for PostgreSQL log shipping
Previous:From: Selva manickarajaDate: 2011-02-21 01:04:43
Subject: Re: Trigger File Behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group