Re: Issue with postgresql-9.4 init.d script

From: Hima Mahi <himamahi09(at)gmail(dot)com>
To: Jeff Frost <jeff(at)pgexperts(dot)com>
Cc: pgsql-pkg-yum(at)postgresql(dot)org
Subject: Re: Issue with postgresql-9.4 init.d script
Date: 2015-08-20 15:01:16
Message-ID: CAEHY238y_qCHJwprfh+SHz4fG0GnH3K_=j6uxacLoYEio+tQEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)pgexperts(dot)com> wrote:
>
>>
>> On Aug 20, 2015, at 4:06 AM, Hima Mahi <himamahi09(at)gmail(dot)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.
>>
>>
>

In response to

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Andomar 2015-08-25 15:18:48 Re: Pgbouncer 1.6
Previous Message Hima Mahi 2015-08-20 14:38:06 Re: Issue with postgresql-9.4 init.d script