Re: Restart failed with 'service postgresql restart'

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.a@pnlassociates.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>