pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestart failed with 'service postgresql restart'
8+ messages / 4 participants
[nested] [flat]
* Restart failed with 'service postgresql restart'
@ 2010-03-02 16:43 Major Services <services.major@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Major Services @ 2010-03-02 16:43 UTC (permalink / raw)
To: pgsql-admin; +Cc: ktm@rice.edu; imartinez@vectorsf.com
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-02 16:54 Paul Anderson <paul.a@pnlassociates.com>
parent: Major Services <services.major@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Paul Anderson @ 2010-03-02 16:54 UTC (permalink / raw)
To: pgsql-admin
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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-02 18:02 Newsticker <newstickerho@gmail.com>
parent: Paul Anderson <paul.a@pnlassociates.com>
1 sibling, 0 replies; 8+ messages in thread
From: Newsticker @ 2010-03-02 18:02 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-03 04:28 Major Services <services.major@gmail.com>
parent: Paul Anderson <paul.a@pnlassociates.com>
1 sibling, 2 replies; 8+ messages in thread
From: Major Services @ 2010-03-03 04:28 UTC (permalink / raw)
To: Paul Anderson <paul.a@pnlassociates.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-03 07:21 Major Services <services.major@gmail.com>
parent: Major Services <services.major@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Major Services @ 2010-03-03 07:21 UTC (permalink / raw)
To: Paul Anderson <paul.a@pnlassociates.com>; +Cc: pgsql-admin
'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
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-03 12:04 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: Major Services <services.major@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Iñigo Martinez Lasala @ 2010-03-03 12:04 UTC (permalink / raw)
To: Major Services <services.major@gmail.com>; +Cc: pgsql-admin
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
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-03 12:12 Paul Anderson <paul.a@pnlassociates.com>
parent: Major Services <services.major@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Paul Anderson @ 2010-03-03 12:12 UTC (permalink / raw)
To: Major Services <services.major@gmail.com>; +Cc: pgsql-admin
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
>>
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restart failed with 'service postgresql restart'
@ 2010-03-03 12:32 Major Services <services.major@gmail.com>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 0 replies; 8+ messages in thread
From: Major Services @ 2010-03-03 12:32 UTC (permalink / raw)
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>; +Cc: pgsql-admin
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
>>>
>>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-03-03 12:32 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-02 16:43 Restart failed with 'service postgresql restart' Major Services <services.major@gmail.com>
2010-03-02 16:54 ` Paul Anderson <paul.a@pnlassociates.com>
2010-03-02 18:02 ` Newsticker <newstickerho@gmail.com>
2010-03-03 04:28 ` Major Services <services.major@gmail.com>
2010-03-03 07:21 ` Major Services <services.major@gmail.com>
2010-03-03 12:04 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-03-03 12:32 ` Major Services <services.major@gmail.com>
2010-03-03 12:12 ` Paul Anderson <paul.a@pnlassociates.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox