Re: tracing users ip address

Couldn't you just run something like ethereal and "filter/capture to
log" all requests to the port? More then likely it's all in clear text.

> 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
>