On Thu, Feb 15, 2007 at 22:39:13 -0500,
Lou Duchez [EMAIL PROTECTED] wrote:
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
Lou Duchez 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
Lou Duchez wrote:
Lou Duchez 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.
Certainly, I've
tried grant select on database mydatabase to user myuser; it doesn't
work, because select is not a database-level privilege.
Sorry, you're right on that one. I misread it. However, it shouldn't
be too hard to write a script, either in a procedural language or higher
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
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
Lou Duchez 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
Erik Jones [EMAIL PROTECTED] writes:
Lou Duchez wrote:
2) pg_dumpall -E. If I could specify a single encoding for all my
database dumps, I could use pg_dumpall.
I guess you missed this:
http://www.postgresql.org/docs/8.2/interactive/sql-grant.html
Also, on the second point, you can do