Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D5D079FB5A7; Fri, 18 May 2007 02:35:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 67587-04; Fri, 18 May 2007 02:34:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 44C619FB32D; Fri, 18 May 2007 02:34:56 -0300 (ADT) Received: from ashishk (ppp92-7.vsnl.eth.net [61.17.93.7] (may be forged)) (authenticated bits=0) by pro33.abac.com (8.13.8/8.13.8) with ESMTP id l4I5YHQC017478 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 17 May 2007 22:34:25 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <006e01c7990d$95ace8b0$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "Paul Lambert" , "Ritu Khetan" Cc: , References: Subject: Re: Postgres error Date: Fri, 18 May 2007 10:59:51 +0530 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/177 X-Sequence-Number: 25497 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" To: "Paul Lambert" Cc: ; 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 > 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