Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5AF7E632B30 for ; Sun, 12 Sep 2010 23:11:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 55791-05 for ; Mon, 13 Sep 2010 02:10:47 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta02.westchester.pa.mail.comcast.net (qmta02.westchester.pa.mail.comcast.net [76.96.62.24]) by mail.postgresql.org (Postfix) with ESMTP id 1CC7B632C99 for ; Sun, 12 Sep 2010 23:10:48 -0300 (ADT) Received: from omta23.westchester.pa.mail.comcast.net ([76.96.62.74]) by qmta02.westchester.pa.mail.comcast.net with comcast id 61cs1f0041c6gX8522AoMJ; Mon, 13 Sep 2010 02:10:48 +0000 Received: from imac.42.168.192.in-addr.arpa ([76.117.184.231]) by omta23.westchester.pa.mail.comcast.net with comcast id 62An1f0094zyFz83j2AnZn; Mon, 13 Sep 2010 02:10:48 +0000 From: Lou Picciano X-Apple-Mail-Stationery: 45655888-E52F-42B7-A29F-41D13C34A678 Content-Type: multipart/alternative; boundary=Apple-Mail-1--1053515105 Subject: pg_upgrade 9b4 -> 9rc1 odd behavior with -u (non-)postgres Date: Sun, 12 Sep 2010 22:10:46 -0400 Message-Id: To: pgsql-testers@postgresql.org Mime-Version: 1.0 (Apple Message framework v1081) X-Mailer: Apple Mail (2.1081) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/16 X-Sequence-Number: 192 --Apple-Mail-1--1053515105 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii [TEST REPORT]=20 [Release]: 9.0 RC1 [Test Type]: pg_upgrade: 9.0-beta4 (Cluster 'A') -> 9.0-RC1 (Cluster = 'B') user 'non'-postgres. =20 [Test]: pg_upgrade (...options...) -u master=20 [Platform]: Solaris 10 - Sun E450 Quad [Parameters]: Our administrator role is 'master' in both clusters. User = 'master' has been created in Cluster B, SUPERUSER LOGIN CREATEROLE = CREATEDB, and has been given 'trust' access. Logging turned on in = config. Otherwise, cluster has been left in 'initdb' condition. [Failure]: YES.=20 [Results]: Script connect to Database 'A' and dumps catalog, apparently = without error. Connects to Database 'B', crashes on attempt to create user 'postgres' - = which, of course, already exists. Any subsequent run crashes on attempt = to create 'first' user in cluster, already created in prior run. [Comments]: Collation and encoding significant? # initdb -D /cloud/rc1 = -E UTF8 --locale=3Den_US.UTF-8 (to be sure Cluster B encoding and = 'lc_collate' matches that of Cluster A) DEBUG: autovacuum: processing database "postgres" WARNING: some databases have not been vacuumed in over 2 billion = transactions DETAIL: You might have already suffered transaction-wraparound data = loss. (really looking forward to being able to use pg_upgrade; looks like it = will save a lot of work!)= --Apple-Mail-1--1053515105 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
[TEST REPORT] 
[Release]: 9.0 RC1
[Test = Type]: pg_upgrade: 9.0-beta4 (Cluster 'A') -> 9.0-RC1 = (Cluster 'B') user 'non'-postgres.  
[Test]: pg_upgrade (...options...) -u = master 
[Parameters]: Our = administrator role is 'master' in both clusters.  User 'master' has = been created in Cluster B, SUPERUSER LOGIN CREATEROLE CREATEDB, and has = been given 'trust' access.  Logging turned on in config. =  Otherwise, cluster has been left in 'initdb' condition.
[Results]: Script connect to Database = 'A' and dumps catalog, apparently without error.
Connects to Database 'B', = crashes on attempt to create user 'postgres' - which, of course, already = exists.  Any subsequent run crashes on attempt to create 'first' = user in cluster, already created in prior run.
DEBUG:  autovacuum: processing database = "postgres"
WARNING:  some databases = have not been vacuumed in over 2 billion transactions
DETAIL:  You might have already suffered = transaction-wraparound data loss.

(really looking forward to being = able to use pg_upgrade; looks like it will save a lot of = work!)
= --Apple-Mail-1--1053515105--