Re: Failover on Windows

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Norberto Delle <betodelle(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Failover on Windows
Date: 2010-11-01 11:00:22
Message-ID: AANLkTimqtWrw8BcYAWTinZhgMjV=r6avLBrVqvhMHp3b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 29, 2010 at 9:58 PM, Norberto Delle <betodelle(at)gmail(dot)com> wrote:
> I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2.

What command (pg_standby? cp?) is supplied in restore_command for warm-standby?
Or you are testing streaming replication + hot standby?

> The problem is that when I put the trigger file on the location specified in
> the parameter
> 'trigger_file' of the recovery.conf, nothing happens. No log entries, the
> recovery just continues
> as if nothing has happened.
> Any clues of what may be wrong?

At least if you use pg_standby, you have to create the trigger file on
the location
specified in -t option of pg_standby.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-11-01 11:33:44 Re: Temporary schemas
Previous Message Thomas Kellerer 2010-11-01 10:46:59 Temporary schemas