Hi there and hello to everybody,
I am all new to centos but I have good experience working with ubuntu and suse. We are moving a an elderly SuSe box to a virtual machine running centos 7. Now I experience the following problem. I can only access postgres using localhost as host. If I use the IP address (even 127.0.0.1). I found a similar problem when accessing the host using http. There I found out (after lots of hair pulling) that I have to set a value using setsebool. So I assume, that I have a similar problem here. I would be grateful, if somebody could point me in the right direction .. thanks robert
Hi Robert,
I have almost no experience with CentOS 7(still using CentOS 6). However, I recommed the following checks:
1. Check that PostgreSQL is listening on 0.0.0.0 (all ip addresses) and not 127.0.0.1. To check, you can use the command:
netstat -tuplan
If PostgreSQL is listening only on 127.0.0.1, you'll never be able to connect to it from the network. You'll have to change the PostgreSQL settings.
2. Check that iptables (firewall) is allowing the connections from the network to PostgreSQL. Use the following command to get the list of rules that are currently loaded:
iptables -L
Regards, Laurent.
2015-03-15 8:52 GMT+01:00 robert rottermann robert@redcor.ch:
Hi there and hello to everybody,
I am all new to centos but I have good experience working with ubuntu and suse. We are moving a an elderly SuSe box to a virtual machine running centos 7. Now I experience the following problem. I can only access postgres using localhost as host. If I use the IP address (even 127.0.0.1). I found a similar problem when accessing the host using http. There I found out (after lots of hair pulling) that I have to set a value using setsebool. So I assume, that I have a similar problem here. I would be grateful, if somebody could point me in the right direction .. thanks robert
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 3/15/2015 1:03 AM, Laurent CREPET wrote:
- Check that iptables (firewall) is allowing the connections from the
network to PostgreSQL. Use the following command to get the list of rules that are currently loaded:
iptables -L
I usually use
iptables -L -vn
to see the full rules and what they are doing. the default -L display is missing important bits.
On 15 March 2015 at 03:52, robert rottermann robert@redcor.ch wrote:
Hi there and hello to everybody,
I am all new to centos but I have good experience working with ubuntu and suse. We are moving a an elderly SuSe box to a virtual machine running centos 7. Now I experience the following problem. I can only access postgres using localhost as host. If I use the IP address (even 127.0.0.1). I found a similar problem when accessing the host using http. There I found out (after lots of hair pulling) that I have to set a value using setsebool. So I assume, that I have a similar problem here. I would be grateful, if somebody could point me in the right direction .. thanks robert
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Hello Robert,
See if this will help [0], by default it appears to be listening for localhost only "listen_addresses='localhost'".
[0] http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.ht...
thanks very much to everybody, it was in deed the fact, that postgres was only listening to localhost.
robert
On 15.03.2015 08:52, robert rottermann wrote:
Hi there and hello to everybody,
I am all new to centos but I have good experience working with ubuntu and suse. We are moving a an elderly SuSe box to a virtual machine running centos 7. Now I experience the following problem. I can only access postgres using localhost as host. If I use the IP address (even 127.0.0.1). I found a similar problem when accessing the host using http. There I found out (after lots of hair pulling) that I have to set a value using setsebool. So I assume, that I have a similar problem here. I would be grateful, if somebody could point me in the right direction .. thanks robert
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Earl A Ramirez -
John R Pierce -
Laurent CREPET -
robert rottermann