BUG #14298: service upgrade not setting ports
The following bug has been logged on the website:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason.christy@pnnl.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@gunduz.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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Sat, Aug 27, 2016 at 07:11:42AM +0000, jason.christy@pnnl.gov wrote:
The following bug has been logged on the website:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason.christy@pnnl.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:
We did not create that startup script so I suggest you contact the place
you got the Postgres package.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
Good to know. I will reach out to Red Hat.
Thank you very much for the quick response!
-Jason
-----Original Message-----
From: Bruce Momjian [mailto:bruce@momjian.us]
Sent: Monday, August 29, 2016 11:45 AM
To: Christy, Jason E
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14298: service upgrade not setting ports
On Sat, Aug 27, 2016 at 07:11:42AM +0000, jason.christy@pnnl.gov wrote:
The following bug has been logged on the website:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason.christy@pnnl.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:
We did not create that startup script so I suggest you contact the place
you got the Postgres package.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
On Sat, 2016-08-27 at 07:11 +0000, jason.christy@pnnl.gov wrote:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason.christy@pnnl.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:
<snip>
In order for me to "upgrade" postgresql from v9.4 to v9.5, I have to
manually run the pg_upgrade script.
That code has been broken forever :-( Patches welcome :/
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Hi,
It turns out I downloaded the rpm from the following url:
https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.8-x86_64/
Do you package the rpms? If not, who does?
Thank you,
Jason
-----Original Message-----
From: Devrim Gündüz [mailto:devrim@gunduz.org]
Sent: Monday, August 29, 2016 12:00 PM
To: Christy, Jason E; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14298: service upgrade not setting ports
Hi,
On Sat, 2016-08-27 at 07:11 +0000, jason.christy@pnnl.gov wrote:
Bug reference: 14298
Logged by: Jason Christy
Email address: jason.christy@pnnl.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:
<snip>
In order for me to "upgrade" postgresql from v9.4 to v9.5, I have to
manually run the pg_upgrade script.
That code has been broken forever :-( Patches welcome :/
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
On Mon, 2016-08-29 at 19:12 +0000, Christy, Jason E wrote:
It turns out I downloaded the rpm from the following url:
https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.8-x86_64/Do you package the rpms? If not, who does?
This is the community YUM repo, and I am one of the packagers.
I'd suggest moving this discussion to pgsql-pkg-yum@postgresql.org
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR