After configuring remote access,server can't be started

Поиск
Список
Период
Сортировка
От Alex Luya
Тема After configuring remote access,server can't be started
Дата
Msg-id CAL6j_s-OY9hHbG0VRD5pJaPsLcT05CVJ7cQ_yxzfxBkHQQLwDA@mail.gmail.com
обсуждение исходный текст
Ответы Re: After configuring remote access,server can't be started  (John R Pierce <pierce@hogranch.com>)
Re: After configuring remote access,server can't be started  (Maxim Boguk <maxim.boguk@gmail.com>)
Re: After configuring remote access,server can't be started  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
My postgresql 9.4 is installed in centos 6.7,and I have followed this:

http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/

1,cd /var/libpgsql/9.4/data

2,cp  postgresql.conf.sample postgresql.conf

3,sudo vi postgresql.conf and add two lines,and save it:

listen_addresses = "*"
tcpip_socket = true

4,cp pg_hba.conf.sample pg_hba.conf

5,sudo vi pg_hba.conf then commented(maybe this is uneccessary)
#host    all             all             127.0.0.1/32            @authmethodhost@
#host    all             all             ::1/128                 @authmethodhost@

6,add two lines:(I have tried to change md5 to trust,neither works)
host    all             all             0.0.0.0/0               md5
host    all             all             ::0/0                   md5

7,then save:pg_hba.conf

8,then restart postgresql sever by

    sudo service postgresql-9.4 restart
  
9.close iptables
    sudo service iptables stop

got error:
Stopping postgresql-9.4 service:                           [  OK  ]
Starting postgresql-9.4 service:                           [FAILED]

tail  /var/lib/pgsql/9.4/pgstartup.log,got
< 2015-11-22 11:47:42.691 CST >LOG:  could not create IPv6 socket: Address family not supported by protocol
< 2015-11-22 11:47:42.718 CST >LOG:  redirecting log output to logging collector process
< 2015-11-22 11:47:42.718 CST >HINT:  Future log output will appear in directory "pg_log".

Questions are:
  1, Is this "could not create IPv6..." just a warning or the actual reason of starting failure?
  2, Where is the pg_log directory?
 

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [ADMIN] How to drop stats on table
Следующее
От: John R Pierce
Дата:
Сообщение: Re: After configuring remote access,server can't be started