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

Поиск
Список
Период
Сортировка
От James B. Byrne
Тема Re: Problem starting PG-9.2 on non-default port
Дата
Msg-id 7fe7520761547380b7f2bd78a3844822.squirrel@webmail.harte-lyne.ca
обсуждение исходный текст
Ответ на Re: Problem starting PG-9.2 on non-default port  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Fwd: [JDBC] Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Следующее
От: "James B. Byrne"
Дата:
Сообщение: Re: Problem starting PG-9.2 on non-default port