Re: Restart failed with 'service postgresql restart'

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

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Major Services 2010-03-03 07:21:09 Re: Restart failed with 'service postgresql restart'
Previous Message Scott Marlowe 2010-03-02 19:54:29 Re: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf