Upgrade: 9.0.5->9.3.3

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade: 9.0.5->9.3.3
Date: 2014-03-17 23:04:02
Message-ID: alpine.LNX.2.11.1403171552010.20082@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Now, -9.0.5 is installed in /usr/local/pgsql/ and -9.3.3 is installed in
/opt/pgsql-9.3.3. I want to use pg_upgrade and have read the Web page with
the instructions.

Instruction #4 tells me to install pg_upgrade and pg_upgrade_support. I
have the 9.0.5 version of pg_upgrade in /opt/postgresql-9.0.5/contrib/
(without pg_upgrade_support). But, I do not see the 'contrib' page on
postgresql.org. I find the 'community' and 'foundry' pages, but not the
'contrib' page. A pointer to pg_upgrade and pg_upgrade_support for 9.3.3 is
needed.

If my reading of the instructions is correct, the following command line
should migrate my few, small databased from 9.0.5 to 9.3.3:

pg_upgrade -b /usr/local/pgsql/bin -B /opt/pgsql-9.3.3/bin -d \
/usr/local/pgsql/data -D /opt/pgsql-9.3.3/data

I don't see that I need any additional options. Do I?

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-03-17 23:26:08 Re: Upgrade: 9.0.5->9.3.3
Previous Message Merlin Moncure 2014-03-17 21:30:47 Re: SQL advice needed