Hi, check your hardware (especially harddrive) for errors. regards Thomas Henry schrieb: > > Greets, > > Pg: 8.3.7 > > I'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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
