Connection Refused Error
От | JohnD |
---|---|
Тема | Connection Refused Error |
Дата | |
Msg-id | 49B5A235.1010002@johndubchak.com обсуждение исходный текст |
Ответы |
Re: Connection Refused Error
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: Connection Refused Error (Adrian Klaver <aklaver@comcast.net>) Re: Connection Refused Error ("Joshua D. Drake" <jd@commandprompt.com>) |
Список | pgsql-general |
Hi, I have two "identical" servers running CentOS 5.2 with PostgreSQL 8.3.5 installed on both. Prior to a reboot this morning, I was able to connect, remotely, to both of them and doing telnet <serve-rname> 5432 brought up a prompt for them as well. However, I am now in the unfortunate situation of not being able to connect remotely to one particular server and cannot for the life of me figure out why I am getting a connection refused: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. I can ssh into the server and do a psql <db-name> from the /var/lib/pgsql command prompt, as user postgres. But, when I try to use a different user (psql -U user -p <db-name>), from the same prompt, I get: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.0"? When I look into the /tmp directory for the domain socket, I see: srwxrwxrwx 1 postgres postgres 0 Mar 9 17:44 .s.PGSQL.5432 -rw------- 1 postgres postgres 25 Mar 9 17:44 .s.PGSQL.5432.lock Also, here is the relevant piece of my pg_hba.conf file: local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 192.168.0.0/16 md5 host all all 172.16.0.0/16 password # for a VMWare instance # IPv6 local connections: host all all ::1/128 trust And, lastly, I use the following script as the postgres user to start PostgreSQL from the command prompt, manually: #!/bin/bash ARGV=$1 PG_HOME=/var/lib/pgsql PG_WORK_DIR=$PG_HOME/data if [ "$1" = "start" ] then pg_ctl -D $PG_WORK_DIR -l logfile start elif [ "$1" = "stop" ] then pg_ctl -D $PG_WORK_DIR stop fi Nothing, that I am aware of, has changed on this server that would prevent the remote connection. I have both SELinux and iptables disabled (off by default) since this is inside a firewall on a home network and is not available to the outside world. Any idea why I am no longer able to connect? Thanks for any and all help. John
В списке pgsql-general по дате отправления: