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

On Fri, December 14, 2012 10:21, James B. Byrne wrote:
>
> 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
>

A slight, but important, correction that handles leading white space
in the first selection:

76a77,88
> # Override port setting from postgresql.conf if set
> PGCONFPORT=$(grep -e "^\s*port" $PGDATA/postgresql.conf | \
>   cut -d "=" -f 2 | \
>   sed -e 's/^[ \t]*//' | \
>   cut -f1 | \
>   cut -d " " -f 1)
> if [[ -n "$PGCONFPORT" ]]  # -n == defined and non-blank -z == not
defined
> 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