Hello,
I have FreeBSD 6.1 and PostgreSQL 8.1.3 installed. I had to change the
pg_hba.conf settings, because I need to open the 5432 port for everyone
(SSL enabled). For this reason, I also gave strong passwords for all
postgresql users. Now this is what I see in the daily run output
(/usr/local/etc/periodic/daily/502.pgsql):
vacuuming...
Password:
vacuumdb: could not connect to database postgres: fe_sendauth: no password supplied
Errors were reported during vacuum.
This is my pg_hba.conf file:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
host all all 127.0.0.1/32 md5
hostssl all all 0.0.0.0 0.0.0.0 md5
The autovacuum script was packaged for FreeBSD, so I assume this is a
FreeBSD specific thing. My question is: why ident/sameuser not working
here? How can I enable auto vacuums without storing the password in the
periodic/daily/502.pgsql script?
Thanks,
Laszlo
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
