Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B094764FC41 for ; Mon, 8 Dec 2008 19:27:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49526-03 for ; Mon, 8 Dec 2008 19:27:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by mail.postgresql.org (Postfix) with ESMTP id B35AC64FC4E for ; Mon, 8 Dec 2008 19:27:09 -0400 (AST) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=ISO-8859-1; format=flowed Received: from [192.168.0.52] ([96.21.103.185]) by VL-MO-MR001.ip.videotron.ca (Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug 3 2007; 32bit)) with ESMTP id <0KBK00EP0ZT72QC0@VL-MO-MR001.ip.videotron.ca> for pgsql-admin@postgresql.org; Mon, 08 Dec 2008 18:27:07 -0500 (EST) Message-id: <493DAD4B.50005@videotron.ca> Date: Mon, 08 Dec 2008 18:27:07 -0500 From: PJ User-Agent: Thunderbird 2.0.0.18 (X11/20081206) To: pgsql-admin@postgresql.org Subject: recover or move databases X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/66 X-Sequence-Number: 30899 I am trying to recover postgres databases from a crashed disk. I have set up a new installation of FreeBSD 7.0 with postgresql8.3. The old databases are accessible when the repaired disk is mounted : /oldfsb/local/pgsql/data/base/. How can I move these databases to the new /usr/local/pgsql/data/base/ ? Old and new are both v. 8.3 Copying does not do it. This seems to be one way, but it seems rather long... and complicated.. Any help would be appreciated, PJ