On Fri, Feb 15, 2013 at 03:55:02PM -0800, John R Pierce wrote: > On 2/15/2013 10:27 AM, Kevin Grittner wrote: > > You might want to try the utility which *is* supported by the > PostgreSQL community, which is pg_upgrade. For speed, consider > using the -k option. I've been able to upgrade a 3 TB database in > just a few minutes with that. (Timing depends more on the number > of database objects than their size.) > > > do note this -k option only functions if the old and new cluster are on the > same mount point, so the files can be mv'd
Actually, hard linked, not moved. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
