Re: Postgresql - 8.3 Replication in windows

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.

Best Regards,
Dinesh
manojadinesh.blogspot.com

On Fri, Nov 2, 2012 at 1:35 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 11/02/12 12:53 AM, raghu ram wrote:
>
>>
>>
>> Can you please tell me , how to set up replication in win7,
>> without slony tool..
>>
>>
>> Below URL provides a configuration steps of Slony Replication on Windows
>> Operating System:
>>
>> http://www.mokisystems.com/**blog/setting-up-slony-on-**windows/<http://www.mokisystems.com/blog/setting-up-slony-on-windows/>
>>
>
> he asked, how to setup replication without slony.
>
>
>
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>