"r...@me.com" <r...@me.com> wrote: > I have tried upgrading a database from 8.4 to 9.1 and > pg_upgradecluster is terribly slow.
I had never heard of pg_upgradecluster sluster; a google search suggests that there is an Ubuntu utility by that name, so you might want to register a complaint there; this list is definitely not the right place for that. 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.) http://www.postgresql.org/docs/9.1/interactive/pgupgrade.html -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs