Skip site navigation (1) Skip section navigation (2)

Re: Postgres error

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: "Paul Lambert" <paul(dot)lambert(at)autoledgers(dot)com(dot)au>, "Ritu Khetan" <RKhetan(at)crisil(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-admin-owner(at)postgresql(dot)org>
Subject: Re: Postgres error
Date: 2007-05-18 05:29:51
Message-ID: 006e01c7990d$95ace8b0$170211ac@LIONKING.COM (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)crisil(dot)com>
To: "Paul Lambert" <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: <pgsql-admin(at)postgresql(dot)org>; <pgsql-admin-owner(at)postgresql(dot)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(dot)lambert(at)autoledge
>                          rs.com.au>                                    To
>                            Sent by:         pgsql-admin(at)postgresql(dot)org
>             pgsql-admin-owner(at)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 


In response to

pgsql-admin by date

Next:From: Paul LambertDate: 2007-05-18 05:53:58
Subject: Re: Postgres error
Previous:From: Ashish KaralkarDate: 2007-05-18 05:26:27
Subject: Re: WAL FILES

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group