Re: 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
2. How to log shipping from primary to stand by server
3. how to restore database at stand by server from archived files

I am waiting for your positive response. Thanks in advance.


Regards
Kapil Kr. Khandelwal
CodeScape Consultant Pvt Ltd
+91 969 417 9109
+91 141 400 2993
www.codescape.in

 *Think before printing. Turn off Systems before leaving. Conserve Energy,
Save our Environment.*




On Wed, Jun 27, 2012 at 9:10 PM, Kapil Kr. Khandelwal <kapilk@cscape.in>wrote:

> Dear Sir
>
>
> Thanks for your response. My problem has solved.
>
> Thanks & Regards
>
> Kapil Kr. Khandelwal
> M: 09694179109
> CodeScape Consultants, Jaipur
>
>
>
> On Wed, Jun 27, 2012 at 8:30 PM, Christopher Browne <cbbrowne@gmail.com>wrote:
>
>> On Wed, Jun 27, 2012 at 7:15 AM, Kapil Kr. Khandelwal <kapilk@cscape.in>
>> wrote:
>> > I want to a favour from your side. I want to know, how to run sql query
>> by
>> > command prompt in postgres sql.
>>
>> This doesn't sound like a bug, and this mailing list is intended to
>> capture bugs discovered in Postgres.
>>
>> Perhaps you should avail yourself of the documentation.  The following
>> links seem as though they may be relevant:
>>
>> http://www.postgresql.org/docs/9.1/static/tutorial-accessdb.html
>> http://www.postgresql.org/docs/9.1/static/app-psql.html
>> --
>> When confronted by a difficult problem, solve it by reducing it to the
>> question, "How would the Lone Ranger handle this?"
>>
>
>