Re: pg_upgrade unrecognized configuration parameter “unix_socket_directory”

Поиск
Список
Период
Сортировка
От Clodoaldo Neto
Тема Re: pg_upgrade unrecognized configuration parameter “unix_socket_directory”
Дата
Msg-id CA+Z73LEH3MCTduxuvKGG-bqMrZogrR3QGY_y6GEs3KSkH-fi1A@mail.gmail.com
обсуждение исходный текст
Ответ на pg_upgrade unrecognized configuration parameter “unix_socket_directory”  (Clodoaldo Neto <clodoaldo.pinto.neto@gmail.com>)
Ответы Re: Re: pg_upgrade unrecognized configuration parameter “unix_socket_directory”  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
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.neto@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Building with MinGW issue
Следующее
От: António M. Rodrigues
Дата:
Сообщение: Quotes, double quotes...