Received: from nwcst287.netaddress.usa.net (nwcst287.netaddress.usa.net [204.68.23.32]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6BFdsa25265 for ; Wed, 11 Jul 2001 11:39:54 -0400 (EDT) (envelope-from rocael@usa.net) Received: (qmail 2993 invoked by uid 60001); 11 Jul 2001 15:39:48 -0000 Message-ID: <20010711153948.2992.qmail@nwcst287.netaddress.usa.net> Received: from 204.68.23.32 by nwcst287 for [148.233.159.25] via web-mailer(34FM.0700.18.03B) on Wed Jul 11 15:39:48 GMT 2001 Date: 11 Jul 2001 09:39:48 MDT From: To: pgsql-sql@postgresql.org Subject: File system level backup X-Mailer: USANET web-mailer (34FM.0700.18.03B) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f6BFdsa25266 X-Archive-Number: 200107/147 X-Sequence-Number: 3939 Hi! I have an installation of PG7.0.2 in a disk, for some reasons I didn't use that disk anymore but right now I want to use the dbs that I have there, the point is that I've mount that disk in other file system, so I copied the old /usr/local/pgsql/data to the new /usr/local/pgsql/data and tried to access that DB using also PG7.0.2 but it didn't work. I followed the instructions at http://www.postgresql.org/idocs/index.php?backup-file.html Here's the log of the DB running the new copied /data: DEBUG: Data Base System is starting up at Wed Jul 11 05:24:07 2001 DEBUG: Data Base System was shut down at Tue Jul 10 18:20:05 2001 DEBUG: Data Base System is in production state at Wed Jul 11 05:24:07 2001 FATAL 1: Database "open" does not exist in the system catalog. I got the FATAL 1 when I do a psql open, that DB really exists in data/base by the way, the first PG installation was on RH6.2 the actual PG is on RH7.1, and both are PG7.0.2 installed from source (not rpms) What is the right way to do a dump of the DBs in this way?, I don't want to use pg_dump. Thank you, Rocael.