[gentoo-user] postgresql client problems

[gentoo-user] postgresql client problems

[Dirk Dil]

Hi,

My computer is an amd64 sempron with a fresh Gentoo Linux 2005.1-r1.  I'm trying to get pgaccess and
postgresql to set up.  

Both have been successfully emerged.  I can create a data base with my
user "dirk" and access it using psql.  Upon /etc/init.d/postgres stop/start
I do find the following in my logfile:
<<
LOG:  received fast shutdown request
LOG:  shutting down
LOG:  database system is shut down
LOG:  could not send test message on socket for statistics collector:
Operation not permitted
LOG:  disabling statistics collector for lack of working socket
LOG:  database system was shut down at 2005-12-15 08:35:49 CET
LOG:  checkpoint record is at 0/AC5068
LOG:  redo record is at 0/AC5068; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 558; next OID: 17231
LOG:  database system is ready
>>
When trying to access the data base using pgaccess I get the following
message:

<<
Error trying to connect to database 'test' 
 on host localhost 

PostgreSQL error message: Connection to database failed
couldn't open socket: connection refused
>>

With no further messages in the postgres log.

After having carefully followed the FAQs and all man pages etc.etc. It
refuses to connect. I havn't got a clue as to what is wrong and would
appreciate a push in the right direction.  I suspect sockets but don't
know where to go from here.

TIA for reactions

Dirk


-- 
gentoo-user@gentoo.org mailing list