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
>