Have you set permissions set up on /tmp that would stop it being created?
Also I don't know wether putting in the postgresql.conf file:
tcpip_socket = True would help.
Also there are some unix socket option in postgresql.conf (namely:
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777
) Good luck on finding the problem
- Stuart
-----Original Message-----
From: Anil Jangam [mailto:anilj@indts.com]
Sent: 21 December 2001 11:01
To: pgsql-cygwin@postgresql.org
Subject: [CYGWIN] psql command error.
Importance: High
Hi,
I am stuck with an error as follows. I am trying to create a user with
'createuser' command. Also the same error is thrown even when I am trying to
run the 'psql' command.
$ createuser uss
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
createuser: creation of user "uss" failed
Administrator@ANILJ ~
$ psql
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
Administrator@ANILJ ~
$
I searched the directory /tmp/, but the .S.PGSQL.5432 file doesn't exist.
regds,
-anil.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
