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 <[EMAIL PROTECTED]>:
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
