Re: [GENERAL] Dump/Reload pg_statistic to cut time from pg_upgrade?

2013-09-03 Thread Bruce Momjian
On Sun, Sep 1, 2013 at 10:35:57AM -0700, Jeff Davis wrote: [ late response, but might still be useful to someone ] You can work around the problem with a little effort if you call array_in directly. It takes the type output (cstring), element type (oid), and element typmod (integer). To

Re: [GENERAL] Dump/Reload pg_statistic to cut time from pg_upgrade?

2013-09-01 Thread Jeff Davis
On Mon, 2013-07-08 at 14:20 -0500, Jerry Sievers wrote: Planning to pg_upgrade some large (3TB) clusters using hard link method. Run time for the upgrade itself takes around 5 minutes. Nice!! Origin version 8.4 and destination version 9.1. Unfortunately the post-upgrade analyze of the

[GENERAL] Dump/Reload pg_statistic to cut time from pg_upgrade?

2013-07-09 Thread Jerry Sievers
Originally posted on pg_admin but got no bites there... Admins; Planning to pg_upgrade some large (3TB) clusters using hard link method. Run time for the upgrade itself takes around 5 minutes. Nice!! Origin version 8.4 and destination version 9.1. Unfortunately the post-upgrade analyze of the