Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 636B5632660 for ; Sun, 15 Aug 2010 15:22:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 22446-04 for ; Sun, 15 Aug 2010 18:22:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out.mail.amis.hr (out.mail.amis.hr [194.146.109.198]) by mail.postgresql.org (Postfix) with ESMTP id 5DD53632629 for ; Sun, 15 Aug 2010 15:22:09 -0300 (ADT) Received: from out1.fsec.srv.amis.hr (out.fsec.srv.amis.hr [192.168.103.43]) by out.mail.amis.hr (Postfix) with ESMTP id 3BD43668524 for ; Sun, 15 Aug 2010 20:22:08 +0200 (CEST) Received: from pps.filterd (out1 [127.0.0.1]) by out1.fsec.srv.amis.hr (8.14.3/8.14.3) with SMTP id o7FILqd2010316 for ; Sun, 15 Aug 2010 20:22:08 +0200 Received: from smtp.amis.hr (smtp.srv.amis.hr [192.168.103.39]) by out1.fsec.srv.amis.hr with ESMTP id qn5tq099a-1 for ; Sun, 15 Aug 2010 20:22:07 +0200 Received: from [192.168.10.1] (cpe-188-129-66-199.dynamic.amis.hr [188.129.66.199]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: splivalo) by smtp.amis.hr (Postfix) with ESMTPSA id 90A0623C for ; Sun, 15 Aug 2010 20:22:07 +0200 (CEST) Message-ID: <4C683052.3070800@megafon.hr> Date: Sun, 15 Aug 2010 20:22:10 +0200 From: Mario Splivalo User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6 MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: pg_upgrade test Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.0.10011, 1.0.148, 0.0.0000 definitions=2010-08-15_07:2010-08-15, 2010-08-15, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1004200000 definitions=main-1008150129 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/13 X-Sequence-Number: 168 [TEST REPORT] [Release]: 9.0Beta4 [Test Type]: Feature test [Test]: pg_upgrade [Platform]: Ubuntu 10.04 64bit [Parameters]: Default [Failure]: No [Results]: pg_upgrade successful I run the test on the 6 GB cluster consisting of 6 databases. The 'old style' test (pg_dumpall / pg_restore) took around 26 minutes. Doing `pg_dump -Fc f` for each database, then recreating databases and users on new (9.0b4) cluster, and then pg_restoring databases took 15 minutes. (Too bad one can't pg_dumpall -Fc). Using pg_upgrade the migration took 5 minutes, including 'vacuumdb -aZ'. Great tool! Mike