Re: regular backups - super user

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.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+