X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A572332A0B2 for ; Wed, 6 Oct 2004 01:26:21 +0100 (BST) 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 02387-05 for ; Wed, 6 Oct 2004 00:26:16 +0000 (GMT) Received: from mail.kwasar.biz (s142-179-54-133.bc.hsia.telus.net [142.179.54.133]) by svr1.postgresql.org (Postfix) with ESMTP id 4228832A0B1 for ; Wed, 6 Oct 2004 01:26:17 +0100 (BST) Received: from [192.168.1.102] (geotivity.net [204.191.12.220] (may be forged)) (authenticated bits=0) by mail.kwasar.biz (8.12.10/8.12.10) with ESMTP id i960QG0u018692 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 5 Oct 2004 17:26:17 -0700 Subject: Duplicating a large database. From: Dan Hrabarchuk To: "pgsql-admin@postgresql.org" Content-Type: text/plain Message-Id: <1097022376.3710.55.camel@dan.geotivity.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Tue, 05 Oct 2004 17:26:16 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200410/97 X-Sequence-Number: 15090 I need to move a large database to new machine. I'd also like to upgrade my postgres server from 7.3 to 7.4 (at least). My plan is to set up a query log on my current postgres server. Then I will make a copy of the database using pg_dump. When the dump is done I will to shut down the original server, then run the query log on the new server. This should bring up to date, and reduce the space used. (Vacuuming is to way too slow). I've been trying to find the "query logger" portion of the plan. I've found mini-projects like taillog (http://gborg.postgresql.org/project/tablelog/projdisplay.php) but these over complicate what I want. I simply want to reply all the inserts, updates and deletes that happen on the orignal server while the new server is dumping/restoring. What can I use? A text file that I can pipe into psql would be AWESOME! Any ideas? Any half finished projects that I can complete (or at least get working enough :)? Thanks for the help Dan Hrabarchuk