Re: Problem starting PG-9.2 on non-default port - Mailing list pgsql-general

On Fri, December 14, 2012 10:21, James B. Byrne wrote:
>
> On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
>
>>
>> Assuming an RPM install, see Devrims reply.
>
> Might one inquire as to why it is necessary to override the
> configuration file in the startup script?

This is a patch for /etc/init.d/postgresql-9.2 to retrieve the port
from the postgresql.conf file and override the default setting if it
is set there.  The last two calls to 'cut' handle both tabs and spaces
as whitespace.

76a77,88
> # Override port setting from postgresql.conf if set
> PGCONFPORT=$(grep -e "^port" $PGDATA/postgresql.conf | \
>   cut -d "=" -f 2 | \
>   sed -e 's/^[ \t]*//' | \
>   cut -f1 | \
>   cut -d " " -f 1)
> if [[ -n "$PGCONFPORT" ]]  # -n == defined and not blank
> then
>   echo "Setting PGPORT to $PGCONFPORT from $PGDATA/postgresql.conf"
>   PGPORT=$PGCONFPORT
> fi
>

--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3