Search Postgresql Archives

Re: Failover on Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Oct 29, 2010 at 9:58 PM, Norberto Delle <betodelle@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux