| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_upgrade & tablespaces |
| Date: | 2013-12-19 20:53:48 |
| Message-ID: | 20131219205348.GB1688@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thu, Dec 19, 2013 at 11:34:24AM -0500, Joseph Kregloh wrote:
> Hello,
>
> I am trying to upgrade from 9.0.14 to 9.3. I am using the pg_upgrade utility. I
> need to use pg_upgrade because my production database is 800GB+ and with over
> 80 tablespaces and doing an export from 9.0 and importing to 9.3 would take at
> least 2 days.
>
> Currently I am testing on the development database which is only 100GB with a
> same number of tablespaces. I am working on FreeBSD with jails. So one jail
> contains 9.0 and the other 9.3. In the 93 jail I mount the data and binary
> directories for the 9.0 jail.
Why don't you do run pg_upgrade in the same jail then just move the
files over to the new jail? That should work better. I am unclear how
a cross-jail upgrade would work at all.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2013-12-19 20:59:57 | Re: pg_upgrade & tablespaces |
| Previous Message | Joseph Kregloh | 2013-12-19 20:53:21 | Re: pg_upgrade & tablespaces |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2013-12-19 20:59:57 | Re: pg_upgrade & tablespaces |
| Previous Message | Joseph Kregloh | 2013-12-19 20:53:21 | Re: pg_upgrade & tablespaces |