Quick Links

Re: Postgresql - 8.3 Replication in windows

From:	dinesh kumar <dineshkumar02(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Postgresql - 8.3 Replication in windows
Date:	2012-11-02 14:02:23
Message-ID:	CALnrH7oA3RK8DdG+wQaoWZBmNXFSYS3NQNxPsY3esOoz_FuW+A@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi ,

In windows we do not have SCP/RSYNC utility commands, which helps us to
send the archives to remote/slave server.

I hope the below settings will help you while setting replication ..

Primary
======
archive_command = 'copy %p \\\\<Slave Server>\\Archive_Location\\%f'

Slave
=====
trigger_file = 'C:\\.trigger.5432'
restore_command = 'copy \\\\<Slave Server Archive_Location>\\%f %p'

And also, make sure your Primary windows firewall is accepting a connection
from the salve server.

	From	Date	Subject
Next Message	Shaun Thomas	2012-11-02 14:14:44	Re: Unexplained Major Vacuum Archive Activity During Vacuum
Previous Message	Chris Angelico	2012-11-02 13:17:37	Re: How to find out if the server is postgres slave ??