X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E9627476022 for ; Thu, 6 Feb 2003 17:43:41 -0500 (EST) Received: from polaris.pinpointresearch.com (66-7-238-176.cust.telepacific.net [66.7.238.176]) by postgresql.org (Postfix) with ESMTP id 907C247633C for ; Thu, 6 Feb 2003 16:56:47 -0500 (EST) Received: from there (66-7-238-179.cust.telepacific.net [66.7.238.179]) by polaris.pinpointresearch.com (Postfix) with SMTP id EDC38103F5; Thu, 6 Feb 2003 13:56:48 -0800 (PST) Content-Type: text/plain; charset="iso-8859-1" From: Steve Crawford Organization: Pinpoint Research To: Matias Monteverde , pgsql-admin@postgresql.org Subject: Re: Date: Thu, 6 Feb 2003 13:56:49 -0800 X-Mailer: KMail [version 1.3.1] References: <1044475418.5096.3.camel@padme> In-Reply-To: <1044475418.5096.3.camel@padme> MIME-Version: 1.0 Message-Id: <20030206215648.EDC38103F5@polaris.pinpointresearch.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/107 X-Sequence-Number: 7305 If I understand correctly, you should be able to copy the files directly if= =20 the database is shut down (completely stopped, not just idle). But have you considered running pg_dump from your other machine? As long as= =20 you set postgresql to accept remote connections and pg_hba.conf allows them= =20 from the other machines then you can have your server on machine A and run= =20 your pg_dump or pg_dumpall on machine B saving its output to that machine. Or, if you can rsh from machine B to a you can use rsh to start your dump= =20 (ie. rsh A "pg_dumpall ..." > backupfile) so pg_dumpall will be running on = A=20 but dumping its output across the wire to stdout on B which then gets=20 redirected to your bakup file (of if you want to be fancy, directly as inpu= t=20 to psql to create the database on your other machine). "There's more than one way to do it." Cheers, Steve On Wednesday 05 February 2003 12:03 pm, 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.