Обсуждение: 9.4 and centos/yum multiversion installs
I have a CentOS 6 server thats already running 9.0, ... 9.3 for development.
I added 9.4 to it by ...
yum install
http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm
yum install postgresql94{,-devel,-server,-contrib}
I created /etc/sysconfig/pgsql/postgresql-9.4 with...
PGENGINE=/usr/pgsql-${PGMAJORVERSION}/bin
PGPORT=5436
PGDATA=/var/lib/pgsql/${PGMAJORVERSION}/data
PGLOG=/var/lib/pgsql/${PGMAJORVERSION}/pgstartup.log
(same as all the others except a unique port)
and initdb via..
service postgresql-9.4 initdb
all good so far. but when I ...
service postgresql-9.4 start
it fails, leaving the following in pgstartup.log...
< 2015-09-29 09:38:15.270 PDT >LOG: could not bind IPv6 socket:
Address already in use
< 2015-09-29 09:38:15.270 PDT >HINT: Is another postmaster already
running on port 5432? If not, wait a few seconds and retry.
< 2015-09-29 09:38:15.270 PDT >LOG: could not bind IPv4 socket:
Address already in use
< 2015-09-29 09:38:15.270 PDT >HINT: Is another postmaster already
running on port 5432? If not, wait a few seconds and retry.
< 2015-09-29 09:38:15.270 PDT >WARNING: could not create listen
socket for "localhost"
< 2015-09-29 09:38:15.270 PDT >FATAL: could not create any TCP/IP
sockets
does the 9.4 yum install no longer support using the sysconfig settings
fragments ? I see what looks like the correct shell code for it in
/etc/rc.d/init.d/postgresql-9.4 ...
# Override defaults from /etc/sysconfig/pgsql if file is present
[ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME}
....arrrrgh, comment in /etc/rc.d/init.d/postgresql-9.4 would suggest so...
# Version 9.4.0 Devrim Gunduz <devrim@gunduz.org>
# Remove PGPORT variable
so... how do you run multiple versions??
--
john r pierce, recycling bits in santa cruz
On 9/29/2015 10:09 AM, John R Pierce wrote:
does the 9.4 yum install no longer support using the sysconfig settings fragments ? I see what looks like the correct shell code for it in /etc/rc.d/init.d/postgresql-9.4 ...
# Override defaults from /etc/sysconfig/pgsql if file is present
[ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME}
....arrrrgh, comment in /etc/rc.d/init.d/postgresql-9.4 would suggest so...
# Version 9.4.0 Devrim Gunduz <devrim@gunduz.org>
# Remove PGPORT variable
so... how do you run multiple versions??
and apparently the answer is, you set pgport in postgresql.conf rather than via shell. ugh. means you can't tell the port from ps...
$ ps auxww |grep postmaster
postgres 3291 0.0 0.0 1288244 57876 ? S Aug30 13:31 /usr/pgsql-9.1/bin/postmaster -p 5433 -D /var/lib/pgsql/9.1/data
postgres 3333 0.0 0.0 2352980 76048 ? S Aug30 21:28 /usr/pgsql-9.2/bin/postmaster -p 5432 -D /var/lib/pgsql/9.2/data
postgres 3442 0.0 0.0 2352848 76060 ? S Aug30 10:57 /usr/pgsql-9.3/bin/postmaster -p 5435 -D /var/lib/pgsql/9.3/data
postgres 44139 0.0 0.0 324628 15084 ? S 10:12 0:00 /usr/pgsql-9.4/bin/postmaster -D /var/lib/pgsql/9.4/data
-- john r pierce, recycling bits in santa cruz