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.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresql-version-9-2-tp5759509.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
