Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5B1379FBDEF for ; Fri, 18 May 2007 02:19:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80363-01 for ; Fri, 18 May 2007 02:19:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id 147439FC01A for ; Fri, 18 May 2007 02:19:16 -0300 (ADT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 960A21D48499 for ; Fri, 18 May 2007 15:19:14 +1000 (EST) Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id A6D101D48494 for ; Fri, 18 May 2007 15:19:13 +1000 (EST) Message-ID: <464D3745.3000304@autoledgers.com.au> Date: Fri, 18 May 2007 13:19:01 +0800 From: Paul Lambert User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Postgres error References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/174 X-Sequence-Number: 25494 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