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

Dear Team

I want to a favor from your side. I want to implement clustering in
postgressql 8.x on Windows OS. I have completed till archive command. I am
getting archive files. After that, I am facing issues. Kindly explain more
steps.

Thanks in Advance. Looking forward to hearing from you.

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

On Thu, Jun 28, 2012 at 8:27 PM, Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:

>
>
> On Thu, Jun 28, 2012 at 8:56 AM, Kapil Kr. Khandelwal <kapilk(at)cscape(dot)in>wrote:
>
>> Dear Team
>>
>>
>> When I restarted the postgres9.0 service by windows then getting
>> following error message. Plz help me.
>>
>> *Error Message(Error 1053) : The service did not respond start or
>> control requested in timely fashion. *
>> *
>> *
>>
> You should have in "event viewer" -> "application" logs about your service
> error. Please post event related to you postgresql service so we can help
> you.
>
> **
>> Please suggest me. Thanks in advance.
>> Thanks & Regards
>>
>> Kapil Kr. Khandelwal
>> M: 09694179109
>> CodeScape Consultants, Jaipur
>>
>>
>>
>> On Wed, Jun 27, 2012 at 5:21 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>>
>>> On 27/06/2012 12:18, Kapil Kr. Khandelwal wrote:
>>> >
>>> >
>>> > Dear Team
>>> >
>>> > I want to a favour from your side. I want to know, how to run sql query
>>> > by command prompt in postgres sql.
>>>
>>> psql -f file-with-query.sql your-database
>>>
>>>
>>> http://www.postgresql.org/docs/9.1/static/app-psql.html
>>>
>>>
>>> Ray.
>>>
>>>
>>> --
>>> Raymond O'Donnell :: Galway :: Ireland
>>> rod(at)iol(dot)ie
>>>
>>>
>>>
>>
>