Phoenix Kiula escribió: > Thanks. Comments below. (PS: I am still unable to connect to > postgresql even in SSH! I see this message: > > psql: could not connect to server: Connection timed out > Is the server running on host "localhost" and accepting > TCP/IP connections on port 5432? > > Yes of course the localhost is running the pgsql server and that port > is allowed! My educated guess is that your network is behaving funny, or your firewall is crazy. Or your kernel has bugs. The fact that the connections work sometimes is one clue; this is the other: > LOG: test message did not get through on socket for statistics collector > LOG: disabling statistics collector for lack of working socket This is a bad sign. For one thing, it means autovacuum, if enabled, is not really working at all (which can, in turn, explain slowness). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
