From: Bruce Momjian <bruce@momjian.us>
To: jmfox180 <mcano@stsa.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Date: Mon, 17 Jun 2013 19:08:03 -0400
Message-ID: <20130617230803.GC1997@momjian.us> (raw)
In-Reply-To: <1371491646614-5759509.post@n5.nabble.com>
References: <1371491646614-5759509.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Mon, Jun 17, 2013 at 10:54:06AM -0700, jmfox180 wrote:
> so i'm running ubuntu 12.04 with pg8.3.2 installed on it, i want to upgrade
> to 9.2.4 using the pg_upgrade. i've followed this steps:
>
> 1) download postgres9.2.4
> 2)configure it and compile it
> 3) make and install the pg_upgrade and pg_upgrade_support utilities from the
> pg9.2.4 contrib folder
> 4) init the pg9.2.4 cluster with: initdb -D /usr/local/pgsql9.2.4/data
> 5) try to check for compatibilities between the 2 clusters and getting the
> following error while logged into postgres user account.
>
> command>>
> /usr/local/pgsql9.2.0/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B
> /usr/local/pgsql9.2.0/bin/ -c -d /usr/local/pgsql/data/ -D
> /usr/local/pgsql9.2.0/data/
>
> error>>
> cannot write to log file pg_upgrade_internal.log
> Failure, exiting
>
> 6) so i decided to move on and just do an upgrade without the -c (check for
> compatibilities) :
>
> 6.1) stop both servers
> 6.2) run the same command without the -c to upgrade and getting
> :
> " this utility can only upgrade to postgresql version 9.2"
>
> please enlighten me or give me any advice.
You need write permission in the current directory. My guess is that
your /usr/local/pgsql9.2.0/data/ isn't really 9.2.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, mcano@stsa.info
Subject: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
In-Reply-To: <20130617230803.GC1997@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox