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

<div class="moz-cite-prefix">On 03/20/2013 08:21 PM, Kapil Kr. Khandelwal wrote:<br /></div><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><span
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">DearTeam</span><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">I want to a favour from your side. I want to
implementclustering in postgres on windows server.  Please provide the list of steps. I want the  answers of followings
doubts. </div><divstyle="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px"><br /></div><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">1.How to write archive command<br
/></div></div></blockquote><a
href="http://www.postgresql.org/docs/9.2/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND">http://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND</a><br
/><br/> The cmd.exe "copy" command is one option. Any  Windows command that'll do what you want and doesn't require
userinteraction can be invoked there, including custom-written scripts in vbscript, Python, Perl, etc. If in doubt, ask
Googlehow do do what you want.<br /><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">2.How to log shipping from primary to stand by
server</div></div></blockquote><a
href="http://www.postgresql.org/docs/9.2/static/warm-standby.html">http://www.postgresql.org/docs/current/static/warm-standby.html</a><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">3.how to restore database at stand by server
fromarchived files<br /></div></div></blockquote> Also in <a
href="http://www.postgresql.org/docs/9.2/static/warm-standby.html">http://www.postgresql.org/docs/current/static/warm-standby.html</a><br
/><br/> If you're having trouble understanding something in the documentation please explain what you've already tried,
whereyou're getting stuck, and the SPECIFIC problem you're having in a post to the pgsql-general mailing list.<br /><br
/><preclass="moz-signature" cols="72">-- Craig Ringer                   <a class="moz-txt-link-freetext"
href="http://www.2ndQuadrant.com/">http://www.2ndQuadrant.com/</a>PostgreSQLDevelopment, 24x7 Support, Training &
Services</pre>