Greets, Pg: 8.3.7I'm trying to diagnose why I cannot login to Pg on occasion. The psql command will just hang (so I cannot get in to see what it's doing) and a telnet into 5432 will give the usual:
Connected to localhost (127.0.0.1). Escape character is '^]'. indicating the backend accepting the connection, but not proceeding.The number of connections at the time are small, file descriptor usage will be small, etc, server load low.
It will then spontaneously recover as if it's just completed doing something IO intensive.
My config: listen_addresses = '1.2.1.1,127.0.0.1' port = 5432 max_connections = 2048 shared_buffers = 520MB temp_buffers = 128MB work_mem = 1512MB max_fsm_pages = 512000 fsync = off checkpoint_segments = 32 effective_cache_size = 512MB constraint_exclusion = on logging_collector = on track_counts = on autovacuum = on autovacuum_freeze_max_age = 2000000000 I'm rerunning things with statement logging turned on to get a clue.Incidentally, I did have to reindex the system tables in single-user mode (got a "Cannot find namespace 0" error at some point).
Anyone have an idea what this strange connectivity-delay could be about? Cheers Henry
Attachment:
pgp5Pr7mZNz9s.pgp
Description: PGP Digital Signature
