Re: Problem starting PG-9.2 on non-default port

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(at)Harte-Lyne(dot)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