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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
