On 03/20/2013 08:21 PM, Kapil Kr. Khandelwal wrote: > Dear Team > > I want to a favour from your side. I want to implement clustering in > postgres on windows server. Please provide the list of steps. I want > the answers of followings doubts. > > 1. How to write archive command http://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND <http://www.postgresql.org/docs/9.2/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND>
The cmd.exe "copy" command is one option. Any Windows command that'll do what you want and doesn't require user interaction can be invoked there, including custom-written scripts in vbscript, Python, Perl, etc. If in doubt, ask Google how do do what you want. > 2. How to log shipping from primary to stand by server http://www.postgresql.org/docs/current/static/warm-standby.html <http://www.postgresql.org/docs/9.2/static/warm-standby.html> > 3. how to restore database at stand by server from archived files Also in http://www.postgresql.org/docs/current/static/warm-standby.html <http://www.postgresql.org/docs/9.2/static/warm-standby.html> If you're having trouble understanding something in the documentation please explain what you've already tried, where you're getting stuck, and the SPECIFIC problem you're having in a post to the pgsql-general mailing list. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
