This is not a PostgreSQL problem, it's the script you are using for startup that has some problem. The pg_hba method is for connection stablishment. PostgreSQL will start no matter what you put there.
Startup scripts are usually run as root, and postgresql script should
su to the postgresql user to start the database. I don't know what your script is doing, but root should be able to su to any user without password.
Check your script, post it if you want. It would be usefull to know what system you are using also (linux/bsd/solaris/etc).
2005/5/20, Duane Winner <duanewinner@att.net>: hello,
I've been using postgresql for about a year now, and am pretty
comfortable with the basics, bu there has been something bugging me for
a while now:
I set the METHOD in pg_hba.conf to md5 so that a password is required
from all users, from all hosts.
The only problem is that if the server restarts, postgresql will not
start until somebody goes to the console and enters the password for the
pgsql account.
Is there a solution for this solution?
Thanks,
DW
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org