Setting application_name on Postgres/SQLAlchemy

by

the answer to this is a combination of:

http://initd.org/psycopg/docs/module.html#psycopg2.connect

Any other connection parameter supported by the client library/server can be passed either in the connection string or as keywords. The PostgreSQL documentation contains the complete list of the supported parameters. Also note that the same parameters can be passed to the client library using environment variables.

where the variable we need is:

http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-APPLICATION-NAME

The application_name can be any string of less than NAMEDATALEN characters (64 characters in a standard build). It is typically set by an application upon connection to the server. The name will be displayed in the pg_stat_activity view and included in CSV log entries. It can also be included in regular log entries via the log_line_prefix parameter. Only printable ASCII characters may be used in the application_name value. Other characters will be replaced with question marks (?).

combined with :

http://docs.sqlalchemy.org/en/rel_0_8/core/engines.html#custom-dbapi-args

String-based arguments can be passed directly from the URL string as query arguments: (example…) create_engine() also takes an argument connect_args which is an additional dictionary that will be passed to connect(). This can be used when arguments of a type other than string are required, and SQLAlchemy’s database connector has no type conversion logic present for that parameter

from that we get:

e = create_engine("postgresql://scott:tiger@localhost/test?application_name=myapp")

or:

e = create_engine("postgresql://scott:tiger@localhost/test", 
              connect_args={"application_name":"myapp"})

More Related Contents:

  1. SQLAlchemy, Psycopg2 and Postgresql COPY
  2. SQLAlchemy support of Postgres Schemas
  3. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  4. Can’t connect the postgreSQL with psycopg2
  5. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  6. How to set connection timeout in SQLAlchemy
  7. psycopg2: insert multiple rows with one query
  8. How do you find the row count for all your tables in Postgres
  9. Passing table name as a parameter in psycopg2
  10. invalid byte sequence for encoding “UTF8”
  11. How to make “case-insensitive” query in Postgresql?
  12. Rownum in postgresql
  13. Postgresql: Scripting psql execution with password
  14. dynamic sql query in postgres
  15. Cannot create a database table named ‘user’ in PostgreSQL
  16. Is there a timeout for idle PostgreSQL connections?
  17. How to make connection to Postgres via Node.js
  18. Buffers (Circle) in PostGIS
  19. docker postgres pgadmin local connection
  20. Does a Postgres UNIQUE constraint imply an index?
  21. SELECT raises exception in PL/pgSQL function
  22. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  23. Changing primary key int type to serial
  24. Return SETOF rows from PostgreSQL function
  25. Dynamically generate columns for crosstab in PostgreSQL
  26. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  27. Python/postgres/psycopg2: getting ID of row just inserted
  28. now() default values are all showing same timestamp
  29. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment