How to send application_name to RPostgreSQL connection

Question

I know that PostgreSQL database allows to keep track of application name for each connection and it looks like application_name variable should work with RPostgreSQL, but how exactly should I do this? Adding variable application_name = "test" to dbConnect doesn't work.

application_name does not appear to be a parameter that you can set when connecting to a database: postgresql.org/docs/9.4/static/… — hadley
– hadley, Commented Feb 18, 2015 at 3:53
@hadley, 'application_name' appears in the page that you linked, it is definitely a parameter that you can set in PostgreSQL, as you can see here — ncocacola
– ncocacola, Commented Feb 26, 2015 at 16:30
@ncocacola ok must've missed that. You can set in dbConnect() in github.com/rstats-db/RPostgres — hadley
– hadley, Commented Feb 26, 2015 at 19:30
Great, thanks. @hadley just to check with you, are you planning to replace RPostgreSQL by RPostgres in dplyr? — kismsu
– kismsu, Commented Feb 27, 2015 at 8:19

ncocacola · Accepted Answer · 2015-02-05 18:20:21Z

3

I'm not sure you can pass application_name='test' as an argument to dbConnect in RPostgreSQL (there is an optional options argument, but I couldn't figure out what kind of data it expects).

An alternative would be to run the following SQL query immediately after opening the connection:

SET application_name='test'

and it should work until you close the connection.

answered Feb 5, 2015 at 18:20

ncocacola

4853 silver badges9 bronze badges

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

Comments

fxi · Accepted Answer · 2020-09-29 16:07:58Z

It's not well documented but something like this works:

drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, 
           dbname  = "<my_db>",
           host = "<my_host>", 
           [...], 
           options = "-c application_name=my_app_name"
       )

It works with dbPool too (package 'pool'):

pool <- dbPool(
            drv = dbDriver("PostgreSQL"),
            dbname = "<my_db>",
            host = "<my_host>",
            [...]
            minSize = 0,
            maxSize = 3,
            options = "-c application_name=my_app_name"
        )

Check with pg_stat_activity

mydb=> SELECT state, usename, application_name FROM pg_stat_activity WHERE datname = 'mydb';
 state  | usename  | application_name
--------+----------+------------------
 active | postgres | psql
 idle   | myuser    | my_app_name

Collectives™ on Stack Overflow

How to send application_name to RPostgreSQL connection

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related