Cannot login for short period of time

From: Henry <henry(at)zen(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Cannot login for short period of time
Date: 2009-05-12 12:17:06
Message-ID: 20090512141706.13386168ycacu884@zenmail.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-05-12 12:39:18 Re: Luhn algorithm (credit card verify / check) implementation - FIX
Previous Message Ow Mun Heng 2009-05-12 12:06:25 Re: Putting many related fields as an array