Received: from unixserv.rz.fh-hannover.de (root@rzgw.rz.fh-hannover.de [141.71.1.10]) by hub.org (8.9.3/8.9.3) with SMTP id FAA20955 for ; Sat, 6 Nov 1999 05:37:29 -0500 (EST) (envelope-from wilms@stud.fh-hannover.de) Received: from schering.si.uni-hannover.de by unixserv.rz.fh-hannover.de (AIX 3.2/UCB 5.64/4.03) id AA34432; Sat, 6 Nov 1999 11:43:50 +0100 Sender: wilms@unixserv.rz.fh-hannover.de Message-Id: <382402CD.3D97A91F@stud.fh-hannover.de> Date: Sat, 06 Nov 1999 11:28:30 +0100 From: Heiko Wilms Organization: Schering-Institut X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en Mime-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: pg_dump and "archive = none" ?? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I just upgraded from 6.1 to 6.5.2. The databases were saved with pg_dump before. When I tried to restore them something went wrong while creating the tables. The postmaster complained about "archive = none" after the table definition part in the dumpfile. It looked like this: create table foo (var1 text, var2 ....) archive = none; Even pg_dump -d puts the archive tag in the dumpfile. So I deleted that and everything went its way. Testing the database didn't make any trouble but now I wonder if there might occur a problem some day because of this a"archive" stuff. Any idea? Heiko -- H. Wilms Homepage schering.si.uni-hannover.de/hugo email wilms@stud.fh-hannover.de