Re: doing backups

>> Now if you make pgsql user and postgresql analgous to
>> root and unix, the postgres user shouldn't need a passwd.

>My root users always have passwords. *shrug* But you're right, automated
>backup on password protected databases is next to impossible right now,
>especially when using pg_dump. If those users want to enable you to do
>backups for them perhaps they should give you (and only you) some sort of
>ident controlled access.

I missed the first half of this, but, if I have understood correctly, I
don't think this is the case: you can do automated backups by doing

echo -e 'username\npassword\n' | pg_dump -u databasename



Yours,
Moray