Jeff MacDonald writes:
> i think the postgres user should have acess to all databases no matter
> what.
I disagree. Firstly, for the backend to actually know that you're the
postgres (Unix) user it would have to authenticate you, using ident or
kerberos perhaps. But in the case in question the p
that's true but that still assumes you know the pasword.
also someone mentioned that you can just su to any account,
well that's true but it still doesn't negate teh fact that the
user has a passwd on thier database. as i said, i think
the postgres user should have acess to all databases no matte
>> 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.
hi folks,
I'm writing out a nightly backup script for a machine.
This machine has many databases, running on different ports.
ie: 5432,5433 etc..
These servers are ""owned"" (use term loosly) by users on the
system, and some users have choses to set passwds. which is
100% within their right.
H
