Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3A65A9F946C for ; Tue, 19 Dec 2006 13:11:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 55654-04 for ; Tue, 19 Dec 2006 13:10:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 9795F9F9FB2 for ; Tue, 19 Dec 2006 13:10:54 -0400 (AST) Received: by fafnir.androme.com (Postfix, from userid 1003) id 36E99B9A188; Tue, 19 Dec 2006 18:10:52 +0100 (CET) Message-ID: <45881D1A.6090904@andromeiberica.com> Date: Tue, 19 Dec 2006 18:10:50 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Suggestions needed about how to dump/restore a database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/262 X-Sequence-Number: 24054 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 -- Arnau