tracing users ip address - Mailing list pgsql-general

From Johnson, Shaunn
Subject tracing users ip address
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C7437E@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: tracing users ip address  ("Ken Godee" <ken@perfect-image.com>)
Re: tracing users ip address  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-general

Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10

I'm looking at my logs / messages and I'm trying to figure out
how to trace some users.  For example, I am trying to make
the server a bit more secure and in some of the logs I see
someone called 'Admin' trying to access the database  (and
failing ... but for how long?)

I don't know who this is, but, I'd like to know.  Is there a way
I can track down the IP address of users trying to access
the database?  I would imagine the debug that is running - currently
I'm running debug level 2 ... seems that any  higher would
slow my server down.

I don't seem to be able to see them ('Admin') using things like 'last', 'w' or
anything like that.

Suggestions?  Thank you.

-X

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Urgent need of (paid) PostgreSQL support in New
Next
From: Medi Montaseri
Date:
Subject: Re: tracing users ip address