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(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