Timothy Kesten
2011-Apr-04 10:44 UTC
[CentOS] Postgresql uses sockets - but I'd like to use TCP/IP
Hi Folks,
CentOS 5.5 - Postgresql 8.4
Installed - startet
try to
createuser -d- -a -p username
get message
could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
postrgesql.conf has line
listen_addresses = '192.168.0.2'
Why sockets (in /tmp are s.PGSQL.5431 )
What goes wrong?
I have an other installation on other server with same conf. Files.
There works all as I expect (no socket).
Any hints welcome
Thx
Timothy
John R Pierce
2011-Apr-04 11:00 UTC
[CentOS] Postgresql uses sockets - but I'd like to use TCP/IP
On 04/04/11 3:44 AM, Timothy Kesten wrote:> Hi Folks, > > CentOS 5.5 - Postgresql 8.4 > > Installed - startet > > try to > > createuser -d- -a -p username > > get message > > could not connect to server: Connection refused > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.0"?-p is the port number. you seem to have convinced it to use port 0 which obviously isn't correct if you want to use tcp, you would specify a hostname via -h