Re: Missing PGPORT in initscript causing problems with non standard port

From: Strahinja Kustudić <strahinjak(at)nordeus(dot)com>
To: "Rampersad, Shaun" <Shaun(dot)Rampersad(at)fnb(dot)co(dot)za>
Cc: "pgsql-pkg-yum(at)postgresql(dot)org" <pgsql-pkg-yum(at)postgresql(dot)org>
Subject: Re: Missing PGPORT in initscript causing problems with non standard port
Date: 2015-03-03 15:42:26
Message-ID: CADKbJJUJDUMKuJXxnb3BY616dXZAhQV9xytW_NYfY4oH+qexvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

Hi Shaun,

You can now change the port in postgresql.conf, so I don't see any problems
with this. It is much easier this way, since before with setting PGPORT
variable it wasn't clear why was there an option to set port in the config
file as well (since it was ignored).

Strahinja Kustudić | Lead System Engineer | Nordeus

On Tue, Mar 3, 2015 at 2:08 PM, Rampersad, Shaun <Shaun(dot)Rampersad(at)fnb(dot)co(dot)za>
wrote:

> Hi all
>
> I need some help and clarity regarding the PGPORT variable.
>
> I’ve installed the latest postgres server (9.4.1) from your yum repo. I’ve
> noted in the init script that the PGPORT is removed.
>
> # Version 9.4.0 Devrim Gunduz <devrim(at)gunduz(dot)org>
>
> # Remove PGPORT variable.
>
>
>
> The problem is that there is now no way to change the port in
> /etc/sysconfig/pgsql/postgresql and have that change reflect with a
> restart.
>
> PGDATA=/data
>
> PGPORT=6432
>
> Why was this removed in 9.4? I cant seem to find any information regarding
> this. How would I change the port of the DB via this file?
>
> NB: I am trying to configure a puppet module to roll out multiple engines
> and configuring the PGPORT within the sysconfig file is the best solution.
> I do not want to modify the initscript to achieve this since it works in 9.3
>
> If I need to log a bug/ticket, please let me know where to do this.
>
> Thanks for your help in this
>
> Regards
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *Shaun Rampersad* | Technical Team Lead | FNB Homeloans
> 1 Enterprise Road, Failands, Gauteng | Tel: (087) 3353022
> E-mail: shaun(dot)rampersad(at)fnb(dot)co(dot)za | Web: www.fnb.co.za | Mobile:
> www.fnb.mobi
>
> Find us on all major social media platforms.
>
>
>
> To see the full legal disclaimer pertaining to this e-mail refer to
> www.fnb.co.za
>
>
>
> First National Bank - a division of FirstRand Bank Limited. An Authorised
> Financial Services and Credit Provider (NCRCP20).
>
>
>
>
>
> To read FirstRand Bank's Disclaimer for this email click on the following
> address or copy into your Internet browser:
> https://www.fnb.co.za/disclaimer.html
>
> If you are unable to access the Disclaimer, send a blank e-mail to
> firstrandbankdisclaimer(at)fnb(dot)co(dot)za and we will send you a copy of the
> Disclaimer.
>
>

In response to

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Nicolas Dey 2015-03-09 15:01:32 Re: postgresql93-odbc RPM for x32 and x64
Previous Message Rampersad, Shaun 2015-03-03 13:08:36 Missing PGPORT in initscript causing problems with non standard port