How to setup postgres application_name logging

Question

I'm not much familiar with postgresql. I like to setup postgres application_name feature to log database changes (update/delete) in a history table.

I tried to find any help from online but couldn't find any article with basic steps. Could someone give me any kind of help.

Thanks alot!

Pavel Stehule · Accepted Answer · 2013-12-27 05:09:20Z

7

Using a application_name is great idea. It has a two steps:

logging application name - set log_line_prefix in postgresql.conf
```
log_line_prefix = '%a %u %d' 
```

use application name - use SQL configuration statement or variable in connection string or environment variable

SET application_name = 'myapp';

or

postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp

or

PGAPPNAME=splunk psql -c "select application_name from pg_stat_activity where pid = pg_backend_pid();" postgres

some documentation

answered Dec 27, 2013 at 5:09

Pavel Stehule

46.7k6 gold badges104 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1