Re: [GENERAL] backup and permissions

2008-11-13 Thread Fernando Moreno
Hello Scott, thanks for your answer. I've just noticed that my first message lacked some important info. First, this is an accounting software, and there's only one database. Almost all of the options (buttons, generally ) are stored in a set of tables, beside the database privileges needed to wor

Re: [GENERAL] backup and permissions

2008-11-13 Thread Scott Marlowe
On Thu, Nov 13, 2008 at 5:30 PM, Fernando Moreno <[EMAIL PROTECTED]> wrote: > Hi, I'm working on a little backup utility for a desktop application. It's > going to execute pg_dumpall (-r) and pg_dump, but first I have to deal with > the permissions needed to do that: > > 1. Users (pgsql roles) enab

[GENERAL] backup and permissions

2008-11-13 Thread Fernando Moreno
Hi, I'm working on a little backup utility for a desktop application. It's going to execute pg_dumpall (-r) and pg_dump, but first I have to deal with the permissions needed to do that: 1. Users (pgsql roles) enabled to backup would be superusers all the time. This sounds insecure. 2. Users will