X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6E4704758FE for ; Thu, 6 Feb 2003 09:38:26 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id 696BE47590C for ; Thu, 6 Feb 2003 09:38:25 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h16F2J6P013895; Thu, 6 Feb 2003 10:02:20 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h16EcOj15633; Thu, 6 Feb 2003 09:38:28 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id CWVLDLVL; Thu, 6 Feb 2003 09:38:22 -0500 Subject: Re: From: Robert Treat To: Matias Monteverde Cc: pgsql-admin@postgresql.org In-Reply-To: <1044475491.5096.5.camel@padme> References: <1044475491.5096.5.camel@padme> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 06 Feb 2003 09:38:24 -0500 Message-Id: <1044542304.22884.118.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/82 X-Sequence-Number: 7280 On Wed, 2003-02-05 at 15:04, Matias Monteverde wrote: > Dear list: > > I need to move all databases from one fiscal server to other, > but, the > main problem I have is: I can't dump databases, for internal problems > from hdd. My question is, so, how can rescue all databases in 'cp > command' way in posgresql version 7.0 ? > > > Needing to know: > > I copy /usr/local/pgsql/data/base. > > Any help will be great. > If your not upgrading versions, I feel this should work. If you are upgrading version, I'm less optimistic but wouldn't rule it out untill it was tried. In either case, make sure to shutdown your database first; copied files on a live database are almost sure to have issues. Robert Treat