Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 68A359FB596 for ; Sat, 20 Jan 2007 19:13:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 81596-07 for ; Sat, 20 Jan 2007 19:13:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id A51479FB59B for ; Sat, 20 Jan 2007 19:13:21 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l0KNDJs28061; Sat, 20 Jan 2007 18:13:19 -0500 (EST) From: Bruce Momjian Message-Id: <200701202313.l0KNDJs28061@momjian.us> Subject: Re: 8.2.0 upgrade issue: loss of CONNECT rights In-Reply-To: <28233.1167269202@sss.pgh.pa.us> To: Tom Lane Date: Sat, 20 Jan 2007 18:13:19 -0500 (EST) CC: L Bayuk , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/178 X-Sequence-Number: 24334 This was fixed in 8.2.1. Thanks for the report. --------------------------------------------------------------------------- Tom Lane wrote: > L Bayuk writes: > > Another thing to watch out for when upgrading to 8.2.0: > > I had some 8.1.x databases with restricted rights, like REVOKE CREATE ON > > DATABASE. After pg_dumpall and reload into 8.2.0, I lost CONNECT rights on > > those databases. So only the superuser account can connect. The reason > > seems to be that my dump file had REVOKE ALL ON DATABASE, then added the > > specific GRANT rights. At 8.2.0, REVOKE ALL includes revoking CONNECT > > rights even though they were always granted at 8.1.5. > > Hmmm ... I think we could hack 8.2's pg_dumpall to compensate for that, > ie throw in a GRANT CONNECT ... TO PUBLIC when dumping from a pre-8.2 > server. But of course this wouldn't do anything for databases dumped > with older versions of pg_dumpall. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +