PostgreSQL running under Cygwin does not operate with Unix sockets. You
need to start the postmaster with TCP/IP sockets. Simply edit your
"postgresql.conf" file (it should be in your postgres data directory)
and add the line "tcpip_socket = true", and restart your postmaster. All
your postgres commands will have to use --host=localhost to instruct
them to use the tcpip socket.
Hope that helps!
Jord Tanner
Independent Gecko Consultants
On Thu, 2002-10-31 at 04:57, saurabh garg wrote:
> hi
> i have sucessfully installed postgresql. now while creating database it
> gives the following error. i'm running pgsqlserver on localhost.
>
> i give the command createdb -D /usr/local/share/data/data
>
>
> $ createdb -D /usr/local/share/data/data
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createdb: database creation failed
>
> similar problem is there when i create user.
>
> $ createuser saurabh with password 'saurabh';
> 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) y
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createuser: creation of user "saurabh" failed
>
>
> can u help me please? thnx in advance.
>
>
> regards,
>
>
> saurabh garg
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org