Connectting PostrgreSQL with GUI pgaccess fail
 

Red Hat 9 in a Intel Petium III box

Hello everybody

I start the PostgreSQL with the script:
$/etc/rc.d/init.d/posgresql start

When I try to connect PostgreSQL with GUI pgaccess with the command:

$ pgaccess mydatabase

I get this oupput:

"Segment violate"

I verified the existence of pgaccess with the command:"find / -name pgaccess* -print" and this is the output I get:

/usr/bin/pgaccess
/usr/share/pgsql/pgaccess
/usr/share/man/man1/pgaccess/pgaccess.1.gz

I must tell you that I have setup "tcpip-socket=true" in the configuration file of PostgreSQL, because I believe with this setting is same as start the postmaster with "i" option.

Do you know why I can not connect to PostgreSQL with pgaccess?

First, check postgres is working with
psql -U user -h host database

Yes It is working

Try to update version pgaccess and depending packages.
Sorry, I was install pgacces from sources.

Setting the "tcpip-socket=true" is not the same as starting with the "i" option, they are both neccesary and separate steps.