Re: Issue with postgresql-9.4 init.d script - Mailing list pgsql-pkg-yum

From Hima Mahi
Subject Re: Issue with postgresql-9.4 init.d script
Date
Msg-id CAEHY238y_qCHJwprfh+SHz4fG0GnH3K_=j6uxacLoYEio+tQEA@mail.gmail.com
Whole thread Raw
In response to Issue with postgresql-9.4 init.d script  (Hima Mahi <himamahi09@gmail.com>)
List pgsql-pkg-yum
Hi,

Please avoid my last mail. The port was commented in postgresql.conf, that's why it was not picking from there. On uncommenting it , its overriding PGPORT and working fine.

On Thu, Aug 20, 2015 at 8:08 PM, Hima Mahi <himamahi09@gmail.com> wrote:
The issue is if some other application has set PGPORT in environment variable, it reads that. It doesn't check the port mentioned in postgresql.conf. 
For example in my case, We have PostgresPlus advanced server setup on some port and this variable is set. Now , postgresql 9.4 is reading that variable and not the port mentioned in postgresql.conf. Thus , server start fails.

On Thu, Aug 20, 2015 at 8:04 PM, Jeff Frost <jeff@pgexperts.com> wrote:

On Aug 20, 2015, at 4:06 AM, Hima Mahi <himamahi09@gmail.com> wrote:

Earlier in 9.2 version, init.d script was exporting and using PGPORT for db server start. In 9.4 that option has been removed. It creates issue in case if some other PGPORT variable is set to some value. Then it uses thats value and fails to start.

I think our opinion with that change was that people should be setting the port in the postgresql.conf file.



pgsql-pkg-yum by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Issue with postgresql-9.4 init.d script
Next
From: Hima Mahi
Date:
Subject: Re: Issue with postgresql-9.4 init.d script