From: Peter M. Van Buren <petervanburen@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Can multiple users own and maintain a database?
Date: Tue, 10 Mar 2009 15:50:55 -0400
Message-ID: <e20d28e20903101250r5fe7d99emf26ec20622b1546b@mail.gmail.com> (raw)
Hello,
I have a group of users who are running a maintenance-intensive database.
This database needs to be vacuumed and dumped as often as every couple of
hours. The database owner has asked me to make multiple users all be
co-owners of the database. He wants all of these users to be able to vacuum
and dump the database when needed. The database owner does not want to have
a db_owner account or a db_owner role - he'd like all of the users to be
able to sign in as themselves and perform maintenance.
I'm having a hard time figuring out if PostgreSQL can do what he wants.
Does anybody have experience creating a database with multiple owners like
this?
Thanks for your help!
~ Peter
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: petervanburen@gmail.com
Subject: Re: Can multiple users own and maintain a database?
In-Reply-To: <e20d28e20903101250r5fe7d99emf26ec20622b1546b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox