Skip site navigation (1) Skip section navigation (2)

Upgrading from < 8.1 with users and groups with same name

From: Martin Pitt <martin(at)piware(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Upgrading from < 8.1 with users and groups with same name
Date: 2005-12-29 22:00:27
Message-ID: 20051229220027.GE5114@piware.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi PostgreSQL developers!

I recently got a rather interesting Debian bug [1]: When upgrading a
pre-8.1 database to 8.1, the upgrade messes up permissions if the old
database had users and groups with the same name. Since in 8.1 they
get collapsed to a 'role' there will be a name clash.

My current solution checks for this situation and aborts the upgrade
if there is at least one name which is both an user and a group (and
asks for renaming either before attempting the upgrade again).

For an upstream solution, maybe pg_dumpall should detect this
situation and abort with an error?

Thank you in advance for any idea,

Martin

[1] http://bugs.debian.org/343622

-- 
Martin Pitt        http://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-12-30 01:06:04
Subject: Re: Upgrading from < 8.1 with users and groups with same name
Previous:From: Carlos del CachoDate: 2005-12-29 14:26:51
Subject: BUG #2135: system error 182 while loading ODBC driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group