[ADMIN] Restart failed with 'service postgresql restart'

[Major Services]

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

[Paul Anderson]

After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?

FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

[Newsticker]

Hi

There is a nice entry at the Postgres archive.
http://archives.postgresql.org/pgsql-general/2004-08/msg01624.php

did you remove the /tmp/.s.PGSQL.5432.lock files??
Maybee it helps

Greets
ho

-----Ursprüngliche Nachricht-----
Von: pgsql-admin-***@postgresql.org
[mailto:pgsql-admin-***@postgresql.org] Im Auftrag von Paul Anderson
Gesendet: Dienstag, 02. März 2010 17:55
An: pgsql-***@postgresql.org
Betreff: Re: [ADMIN] Restart failed with 'service postgresql restart'

After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?

FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Major Services]

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' ?

Post by Paul Anderson
After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?
FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

--
http://www.postgresql.org/mailpref/pgsql-admin

[Major Services]

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

Looking for help restart postgres.

Thanks

Post by Major Services
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' ?

Post by Paul Anderson
After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?
FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

--
http://www.postgresql.org/mailpref/pgsql-admin

[Iñigo Martinez Lasala]

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 <***@gmail.com>
To: Paul Anderson <***@pnlassociates.com>
Cc: pgsql-***@postgresql.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

Post by Major Services
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' ?

Post by Paul Anderson
After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?
FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

--
http://www.postgresql.org/mailpref/pgsql-admin

[Paul Anderson]

For me, postmaster.pid is in the same directory as postgresql.conf. Do
you still get the message about the pid file when you try to start?

Paul

Post by Major Services
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' ?

Post by Paul Anderson
After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?
FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

--
http://www.postgresql.org/mailpref/pgsql-admin

[Major Services]

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

Post by Iñigo Martinez Lasala
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-----
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

Post by Major Services
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' ?

Post by Paul Anderson
After verifying that the postmaster was not running you did remove the
postmaster.pid file, right?
FATAL: lock file "postmaster.pid"already exists

Post by Major Services
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

--
http://www.postgresql.org/mailpref/pgsql-admin