Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA66242 for ; Wed, 26 Jan 2000 10:07:54 -0500 (EST) (envelope-from girgen@partitur.se) Received: from elbas.partitur.se (elbas.partitur.se [193.219.246.222]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id QAA21516; Wed, 26 Jan 2000 16:07:50 +0100 (CET) (envelope-from girgen@partitur.se) Received: from partitur.se (localhost [127.0.0.1]) by elbas.partitur.se (8.9.3/8.9.3) with ESMTP id QAA02670; Wed, 26 Jan 2000 16:07:50 +0100 (CET) (envelope-from girgen@partitur.se) Sender: girgen@partitur.se Message-ID: <388F0DC6.49A8C61@partitur.se> Date: Wed, 26 Jan 2000 16:07:50 +0100 From: Palle Girgensohn Organization: Partitur X-Mailer: Mozilla 4.7 [en] (X11; I; FreeBSD 3.3-RELEASE i386) X-Accept-Language: sv, en MIME-Version: 1.0 To: Tom Lane CC: Bruce Momjian , Patrik Kudo , "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] Duplicate tuples with unique index References: <200001260033.TAA04733@candle.pha.pa.us> <388E41AD.E94D52A5@partitur.se> <16091.948865123@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > Thanks for the info. Very interesting reading! > Bruce thinks that the pg_upgrade script will ensure that the system- > table tuples are all in frozen states (by VACUUMing them). I don't > trust it worth a dime, myself. Maybe it will work, but it hasn't been > proven in the field. So, if you'd like to try it, by all means do so > --- but make a pg_dump backup first! And let us know whether you have > problems or not! I never tried it; I did an old fashion dump+initdb+restore. So, we will not know whether pg_upgrade is OK or not, at least for now. :( Regards, Palle