Re: Postgres error

Hello Ritu,

Check that postmaster.pid file is there in e:/crisilfe/crisil/pgsql/data.
If its there then delete it and try to start the server once again

hope this should  help :)

With Regards
Ashish...








----- Original Message -----
From: "Ritu Khetan" <RKhetan@crisil.com>
To: "Paul Lambert" <paul.lambert@autoledgers.com.au>
Cc: <pgsql-admin@postgresql.org>; <pgsql-admin-owner@postgresql.org>
Sent: Friday, May 18, 2007 10:54 AM
Subject: Re: [ADMIN] Postgres error


>
>
>
>
>
> Hi Paul,
>
> The service does not start , hence we tried it through the command prompt
> to check what is the error.
>
> Any thoughts?
>
> Regards,
> Ritu
>
>
>
>
>                        Paul Lambert
>             <paul.lambert@autoledge
>                          rs.com.au>                                    To
>                            Sent by:         pgsql-admin@postgresql.org
>             pgsql-admin-owner@postg                                    cc
>                           resql.org
>                                                                   Subject
>                                             Re: [ADMIN] Postgres error
>                 18/05/2007 10:49 AM
>
>
>
>
>
>
>
>
>
> Ritu Khetan wrote:
>>
>>
>>
>> Dear friends,
>>
>> I am getting the following error when I start Postgres 8.1 from the
> command
>> prompt on windows:
>>
>> pg_ctl start -D e:/crisilfe/crisil/pgsql/data
>> postmaster starting
>>
>> E:\Crisilfe\Crisil\pgsql\bin>LOG:  could not rename file
>> "global/config_exec_par
>> ams.new" to "global/config_exec_params", continuing to try
>> pg_ctl start -D e:/crisilfe/crisil/pgsql/data
>> pg_ctl: another postmaster may be running; trying to start postmaster
>> anyway
>> FATAL:  lock file "postmaster.pid" already exists
>> HINT:  Is another postmaster (PID 2672) running in data directory
>> "e:/crisilfe/c
>> risil/pgsql/data"?
>> pg_ctl: could not start postmaster
>> Examine the log output.
>>
>> Can someone thro some light on what causing this. Need urgent help...
>>
>> Regards,
>> Ritu
>> Disclaimer :
>> This message (including any attachments) contains confidential
> information. If you are not the intended recipient, please delete the
> message (including any attachments) from your system without using,
> transmitting or storing it. Please also immediately inform the sender.
> E-mails are not secure and may suffer from errors, viruses, unauthorized
> interceptions / amendments. CRISIL and its subsidiaries do not accept any
> liability for loss or damage caused by this e-mail and may monitor e-mail
> traffic.
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>>
>
> PG runs as a service on windows - if you look in service control manager
> is it started?
>
> If you look in task manager are there any postmaster.exe's running?
>
> --
> Paul Lambert
> Database Administrator
> AutoLedgers
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> Disclaimer :
> This message (including any attachments) contains confidential
> information. If you are not the intended recipient, please delete the
> message (including any attachments) from your system without using,
> transmitting or storing it. Please also immediately inform the sender.
> E-mails are not secure and may suffer from errors, viruses, unauthorized
> interceptions / amendments. CRISIL and its subsidiaries do not accept any
> liability for loss or damage caused by this e-mail and may monitor e-mail
> traffic.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend