Re: Urgent! Log full with inexistent PID processes

From: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent! Log full with inexistent PID processes
Date: 2011-06-28 09:38:47
Message-ID: 1309253927.5158.89.camel@deimos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bfk(dot)de>
To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
Cc: pgsql-admin(at)postgresql(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Saurabh Agrawal 2011-06-28 11:13:03 ERROR: cache lookup failed for relation 778112
Previous Message Florian Weimer 2011-06-28 09:25:26 Re: Urgent! Log full with inexistent PID processes