Re: psql command error.

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