pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2008-09-26 14:42 Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Lennin Caro @ 2008-09-26 14:42 UTC (permalink / raw)
To: pgsql-admin; +Cc: chom@gallo.ucsf.edu
--Original------------------------------------------------------
Hi Everybody,
About 1.5 month ago, my machine (which runs redhat linux
2.6.9-78.0.1.ELsmp on Dell hardware with postgres 8.3.3)
had a terrible crash. I am mostly recovered, but there
is at least one more thing that's not right.
Namely, when the machine gets rebooted, postgres doesn't
start automatically. Before the crash, there was no such
problem.
I see a file /etc/rc.d/init.d/postgresql. Is this the
start-up script? If not, please tell me what would be the
correct one (and where would I find one). If it is, can you
please tell me where I would find the latest one anyway?
(Maybe the latest one got lost and I am looking at an old
copy???)
The detail of how it happens escapes me, but as near as I
can reconstruct in my head, after the reboot I discover that
postgres is not running and I issue:
pg_ctl start
and it complains something to the effect that it is already
started (which seems to be not true) and maybe it gives me
a pid for the postmaster. I think I tried:
pg_ctl stop
and it told me something a bit disageeable. But I found a
file with that pid in /tmp directory and when I remove that
file, then "pg_ctl start" succeeds.
If this sounds familiar to you (or you have some clue as to
what is going on), I would appreciate a tip.
----------------------------------------------
Hi..
the command pg_ctl need a directory where the data is, the pid is created in the same directory of the data. You can use "/etc/rc.d/init.d/postgresql start" but firts loggin whit user postgres or the user owner of the data directory
regards......
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re:
@ 2008-09-26 15:12 Paul B. Anderson <paul.a@pnlassociates.com>
parent: Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Paul B. Anderson @ 2008-09-26 15:12 UTC (permalink / raw)
To: lennin.caro@yahoo.com; +Cc: pgsql-admin; chom@gallo.ucsf.edu
If you are sure postgresql is not running based on the pid value, it
could be refusing to start because the pid file is still there. Remove
the pid file (in the data directory I think) and it should then start in
the usual way.
Lennin Caro wrote:
> --Original------------------------------------------------------
> Hi Everybody,
>
>
>
> About 1.5 month ago, my machine (which runs redhat linux
>
> 2.6.9-78.0.1.ELsmp on Dell hardware with postgres 8.3.3)
>
> had a terrible crash. I am mostly recovered, but there
>
> is at least one more thing that's not right.
>
>
>
> Namely, when the machine gets rebooted, postgres doesn't
>
> start automatically. Before the crash, there was no such
>
> problem.
>
>
>
> I see a file /etc/rc.d/init.d/postgresql. Is this the
>
> start-up script? If not, please tell me what would be the
>
> correct one (and where would I find one). If it is, can you
>
> please tell me where I would find the latest one anyway?
>
> (Maybe the latest one got lost and I am looking at an old
>
> copy???)
>
>
>
> The detail of how it happens escapes me, but as near as I
>
> can reconstruct in my head, after the reboot I discover that
>
> postgres is not running and I issue:
>
> pg_ctl start
>
> and it complains something to the effect that it is already
>
> started (which seems to be not true) and maybe it gives me
>
> a pid for the postmaster. I think I tried:
>
> pg_ctl stop
>
> and it told me something a bit disageeable. But I found a
>
> file with that pid in /tmp directory and when I remove that
>
> file, then "pg_ctl start" succeeds.
>
>
>
> If this sounds familiar to you (or you have some clue as to
>
> what is going on), I would appreciate a tip.
>
>
> ----------------------------------------------
> Hi..
>
>
> the command pg_ctl need a directory where the data is, the pid is created in the same directory of the data. You can use "/etc/rc.d/init.d/postgresql start" but firts loggin whit user postgres or the user owner of the data directory
>
> regards......
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-09-26 15:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-26 14:42 Lennin Caro <lennin.caro@yahoo.com>
2008-09-26 15:12 ` Re: Paul B. 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