Re: postgres on SuSE 9.1

Prabu,

You need to allow Postgres to accept TCP/IP connections.
There are two ways to do that in SuSE :

1. run yast2, go to "System", click on "/etc/sysconfig Editor",
go to Applications/PostgreSQL/POSTGRES_OPTIONS
and add -i parameter, click on Finish ... SuSE will do all the rest.
2. edit file /var/lib/pgsql/data/postgresql.conf and set
tcp_socket to true. You need to restart postgres after that:
/etc/init.d/postgresql restart

Regards,
Mikhail

Prabu Subroto 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)
>patrixlinux(at)patrix:~>
>"
>
>Here what I have done
>"
>patrixlinux(at)patrix:~> su
>Password:
>patrix:/localhome/patrixlinux # su postgres
>postgres(at)patrix:/localhome/patrixlinux> cd
>postgres(at)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/
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>