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

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

#884 in Database interfaces

Download history 48/week @ 2024-01-14 81/week @ 2024-01-21 123/week @ 2024-01-28 85/week @ 2024-02-04 63/week @ 2024-02-11 136/week @ 2024-02-18 78/week @ 2024-02-25 110/week @ 2024-03-03 67/week @ 2024-03-10 52/week @ 2024-03-17 48/week @ 2024-03-24 112/week @ 2024-03-31 61/week @ 2024-04-07 49/week @ 2024-04-14 71/week @ 2024-04-21 56/week @ 2024-04-28

241 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–19MB
~331K SLoC