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?$ 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