Re: [ADMIN] 8.2.0 upgrade issue: loss of CONNECT rights

2007-01-20 Thread Bruce Momjian
This was fixed in 8.2.1. Thanks for the report. --- Tom Lane wrote: > L Bayuk <[EMAIL PROTECTED]> writes: > > Another thing to watch out for when upgrading to 8.2.0: > > I had some 8.1.x databases with restricted rights, li

Re: [ADMIN] 8.2.0 upgrade issue: loss of CONNECT rights

2006-12-27 Thread Tom Lane
L Bayuk <[EMAIL PROTECTED]> 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

[ADMIN] 8.2.0 upgrade issue: loss of CONNECT rights

2006-12-27 Thread L Bayuk
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 du