Hello people,

I need some help getting postgresql started on an amd64 machine running
gentoo 2005.1.

when reloading postgres I get the following error in the logs:
<<
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-16 09:04:16 CET
LOG: checkpoint record is at 0/AC5188
LOG: redo record is at 0/AC5188; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 559; next OID: 17231
LOG: database system is ready
>>
3rd and 4th lines stand out.

When tring to connect with a client (pgaccess) I get the following error
and no access (no pun intended).

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

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

My guess is that I have a socket problem. How do I go about solving
this?

Thanks for any help.

Dirk




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Dirk Dil <dirk.dil@pt.lu> writes:
> I need some help getting postgresql started on an amd64 machine running
> gentoo 2005.1.

> LOG: could not send test message on socket for statistics collector:
> Operation not permitted
> LOG: disabling statistics collector for lack of working socket

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

Both of these look like kernel packet filtering is rejecting the
traffic. Take a look at your iptables configuration --- it's probably
being overly restrictive about local-loopback (127.0.0.1) connections.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster