Postgres Pro
Downloads
Home   >   mailing lists

After configuring remote access,server can't be started - Mailing list pgsql-general

From Alex Luya
Subject After configuring remote access,server can't be started
Date
Msg-id CAL6j_s-OY9hHbG0VRD5pJaPsLcT05CVJ7cQ_yxzfxBkHQQLwDA@mail.gmail.com
Whole thread Raw
Responses Re: After configuring remote access,server can't be started
Re: After configuring remote access,server can't be started
Re: After configuring remote access,server can't be started
List pgsql-general
Tree view
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [ADMIN] How to drop stats on table
Next
From: John R Pierce
Date:
Subject: Re: After configuring remote access,server can't be started