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
-- john r pierce 37N 122W somewhere on the middle of the left coast
