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@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/
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>