Hi Zygo!

Thank you for spotting this.

Zygo Blaxell [2005-12-16 11:49 -0500]:
> If a group and user have the same name in 8.0, and the user is a member
> of the group, then nothing needs to be done since in 8.1 these are now the
> same object in the same namespace.  If a user and group have the same name
> in 8.0, and the user is *not* a member of the group, then there is no 
> equivalent in 8.1 and pg_upgradecluster should stop and ask the user to
> rename either the user or the group.

I added a test to pg_upgradecluster that aborts early with a
meaningful error message if this happens. I also forwarded this
problem to upstream, maybe they have a better solution for this in the
long term.

> I haven't checked thoroughly, but I suspect that pg_upgradecluster is not
> executing the operations on the new database within a single transaction.

The upgrade of a database is done with a pg_dump/pg_restore pipeline;
there aren't any options to influence the speed or transactional
behavior, do you know how it can be improved? 

Thanks,

Martin
-- 
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?

Attachment: signature.asc
Description: Digital signature

Reply via email to