pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres error
5+ messages / 3 participants
[nested] [flat]

* Postgres error
@ 2007-05-18 05:13  Ritu Khetan <RKhetan@crisil.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Ritu Khetan @ 2007-05-18 05:13 UTC (permalink / raw)
  To: pgsql-admin





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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres error
@ 2007-05-18 05:19  Paul Lambert <paul.lambert@autoledgers.com.au>
  parent: Ritu Khetan <RKhetan@crisil.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Paul Lambert @ 2007-05-18 05:19 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres error
@ 2007-05-18 05:24  Ritu Khetan <RKhetan@crisil.com>
  parent: Paul Lambert <paul.lambert@autoledgers.com.au>
  0 siblings, 2 replies; 5+ messages in thread

From: Ritu Khetan @ 2007-05-18 05:24 UTC (permalink / raw)
  To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org






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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres error
@ 2007-05-18 05:29  Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  parent: Ritu Khetan <RKhetan@crisil.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Ashish Karalkar @ 2007-05-18 05:29 UTC (permalink / raw)
  To: Paul Lambert <paul.lambert@autoledgers.com.au>; Ritu Khetan <RKhetan@crisil.com>; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org

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 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres error
@ 2007-05-18 05:53  Paul Lambert <paul.lambert@autoledgers.com.au>
  parent: Ritu Khetan <RKhetan@crisil.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Paul Lambert @ 2007-05-18 05:53 UTC (permalink / raw)
  To: pgsql-admin

Ritu Khetan wrote:
> 
> 
> 
> 
> 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
> 
> 
> 

Are you presented with any particular error when you try starting the 
service?

Have you checked the event viewer log?

If you check in task manager and there are NO postmaster processes 
running, then check the data directory and delete the postmaster.pid 
file if it exists, then give the service a restart.

Failing that, check the logs in data/pg_log.

Check that the user the pg service is running under hasn't lost write 
permissions to the directory. (E:/crisilfe/crisil/pgsql/data)


-- 
Paul Lambert
Database Administrator
AutoLedgers




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-05-18 05:53 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-18 05:13 Postgres error Ritu Khetan <RKhetan@crisil.com>
2007-05-18 05:19 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-05-18 05:24   ` Ritu Khetan <RKhetan@crisil.com>
2007-05-18 05:29     ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-05-18 05:53     ` Paul Lambert <paul.lambert@autoledgers.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox