#postgresql #env-var #service-configuration #sql #variables #client-config #connection

bin+lib pg-client-config

Support for Postgres service configuration files and environment variables

3 releases

0.1.2 Aug 26, 2023
0.1.1 Apr 14, 2023
0.1.0 Apr 6, 2023

#797 in Database interfaces

Download history 21/week @ 2023-12-16 10/week @ 2023-12-23 10/week @ 2023-12-30 19/week @ 2024-01-06 45/week @ 2024-01-13 81/week @ 2024-01-20 110/week @ 2024-01-27 97/week @ 2024-02-03 66/week @ 2024-02-10 136/week @ 2024-02-17 76/week @ 2024-02-24 104/week @ 2024-03-02 75/week @ 2024-03-09 50/week @ 2024-03-16 49/week @ 2024-03-23 96/week @ 2024-03-30

285 downloads per month

MIT/Apache

22KB
407 lines

Tokio-postgres support for service file and environment variables.

Connection string parsing with support for service file and a subset of psql environment variables.

Note: tokio-postgres 0.7.9 introduced a change preventing PGUSER and service configuration to set connection user. The release of tokio-postgres 0.7.10 fix this issue.

Environment variables

  • PGSERVICE - Name of the postgres service used for connection params.
  • PGSYSCONFDIR - Location of the service files.
  • PGSERVICEFILE - Name of the service file.
  • PGHOST - behaves the same as the host connection parameter.
  • PGPORT - behaves the same as the port connection parameter.
  • PGDATABASE - behaves the same as the dbname connection parameter.
  • PGUSER - behaves the same as the user connection parameter.
  • PGOPTIONS - behaves the same as the options parameter.
  • PGAPPNAME - behaves the same as the application_name connection parameter.
  • PGCONNECT_TIMEOUT - behaves the same as the connect_timeout connection parameter.
  • PGPASSFILE - Specifies the name of the file used to store password.

Passfile support

Passfile is actually supported only on linux platform

Example

use pg_client_config::load_config;

let config = load_config(Some("service=myservice")).unwrap();
println!("{config:#?}");

Precedence rules

  • Environment variables are always evaluated with the least precedence.
  • Parameters passed in the connection string always take precedence.

See also

Dependencies

~9–20MB
~341K SLoC