Someone claims to have fixed it patching pg_upgrade: http://dba.stackexchange.com/a/50714/6978
Quoting: *"My solution is to rebuild the pg_upgrade from sources, with update to file contrib/pg_upgrade/server.c:199 where pg_upgrade checks for server version:* * * *199: (GET_MAJOR_VERSION(cluster->major_version) < 903) ?* *, in my case i change it to:* *199: (GET_MAJOR_VERSION(cluster->major_version) < 900) **?*" Clodoaldo 2013/9/18 Clodoaldo Neto <clodoaldo.pinto.n...@gmail.com> > I'm trying to upgrade Postgresql from 9.2 to 9.3 in Fedora 18 using this > command as the postgres user > > $ pg_upgrade -b /bin -B /usr/pgsql-9.3/bin -d /var/lib/pgsql/data -D > /var/lib/pgsql/9.3/data/ -j 2 -u postgres > > The error in the log: > > command: "/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D > "/var/lib/pgsql/data" -o "-p 50432 -b -c listen_addresses='' -c > unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" > start >> "pg_upgrade_server.log" 2>&1 > waiting for server to start....FATAL: unrecognized configuration > parameter "unix_socket_directory" > .... stopped waiting > pg_ctl: could not start server > > That parameter was replaced by unix_socket_directories (plural) in 9.3. > But the server version being started is 9.2: > > $ /bin/pg_ctl --version > pg_ctl (PostgreSQL) 9.2.4 > > What am I missing? > > Regards, Clodoaldo >
