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. :(
In response to
pgsql-sql by date
|Next:||From: Peter Eisentraut||Date: 2000-01-26 18:34:38|
|Subject: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace|
|Previous:||From: Kovacs Zoltan Sandor||Date: 2000-01-26 12:28:15|
|Subject: Re: [SQL] dumping groups and users |