pg_dump and "archive = none" ?? - Mailing list pgsql-sql

From Heiko Wilms
Subject pg_dump and "archive = none" ??
Date
Msg-id 382402CD.3D97A91F@stud.fh-hannover.de
Whole thread Raw
Responses Re: [SQL] pg_dump and "archive = none" ??  (Stoyan Genov <genov@digsys.bg>)
Re: [SQL] pg_dump and "archive = none" ??8  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Klaus Woelfel
Date:
Subject: showing the DEFAULT of a field
Next
From: Alex@Icepick.com (Alex)
Date:
Subject: How to get last 10 rows in a table on a large database?