We've had a 7.3 PG installation running for awhile now, and would like
to upgrade to 7.3.3. The doc implies that you can do something other
than dump your existing database, set up the new installation, and
reload the dump, if you're upgrading within the 7.3 'line.' But after
looking around for awhile, I don't see any guidance on how to do this.
Is it anything more than moving the existing installation out of the
way, installing the new one in the usual way, then copying the old
PGDATA directory? (Instead of doing the initdb.) That would certainly
save some time: creating/reloading multiGbyte dump files takes awhile.
Any help with this would be appreciated!
Thanks,
Rich Cullingford
rc******@sysd.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match