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
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 |
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? |