On Wed, Jul 10, 2013 at 11:52:54AM -0700, Wells Oliver wrote: > Can anyone speak to the speed of pg_upgrade? Our database is 153GB. From > 9.1 to 9.2, I'm nervous it might take hours. If it were less than hour, > downtime would be more acceptable. > You can use the --link option and then you make hard links instead of requiring a copy of the data files. It should be pretty fast. Without --link a copy of 153GB could take a while. :) http://www.postgresql.org/docs/9.2/interactive/pgupgrade.html Ken -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
