Thread: Restart failed with 'service postgresql restart'

Restart failed with 'service postgresql restart'

From
Major Services
Date:
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

Re: Restart failed with 'service postgresql restart'

From
Paul Anderson
Date:
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
>
>

Re: Restart failed with 'service postgresql restart'

From
"Newsticker"
Date:
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-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von Paul Anderson
Gesendet: Dienstag, 02. März 2010 17:55
An: pgsql-admin@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


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


Re: Restart failed with 'service postgresql restart'

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

Re: Restart failed with 'service postgresql restart'

From
Major Services
Date:
'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@gmail.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.a@pnlassociates.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>

Re: Restart failed with 'service postgresql restart'

From
Iñigo Martinez Lasala
Date:
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@gmail.com>
To: Paul Anderson <paul.a@pnlassociates.com>
Cc: pgsql-admin@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

On Wed, Mar 3, 2010 at 9:58 AM, Major Services <services.major@gmail.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.a@pnlassociates.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>


Re: Restart failed with 'service postgresql restart'

From
Paul Anderson
Date:
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

On 3/2/10 11:28 PM, Major Services 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@pnlassociates.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>

Re: Restart failed with 'service postgresql restart'

From
Major Services
Date:
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@vectorsf.com> 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@gmail.com>
> To: Paul Anderson <paul.a@pnlassociates.com>
> Cc: pgsql-admin@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
>
> On Wed, Mar 3, 2010 at 9:58 AM, Major Services <services.major@gmail.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.a@pnlassociates.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@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>
>>
>
>
>