From: | Alex Luya <alexander(dot)luya(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | After configuring remote access,server can't be started |
Date: | 2015-11-22 09:54:16 |
Message-ID: | CAL6j_s-OY9hHbG0VRD5pJaPsLcT05CVJ7cQ_yxzfxBkHQQLwDA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <http://0.0.0.0/0>
> md5host 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?
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2015-11-22 10:33:25 | Re: After configuring remote access,server can't be started |
Previous Message | Jeff Janes | 2015-11-21 21:45:03 | Re: [ADMIN] How to drop stats on table |