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
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
Am Montag, 4. April 2011 13:00 schrieb 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
thought the -p option is for "password".
But problem is solved: reinstalled Postgresql - now it works like it should
Thx Timothy
On 04/04/11 4:25 AM, Timothy Kesten wrote:
thought the -p option is for "password".
thats -P as in big P.
But problem is solved: reinstalled Postgresql - now it works like it should
say huh? seems kinda over the top for a minor usage error.
Am Montag, 4. April 2011 13:30 schrieb John R Pierce:
But problem is solved: reinstalled Postgresql - now it works like it should
say huh? seems kinda over the top for a minor usage error.
Maybe a little missconfiguration - overlooked by me :-)
Timothy
-
John R Pierce -
Timothy Kesten