From: | Clodoaldo Neto <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
---|---|
To: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade unrecognized configuration parameter “unix_socket_directory” |
Date: | 2013-09-29 10:12:43 |
Message-ID: | CA+Z73LEH3MCTduxuvKGG-bqMrZogrR3QGY_y6GEs3KSkH-fi1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)pinto(dot)neto(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | António M. Rodrigues | 2013-09-29 13:09:54 | Quotes, double quotes... |
Previous Message | Martijn van Oosterhout | 2013-09-29 09:33:56 | Re: Building with MinGW issue |