Обсуждение: Postmaster hangs until Ctrl-C

Do you run postmaster in background ?
i.e. postmaster &

Cyril

> -----Message d'origine-----
> De:    Tom Brown [SMTP:tbrown@hwwe.com]
> Date:    jeudi 5 avril 2001 18:04
> À:    pgsql-novice list
> Objet:    [NOVICE] Postmaster hangs until Ctrl-C
>
> When I run postmaster, the system hangs until I Ctrl-C.
>
> Postgresql 6.4 was installed at the factory by the manufacturer (VA Linux)
> with root ownership and permissions. I read the FAQ and Admin manual re
> installation. There was no postgres user although VA did create a postgres
> group. I created a postgres user, changed ownership on as many directories
> as I can find with postgresql files, and I edited the pg_hba.conf file to
> reflect the instructions in the Admin install manual. It doesn't matter
> whether I su - postgres to start postmaster or not -- it still hangs.
> Apparently I've missed something.
>
> Tom

"Tom Brown" <tbrown@hwwe.com> writes:
> When I run postmaster, the system hangs until I Ctrl-C.

Sounds like you're just saying
    postmaster
and not doing anything to put the process into the background.  See
http://www.postgresql.org/devel-corner/docs/postgres/postmaster-start.html

            regards, tom lane

> When I run postmaster, the system hangs until I Ctrl-C.

> Postgresql 6.4 was installed at the factory by the manufacturer (VA Linux)
with root ownership and permissions. I read the FAQ and Admin manual re
installation. There was no postgres user although VA did create a postgres
group. I created a postgres user, changed ownership on as many directories
as I can find with postgresql files, and I edited the pg_hba.conf file to
reflect the instructions in the Admin install manual. It doesn't matter
whether I su - postgres to start postmaster or not -- it still hangs.
Apparently I've missed something.

Yikes, 6.4 is ancient.  I strongly suggest upgrading.

Anyway the postmaster runs until it stops.  If you run it in the foreground
then it will stay connected to the tty and you will most likely see log file
output on that tty.  It should normally be run in the background with its
output redirected somewhere useful.  You normally want to do this in a
system boot up script somewhere.  There are example scripts in the source
distribution.

I was certain that I had already taken care of the proper environmental
variables (PGLIB, PGDATA) and that I should be able to start postmaster in
the foreground or background. But I tried your suggestion anyway. By
starting postmaster in the background it revealed an error I hadn't
considered -- postmaster couldn't find PGDATA in spite of the correct
.bash_profile.

I checked the current $PATH variable and found that it didn't include
/home/postgres/bin. I had logged in as tbrown and su'd to postgres which
kept /home/tbrown/bin in the path as $HOME. I exited and logged in again as
postgres. Then postmaster worked. The $HOME and $PATH environmental
variables were /home/postgres/bin and /usr/loca/pgsql/data as expected.

Thanks for the reply. It helped.

Tom


----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom Brown <tbrown@hwwe.com>
Cc: pgsql-novice list <pgsql-novice@postgresql.org>
Sent: Thursday, April 05, 2001 11:09 AM
Subject: Re: [NOVICE] Postmaster hangs until Ctrl-C


> "Tom Brown" <tbrown@hwwe.com> writes:
> > When I run postmaster, the system hangs until I Ctrl-C.
>
> Sounds like you're just saying
> postmaster
> and not doing anything to put the process into the background.  See
> http://www.postgresql.org/devel-corner/docs/postgres/postmaster-start.html
>
> regards, tom lane
>