PostgreSQL 13 capture audit logs of actual IP address

Asked Sep 13 '21 at 09:18

Active Sep 13 '21 at 09:42

Viewed 579 times

I am working on configuring PgAudit on my PostgreSQL database so when my clients access my PostgreSQL, it will capture a log of the action they perform.

My Client PC have got their actual IP address and a VPN connection address, the VPN connects to my PostgreSQL database server. The problem is how can I capture the actual IP address in my pgaudit log?

In my postgresql.conf, the below is my configuration :

log_line_prefix= '%t %a %u-%d-%h'

%h and %r captures the VPN IP address, is there anyway I can capture the actual IP address, or even all of the client IP address?

edited Sep 13 '21 at 09:42

cursorrux

1,382
4
9
20

asked Sep 13 '21 at 09:18

xxestter

2

No. They are connecting through the VPN, so as far as Postgres is concerned, that is their "actual IP address". – Rob Sep 13 '21 at 09:46
The server doesn't even have that information, so it cannot log it – Laurenz Albe Sep 13 '21 at 11:52

PostgreSQL 13 capture audit logs of actual IP address

0 Answers0