Re: Restart failed with 'service postgresql restart'

From: Paul Anderson <paul(dot)a(at)pnlassociates(dot)com>
To: Major Services <services(dot)major(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restart failed with 'service postgresql restart'
Date: 2010-03-03 12:12:46
Message-ID: 4B8E523E.3080005@pnlassociates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

For me, postmaster.pid is in the same directory as postgresql.conf. Do
you still get the message about the pid file when you try to start?

Paul

On 3/2/10 11:28 PM, Major Services wrote:
> Where to look for postmaster.pid?
> It is not in the data directory. There is one file postmaster.opts there.
>
> Should I try running 'pg_ctl start -l logfile' ?
>
> On Tue, Mar 2, 2010 at 10:24 PM, Paul Anderson<paul(dot)a(at)pnlassociates(dot)com> wrote:
>
>> After verifying that the postmaster was not running you did remove the
>> postmaster.pid file, right?
>>
>> FATAL: lock file "postmaster.pid"already exists
>>
>>
>> On 3/2/10 11:43 AM, Major Services wrote:
>>
>>> Help me start the server.
>>> As I mentioned in an earlier post today (subject: password
>>> authentication failed for user postgres), 'service postgresql restart'
>>> had stopped the server but *server
>>> start failed*.
>>>
>>> Step wise list of commands to be given would be great!
>>> Do I need to login as postgres?
>>>
>>> Being new to PostgreSQL, am looking for some hand-holding.
>>>
>>> Thanks
>>> Viv
>>>
>>>
>>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Heikki Linnakangas 2010-03-03 12:25:20 Re: Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar
Previous Message Iñigo Martinez Lasala 2010-03-03 12:04:33 Re: Restart failed with 'service postgresql restart'