Postgres + MD5 Auth

Wayne Pascoe freebsd at penguinpowered.org.uk
Mon Apr 7 02:29:09 PDT 2003


Hi all,

Sorry to bug twice on one day, but does anyone know what I have to
change in the startup scripts for PostgreSQL (010.pgsql.sh) to make it
work with password authentication?

I've setup pg_hba.conf to use encrypted passwords (md5), but then
starting Postgres prompts for a password. This is not great for when the
machine reboots and no-one is around to enter this.

Is there any way of passing pgsql's password to the script ? 

Thanks,

-- 
Wayne Pascoe


More information about the freebsd-questions mailing list