Here is the last thing I think I promised for 6.4. It is a script that
will allow 6.3.* users to upgrade to 6.4 without reloading all their
It works by copying the user tables/index files to a backup directory,
destroying and recreating the database, then using the
pg_dump/pg_dumpall output to re-create the tables and indexes, without
the COPY commands. It then moves the table/index files back into the
If it works and people like it, I will write up a manual page, and
mention it so people can use it.
I am not sure how to preserve the database owner because I need to
drop/recreate the database. Any ideas?
Vadim, I assume you did not change anything in the table or index
structure. You mentioned an index change, but I do not think you made
it, did you?
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-08-30 03:13:32|
|Subject: Re: [HACKERS] Documentation fix|
|Previous:||From: Marc Howard Zuckman||Date: 1998-08-30 02:20:43|
|Subject: Documentation fix|