| From: | Palle Girgensohn <girgen(at)partitur(dot)se> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Patrik Kudo <kudo(at)partitur(dot)se>, "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] Duplicate tuples with unique index |
| Date: | 2000-01-26 15:07:50 |
| Message-ID: | 388F0DC6.49A8C61@partitur.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-01-26 18:34:38 | Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace |
| Previous Message | Kovacs Zoltan Sandor | 2000-01-26 12:28:15 | Re: [SQL] dumping groups and users |