Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2." - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Date
Msg-id 20130619165228.GA14311@momjian.us
Whole thread Raw
In response to Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
On Mon, Jun 17, 2013 at 07:08:03PM -0400, Bruce Momjian wrote:
> 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.

FYI, this is the same person posting as Marcos Cano.  I am working with
him via private email.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


pgsql-admin by date:

Previous
From: jmfox180
Date:
Subject: PG_UPRADE issue
Next
From: Ziggy Skalski
Date:
Subject: Re: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."