Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 186F7634CB0 for ; Tue, 10 Mar 2009 16:57:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 41966-08 for ; Tue, 10 Mar 2009 16:56:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.30]) by mail.postgresql.org (Postfix) with ESMTP id 505556335F6 for ; Tue, 10 Mar 2009 16:50:56 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so145755ywh.73 for ; Tue, 10 Mar 2009 12:50:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=eKNGI5W6zCCWSuPwVlinCjWSpjdcuNFXKhBYou8JuFU=; b=CubhsD8MvBIENJHjG/PE7hnpmj4cKndFXPvwoV1H+GCqFdOl8j7Ih5TrUyRX23ZAN0 /6XQncB889eXMioLF5p0sEpWIJvEE0L2LGoZUTGziV/ph3IieoaFBz+Y0s58BNQ/nlJm 8BgYiOoaDpqfE5yIrlZm1gFXkVTCGJPM5Ys9A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=QZ8V3xdrHkF+1ZD9OrS7Ixl5rn1zatCiMX2jmcgyKiUY6wLDgRapmhAOFECI95jvaZ 22bGn055mFe0RrQTd2Ke/P0lOxLUdmg1464OJXdt0hARGi7D5+4ECowH8UtZ8DGx8zkm P87sfRTgTyWWWZhlWwz5GBQOhRjZheWHuXMx8= MIME-Version: 1.0 Received: by 10.90.67.6 with SMTP id p6mr1530652aga.25.1236714655390; Tue, 10 Mar 2009 12:50:55 -0700 (PDT) Date: Tue, 10 Mar 2009 15:50:55 -0400 Message-ID: Subject: Can multiple users own and maintain a database? From: "Peter M. Van Buren" To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016361e7bdcb91b1b0464c9113e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/137 X-Sequence-Number: 31637 --0016361e7bdcb91b1b0464c9113e Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 --0016361e7bdcb91b1b0464c9113e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello,

I have a group of users who are running a maintenance-intensi= ve database.=A0 This database needs to be vacuumed and dumped as often as e= very couple of hours.=A0 The database owner has asked me to make multiple u= sers all be co-owners of the database.=A0 He wants all of these users to be= able to vacuum and dump the database when needed.=A0 The database owner do= es not want to have a db_owner account or a db_owner role - he'd like a= ll of the users to be able to sign in as themselves and perform maintenance= .=A0

I'm having a hard time figuring out if PostgreSQL can do what he wa= nts.=A0 Does anybody have experience creating a database with multiple owne= rs like this?

Thanks for your help!

~ Peter
--0016361e7bdcb91b1b0464c9113e--