pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Urgent! Log full with inexistent PID processes
Date: Tue, 28 Jun 2011 11:38:47 +0200
Message-ID: <1309253927.5158.89.camel@deimos> (raw)
In-Reply-To: <8239iumho9.fsf@mid.bfk.de>
References: <1309174277.5158.30.camel@deimos>
	<82tybbs87y.fsf@mid.bfk.de>
	<1309252818.5158.84.camel@deimos>
	<8239iumho9.fsf@mid.bfk.de>

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.

view thread (6+ messages)

Message-ID: <1309253927.5158.89.camel@deimos>
Permalink:  ../1309253927.5158.89.camel@deimos/
Also on:    postgresql.org/message-id/1309253927.5158.89.camel@deimos

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: imartinez@vectorsf.com, fweimer@bfk.de
  Subject: Re: Urgent! Log full with inexistent PID processes
  In-Reply-To: <1309253927.5158.89.camel@deimos>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox