Dear my friends... Usually I use MySQL. Now I have to migrate my database from MySQL to Postgres.
I have created a database successfully with "creatdb" and a user account successfully. But I can not access the postgres with pgaccess. I found this error message : " Error trying to connect to database 'custadm' on host localhost PostgreSQL error message: Connection to database failed could not create socket: ©Hÿ¿pHÿ¿lHÿ¿ " Error in startup script: window ".pgaw:OpenDB" was deleted before its visibility changed while executing "tkwait visibility .pgaw:OpenDB" (procedure "::Connections::openConn" line 40) invoked from within "::Connections::openConn $i 1" (procedure "main" line 63) invoked from within "main $argc $argv" (file "/usr/bin/pgaccess" line 810) [EMAIL PROTECTED]:~> " Here what I have done " [EMAIL PROTECTED]:~> su Password: patrix:/localhome/patrixlinux # su postgres [EMAIL PROTECTED]:/localhome/patrixlinux> cd [EMAIL PROTECTED]:~> psql custadm Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit custadm=# create user someone with password 'pass_me' createdb; CREATE USER custadm=# " Anybody would be so nice to tell me why I can not access my postgres with pgaccess? Thank you very much in advance. __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html