From: | jason(dot)christy(at)pnnl(dot)gov |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14298: service upgrade not setting ports |
Date: | 2016-08-27 07:11:42 |
Message-ID: | 20160827071142.15674.42637@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason(dot)christy(at)pnnl(dot)gov
PostgreSQL version: 9.5.4
Operating system: Red Hat Enterprise 6
Description:
In /etc/init.d/postgresql-9.5, the upgrade section searches it's init.d
script for the "PGPORT" variable with the following:
# Get port number and data directory of the old instance from the init
script
OLDPGDATA=` sed -n 's/^PGDATA=//p'
/etc/init.d/postgresql-$PGPREVMAJORVERSION`
OLDPGPORT=`sed -n 's/^PGPORT=//p'
/etc/init.d/postgresql-$PGPREVMAJORVERSION`
# Get port number and data directory of the new instance from the init
script
NEWPGDATA=` sed -n 's/^PGDATA=//p' /etc/init.d/postgresql-$PGMAJORVERSION`
NEWPGPORT=`sed -n 's/^PGPORT=//p' /etc/init.d/postgresql-$PGMAJORVERSION`
1) The PGPORT variable is not set in /etc/init.d/postgresql-9.5
2) There is a comment in the init.d script:
# Version 9.4.0 Devrim Gunduz <devrim(at)gunduz(dot)org>
# Remove PGPORT variable.
In order for me to "upgrade" postgresql from v9.4 to v9.5, I have to
manually run the pg_upgrade script.
From | Date | Subject | |
---|---|---|---|
Next Message | kop | 2016-08-27 15:50:16 | BUG #14299: initdb and man pages are not installed in the alternatives system |
Previous Message | David G. Johnston | 2016-08-26 20:30:36 | Re: BUG #14297: ON CONFLICT fails |