Date: Wed, 24 May 2006 09:39:41 +0200 From: User Gandalf <gandalf@messias.qhigh.com> To: freebsd-questions@freebsd.org Subject: Postgresql Autovacuum how? Message-ID: <44740DBD.1090303@messias.qhigh.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44740DBD.1090303>