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!

score 7 · Accepted Answer · answered Dec 27 '13 at 05:09

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

1 Answers1