Re: regular backups - super user

Hello,

Your pg_hba.conf controls the authentication model for your machine.
One way to handle this is to have
the database on a local machine and allow anything local (not
localhost/127.0.0.1) to be of type trust.
You should only do this if you trust the people that have access to
shell accounts on that machine.

Then set your network connections to be of type md5 (better yet use
hostssl as well).

Sincerely,

Joshua D. Drake

Paul Thomas wrote:

>
> On 30/10/2003 15:29 Jeff MacDonald wrote:
>
>> Hi,
>>
>> WHen i run pg_dumpall as the super user [postgres in my case] it asks
>> for a password for every database. I don't know my users passwords. Is
>> there a way to make the super user able to backup without passwords ?
>
>
> What version of PG are you using? I've just tried this on my 7.3.4 box
> and I don't get asked for user passwords.
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org