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)
patrixlinux@patrix:~>
"
Here what I have done
"
patrixlinux@patrix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix:/localhome/patrixlinux> cd
postgres@patrix:~> 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/
