Re: [SQL] Duplicate tuples with unique index

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема Re: [SQL] Duplicate tuples with unique index
Дата
Msg-id 388F0DC6.49A8C61@partitur.se
обсуждение исходный текст
Ответ на Re: [SQL] Duplicate tuples with unique index  (Palle Girgensohn <girgen@partitur.se>)
Список 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
leastfor now. :(
 

Regards,
Palle


В списке pgsql-sql по дате отправления:

Предыдущее
От: Kovacs Zoltan Sandor
Дата:
Сообщение: Re: [SQL] dumping groups and users
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace