Re: "the database system is starting up"

From: Dennis Thrysøe <dth(at)geysirit(dot)dk>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: <pgsql-admin(at)postgresql(dot)org>, <devrim(at)gunduz(dot)org>
Subject: Re: "the database system is starting up"
Date: 2010-04-13 06:54:00
Message-ID: 3E8A6939-C726-4FD1-B992-39507A8F91C2@geysirit.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrysøe<dth(at)geysirit(dot)dk> wrote:
>
>> Are there any good tools or logging options for determining
>> who/what?
>
> Are you on a recent enough version to have log_connections and
> log_disconnections available? If so, I would turn those on in
> postgresql.conf.

Yes, that tells me that connection attempts are from the local host on incrementing port numbers for each attempt.

Are there any tools that will help me figure out which process is doing this?

lsof -i and netstat -p gave me nothing...

Thanks,

-dennis

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Renato Oliveira 2010-04-13 07:42:19 'COPY' Statement
Previous Message Jose Berardo 2010-04-12 16:36:43 PostgreSQL with SSL