Re: Urgent! Log full with inexistent PID processes - Mailing list pgsql-admin

From Iñigo Martinez Lasala
Subject Re: Urgent! Log full with inexistent PID processes
Date
Msg-id 1309253927.5158.89.camel@deimos
Whole thread Raw
In response to Re: Urgent! Log full with inexistent PID processes  (Florian Weimer <fweimer@bfk.de>)
List pgsql-admin
You are my man, bud. :)

A remote server was launching a process against this database. We had limited access via pg_hba.conf (or at least we thought access was limited). Since a database admin was modifiying config in paralell with me, we have a mess with config and so access restriction was not applying.

Thank you very mucho.

-----Original Message-----
From: Florian Weimer <fweimer@bfk.de>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Urgent! Log full with inexistent PID processes
Date: Tue, 28 Jun 2011 09:25:26 +0000

* Iñigo Martinez Lasala:

> There is are no connections to DB. Only app using database is a web app
> that has been stopped also.

Uh-oh.  Can you "strace -f" the postmaster?  Surely something is
connecting to it.


pgsql-admin by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Urgent! Log full with inexistent PID processes
Next
From: Saurabh Agrawal
Date:
Subject: ERROR: cache lookup failed for relation 778112