> > During the bootup monologue, in the middle of init-ing the usual daemon
> > processes, I suddenly get a Password: prompt. I enter the postgres
> > user's password for the one database I'm running, and pgsql prints its
> > name out and boot proceeds otherwise normally.
>
> Is your boot script launching the postmaster via "pg_ctl"? If so, try
> telling pg_ctl not to wait for the postmaster to start (-W option I
> think)
Okay, here's the line from /usr/local/etc/rc.d/022.pgsql.sh:
su -l postgres -c \
'[ -d ${PGDATA} ] && exec /usr/local/bin/pg_ctl start -s -w -o "-i" -l /var/log/pgsql'
Checked the man page, then just removed the -w, and it seems to be
running fine without asking for postgres's database password during boot.
Thanks.
(So now I'm wondering if the -i option for postmaster could be specified
in the postmaster.opts.default file mentioned in the man page for pg_ctl.
More things to play with later, I guess.)
> > I should note that after logging in, I usually sudo -u postgres tcsh,
> > and use pg_ctl from there, and I never get prompted for the password.
>
> That seems odd if you do get prompted during boot. Mind telling us
> exactly what you've got in pg_hba.conf?
local webbedfriend password
local all password
host webbedfriend 127.0.0.1 255.255.255.255 password
host all 127.0.0.1 0.0.0.0 reject
That's going to change as soon as I get time to play around with
privileges some more, but that's how it is now.
Of course, thinking about what Sean posted, and considering that I use
pg_ctl from the command line, rather than calling it through pgsql.sh,
I'm no longer puzzled.
Thanks again. And thanks to Sean, too.
--
Joel Rees <joel@alpsgiken.gr.jp>
(I hate it when I forget to address the list.)