|
|
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 www.ubuntu.com">http://www.ubuntu.com
Debian Developer www.debian.org">http://www.debian.org
In a world without walls and fences, who needs Windows and Gates?
|
|