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

From James B. Byrne
Subject Re: Problem starting PG-9.2 on non-default port
Date
Msg-id 91d3e65ec36f98bf82a6becad81c1538.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to Re: Problem starting PG-9.2 on non-default port  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: Problem starting PG-9.2 on non-default port
Next
From: Alex Aseev
Date:
Subject: postgres PANIC : heap_insert_redo: failed to add tuple