pg_upgrade & tablespaces

From: Joseph Kregloh <jkregloh(at)sproutloud(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade & tablespaces
Date: 2013-12-19 16:34:24
Message-ID: CAAW2xfeA1mPw4RW3-4LUTW+y4ruQFPT5Bx4c3DKUb01f4ejabw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Here is the command to check:
pg_upgrade -b /home/jkregloh/pg_bin/ -B /usr/local/bin/
-d /home/jkregloh/pg_data/ -D /usr/local/pgsql/data/ -p 5452 -P 5451 -c

As you can see the data and binary files for 9.0 are in
/home/jkregloh/pg_bin/ and /home/jkregloh/pg_data/, while the 9.3 resides
in the default location.

When running the check it reports that both clusters are compatible. Once
the actual process starts it will work fine until it starts up the 9.3 to
copy data over. The problem that I am having is that pg_upgrade is creating
the 93XXXX files under the old directory and not the new one. So when 9.3
goes to import it doesn't find anything.

Now, both versions can't share the same /data directory for obvious
reasons. Is there any way to make pg_upgrade actually export the new 9.3
files into the 9.3 directory supplied in the pg_upgrade command? I am also
open to any other upgrade ideas.

Thanks,
Joseph

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-12-19 16:52:53 Re: pg_upgrade & tablespaces
Previous Message Adrian Klaver 2013-12-19 16:17:43 Re: Installed postgres.app 9.3.1.0. pgadmin doesn't appear to see it

Browse pgsql-hackers by date

  From Date Subject
Next Message Adrian Klaver 2013-12-19 16:52:53 Re: pg_upgrade & tablespaces
Previous Message Tom Lane 2013-12-19 16:14:06 Shouldn't IsBinaryCoercible accept targettype = ANYOID?