Re: Fwd: How to run query by command prompt in Postgres

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

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

3. how to restore database at stand by server from archived files

Also in http://www.postgresql.org/docs/current/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