Authenticating user `postgres'
Arcady Genkin <a.genkin@utoronto.ca>
From: Arcady Genkin <a.genkin@utoronto.ca>
To: pgsql-general@postgresql.org
Date: 2001-09-26T17:35:48Z
Lists: pgsql-general
Hello: I have a pg_hba.conf question. Currently the authentication is setup as thus: local db1 password passwd.db1 local db2 password passwd.db2 local all password passwd.su So, I store passwords for users in separate files for each database. The third line is for the internal postgres templates. The problem I'm having is that I want local UNIX user `postgres', who is the database superuser, to be able to connect to any database without a password. I want, for example, to be able to run a cronjob like "pg_dumpall >backup", but I can't do that with my current setup. Any ideas? Many thanks, -- Arcady Genkin i=1; while 1, hilb(i); i=i+1; end