Prabu Subroto <[EMAIL PROTECTED]> wrote: > 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.
I would guess that Posgres is not listening on an IPv4 socket. I think pgaccess always connects via an IPv4 socket. (may be wrong here ...) Anyway, check your postgresql.conf file to see if the option to listen on a tcp/ip port is turned on. If not, that's almost definately your problem. -- Bill Moran Potential Technologies http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
