You might also try setting $PGHOST=localhost - this can make life easier.
Regards, Dave.
> -----Original Message-----
> From: Henshall, Stuart - WCP
> [mailto:SHenshall@westcountrypublications.co.uk]
> Sent: 21 December 2001 14:01
> To: 'Anil Jangam'
> Cc: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
