X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EFDF5564E3; Mon, 28 Feb 2005 20:28:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42330-08; Mon, 28 Feb 2005 20:28:15 +0000 (GMT) Received: from svana.org (svana.org [203.20.62.76]) by svr1.postgresql.org (Postfix) with ESMTP id 63F64564C3; Mon, 28 Feb 2005 20:28:13 +0000 (GMT) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 1D5rUZ-00012d-00; Tue, 01 Mar 2005 07:27:47 +1100 Date: Mon, 28 Feb 2005 21:27:46 +0100 From: Martijn van Oosterhout To: "Jim C. Nasby" Cc: Tino Wildenhain , Jeff Davis , schen@graciousstyle.com, PgSQL General List , pgsql-docs@postgresql.org Subject: Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Message-ID: <20050228202745.GC27668@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: "Jim C. Nasby" , Tino Wildenhain , Jeff Davis , schen@graciousstyle.com, PgSQL General List , pgsql-docs@postgresql.org References: <421F3926.6090201@graciousstyle.com> <5708.1109348115@sss.pgh.pa.us> <421F5E5D.1010902@graciousstyle.com> <1109410075.4089.216.camel@jeff> <20050226213527.GA84483@decibel.org> <1109536061.9880.87.camel@Andrea.peacock.de> <20050228193658.GC533@decibel.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="i7F3eY7HS/tUJxUd" Content-Disposition: inline In-Reply-To: <20050228193658.GC533@decibel.org> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/4 X-Sequence-Number: 2900 --i7F3eY7HS/tUJxUd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote: > > I used a straight copy of the filesystem with running database > > (over the net in my case) and immediately after that, > > stop the db and rsync for the last changes. This took only > > 10 minutes (compared to 1.5h for the full filesystem copy) > > and I could start up the db in new location. > >=20 > > this could work for you too. >=20 > I hadn't thought about using rsync; that's a great idea! >=20 > Is there somewhere this could be documented? In an FAQ maybe? It works only in the special case where the PostgreSQL version number is the same and you're running on the same platform. How often are you transferring databases like that. Even transferring from i386 to amd64 wouldn't work like this AFAIUI. --=20 Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. --i7F3eY7HS/tUJxUd Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFCI37BY5Twig3Ge+YRAlXlAJ4xiy+0mrggnVUNLiertzvpQoQGPQCdHHcU wFIFezviXk0RwwBX2FyxOHI= =7WkP -----END PGP SIGNATURE----- --i7F3eY7HS/tUJxUd--