Hi, There is no change in the pgstartup.log Now I hope, I can run the start command; either one of the two - by root or postgres. Right? Yes, I am new to both; as mentioned earlier also. Look forward to mastering PostgreSQL with the help of the community! Thanks a lot. On Wed, Mar 3, 2010 at 5:34 PM, Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx> wrote: > 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.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 >>> >> > > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
