Re: Restart failed with 'service postgresql restart'

Let's see.
Could you provide us again pgstartup.log?

First problem was you had a problem with postgresql.conf syntax.
Then, you had a problem with lock files, probably because a bad shutdown
(perhaps a kill?)

Anyway, how long have you worked with Unix environments? I think you are
new to this world, don't you? ;-)

In order to start postgres you have several ways to do it.

- as root user: "service postgresql start" or "/etc/init.d/postgresql
start"
- as postgres user "su - postgres", run "pg_ctl start -D /var/lib/pgsql"

-----Original Message-----
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: [ADMIN] Restart failed with 'service postgresql restart'
Date: Wed, 3 Mar 2010 12:51:09 +0530

'pg_ctl status' returns 'neither postmaster nor postgres running'.

Looking for help restart postgres.

Thanks

On Wed, Mar 3, 2010 at 9:58 AM, Major Services <services(dot)major(at)gmail(dot)com> 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
>>
>