hi-problem in creating database in postgresql 7.2.2
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
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
Show quoted text
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 failedsimilar 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" failedcan u help me please? thnx in advance.
regards,
saurabh garg
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
