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.major@xxxxxxxxx>
To: Paul Anderson <paul.a@xxxxxxxxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: 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.major@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> >
