Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2DB2B1336FA7 for ; Tue, 22 Mar 2011 13:56:42 -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 54864-04 for ; Tue, 22 Mar 2011 16:56:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149098.authsmtp.com (outmail149098.authsmtp.com [62.13.149.98]) by mail.postgresql.org (Postfix) with ESMTP id 6ABD913364DE for ; Tue, 22 Mar 2011 13:56:23 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt5.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p2MGuMNA057387 for ; Tue, 22 Mar 2011 16:56:22 GMT Received: from Sidney-Stratton.local (70-36-197-225.dsl.dynamic.sonic.net [70.36.197.225]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p2MGuGVp019624 for ; Tue, 22 Mar 2011 16:56:17 GMT Message-ID: <4D88D4B0.9030802@agliodbs.com> Date: Tue, 22 Mar 2011 09:56:16 -0700 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: pgsql-docs@postgreSQL.org Subject: Migration page is out of date X-Enigmail-Version: 0.97a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 4e6b62ba-54a5-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8FUg9K Gl5dNUZcKlAnfHUf XCRcFVZWTyAgG3x3 awtQfQRbaE9IVQRi Hk9JXFFUCgRhBgID BBsBUBxwchpGNj5y GDEnKRYbXEVzc0R5 DEdXESMCMGEybmJN AV1dc1JRbQJLKx9Y Y1ctBm4NYWcFYH5p QF9uZmAnGDRQMi1J QwYLZUobTktDHyV0 QA0eVTIhVUEMWyhb X-Authentic-SMTP: 61633136333939.1014:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.6 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201103/116 X-Sequence-Number: 6549 http://www.postgresql.org/docs/9.0/static/migration.html This page: a) has insufficient coverage of pg_upgrade b) ignores parallel pg_restore c) piping pg_dump is by no means always the fastest method I'll write up a new version later, just wanted to put this note on the ML so that somebody would bug me before the end of 9.1 beta. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com