At 2003-09-12T22:36:43Z, alexander v p <[EMAIL PROTECTED]> writes:

> look in /usr/local/pgsql/data/pg_hba.conf 
> by default is:
>
> local   all         all                                             trust
> host    all         all         127.0.0.1         255.255.255.255   trust
>
> what you have to do is to change trust into password or md5
> hope that helps
> alex
> p.s. restart postgres after you change the conf file.

But when I do that, I'm prompted to enter the password for 'pgsql' whenever
I start the service.  That's pretty inconvenient when it's part of the boot
process; the system would be effectively hung until I accessed the box,
entered the password, and let the init sequence finish.

I'd read of people coming up with a mechanism to pipe a password from some
(hopefully) secure file on the system into the password prompt.  Is that
really the best way to handle this?
-- 
Kirk Strauser

Attachment: pgp00000.pgp
Description: PGP signature

Reply via email to