X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0C217D1B523 for ; Wed, 29 Oct 2003 13:44:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26606-02 for ; Wed, 29 Oct 2003 09:43:31 -0400 (AST) Received: from 216.127.68.117 (unknown [216.127.68.117]) by svr1.postgresql.org (Postfix) with SMTP id 9C5FFD1B544 for ; Wed, 29 Oct 2003 09:43:22 -0400 (AST) Received: (qmail 8159 invoked from network); 29 Oct 2003 13:43:25 -0000 Received: from m067-126.nv.iinet.net.au (HELO meerkatsoft.com) (203.217.67.126) by localhost with SMTP; 29 Oct 2003 13:43:25 -0000 Message-ID: <3F9FC3F3.2020509@meerkatsoft.com> Date: Wed, 29 Oct 2003 22:43:15 +0900 From: Alex User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en, ja MIME-Version: 1.0 To: Postgre Admin Subject: PG_DUMP Question Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/408 X-Sequence-Number: 10969 Hi, I have a test system that is setup the same as a production system and would like to frequently copy the database over. pg_dump takes a few hours and even sometimes hangs. Are there any reasons not to simply just copy the entire data directory over to the test system? I could not find any postings on the net suggesting otherwise. Is there anything to pay attention too ? Thanks for any advise Alex