[ADMIN] pgdg96 repo with centos 7.x - server starts only on loopback

Поиск
Список
Период
Сортировка
От lejeczek
Тема [ADMIN] pgdg96 repo with centos 7.x - server starts only on loopback
Дата
Msg-id 14ccdc33-9442-5955-ebdd-4a68a43f5102@yahoo.co.uk
обсуждение исходный текст
Ответы Re: [ADMIN] pgdg96 repo with centos 7.x - server starts only on loopback  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
hi fellas

I'm using PostgreSQL 9.6 7 - x86_64 repo with centos 7.3.
Configuration pretty standard, including this among the lines:
...
listen_addresses = 'localhost, 192.168.2.200, 10.5.6.100'
...
and yet, after system reboot I get process listening only on:

tcp        0      0 127.0.0.1:15432         0.0.0.0:*
LISTEN      5373/postmaster
tcp6       0      0 ::1:15432               :::* LISTEN
5373/postmaster

all I have to do is to:
$ systemctl restart postgresql-9.6
to get expected results.

Is this not bizarre?
I peep into systemd's Unit and there:
...
[Unit]
Description=PostgreSQL 9.6 database server
After=syslog.target
After=network.target

seems ok, right?
What can be wrong?
many thank
L.


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

Предыдущее
От: Ben Gawiser
Дата:
Сообщение: [ADMIN] Looking for a Postgres guru (Austin)
Следующее
От: Riceal McDermott
Дата:
Сообщение: [ADMIN] Postgres SQL - Certification query