On 2/16/07, Lou Duchez <[EMAIL PROTECTED]> wrote:
Like everyone else, I use pg_dump for backup purposes; I have a cron job
that runs a pg_dump whose output is then FTP'd elsewhere. Two things
that would make my life easier:
1) "grant select on database ..." or, hypothetically, "grant select on
cluster". The goal would be to create a read-only PostgreSQL user, one
who can read the contents of an entire database (or even the entire
cluster) but make no changes. Currently, to do my cron job, I have to
specify a "trusted" user, otherwise PostgreSQL will ask for a password;
A .pgpass file can fix this... I don't know if that gets you any
closer to your objective.
- Ian
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
