Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B4C3B9FA02C for ; Wed, 20 Dec 2006 06:04:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 45120-06 for ; Wed, 20 Dec 2006 06:04:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id 3168A9F9C35 for ; Wed, 20 Dec 2006 06:04:30 -0400 (AST) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id 94E5F440DB; Wed, 20 Dec 2006 11:04:47 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id B214CC44099 for ; Wed, 20 Dec 2006 11:00:18 +0100 (CET) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08575-03 for ; Wed, 20 Dec 2006 11:00:17 +0100 (CET) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 49FC2C44097 for ; Wed, 20 Dec 2006 11:00:17 +0100 (CET) Message-ID: <458909B1.7050805@proventis.net> Date: Wed, 20 Dec 2006 11:00:17 +0100 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 1.5.0.9 (X11/20061206) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Suggestions needed about how to dump/restore a database References: <45881D1A.6090904@andromeiberica.com> In-Reply-To: <45881D1A.6090904@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/280 X-Sequence-Number: 24072 Hi, 12h is a lot. i use the copy statement with binary option. this is faster and takes less space. try pg_dump with schema only and export your 2 tables with 2 single statements. in that way i can export my db in less than 3min without downtime (pg_dump produces a 9gb file, binary dump 4.4gb) Thomas Arnau schrieb: > Hi all, > > I've got a DB in production that is bigger than 2GB that dumping it > takes more than 12 hours. I have a new server to replace this old one > where I have restore the DB's dump. The problem is I can't afford to > have the server out of business for so long, so I need your advice about > how you'd do this dump/restore. The big amount of data is placed in two > tables (statistics data), so I was thinking in dump/restore all except > this two tables and once the server is running again I'd dump/restore > this data. The problem is I don't know how exactly do this. > > Any suggestion? > > Thanks