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 <[email protected]> To: Paul Anderson <[email protected]> Cc: [email protected] 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 <[email protected]> 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 <[email protected]> > 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 ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> >
