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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
