Re: [GENERAL] Postgresql - 8.3 Replication in windows

2012-11-21 Thread Jasen Betts
On 2012-11-02, dinesh kumar dineshkuma...@gmail.com wrote: --20cf3071cc56678d5104cd82409f Content-Type: text/plain; charset=ISO-8859-1 Hi , In windows we do not have SCP/RSYNC utility commands, which helps us to send the archives to remote/slave server. pscp (putty.org) deltacopy -- ⚂⚃

[GENERAL] Postgresql - 8.3 Replication in windows

2012-11-02 Thread Vishalakshi Navaneethakrishnan
Hi all, Can you please tell me , how to set up replication in win7, without slony tool.. -- Best Regards, Vishalakshi.N

Re: [GENERAL] Postgresql - 8.3 Replication in windows

2012-11-02 Thread raghu ram
On Fri, Nov 2, 2012 at 1:03 PM, Vishalakshi Navaneethakrishnan nvishalak...@sirahu.com wrote: Hi all, 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:

Re: [GENERAL] Postgresql - 8.3 Replication in windows

2012-11-02 Thread John R Pierce
On 11/02/12 12:33 AM, Vishalakshi Navaneethakrishnan wrote: Can you please tell me , how to set up replication in win7, without slony tool.. step 1) upgrade to postgresql 9.x ppreferably 9.1 or 9.2 step 2) implement streaming replication per the postgres documentation windows will be a

Re: [GENERAL] Postgresql - 8.3 Replication in windows

2012-11-02 Thread John R Pierce
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/ he

Re: [GENERAL] Postgresql - 8.3 Replication in windows

2012-11-02 Thread dinesh kumar
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