[CentOS] Postgresql uses sockets - but I'd like to use TCP/IP

[John R Pierce]

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