Postgresql database

Postgres database configuration file has a Postgres connection string.

You can see the parameters available at https://www.postgresql.org/docs/14/libpq-connect.html#LIBPQ-CONNSTRING.

Most of the time, though, you may be using only a few of those options, as in:
 user=myuser password=mypwd dbname=mydb

The above file has parameters "user" (Postgres user), "password" (the password for Postgres user), "dbname" (the Postgres database name). If you use peer-authenticated (i.e. passwordless) login, then omit "password" - this is when the Postgres user name is the same as your Operating System user name and where local unix domain socket is used for authentication.


Copyright (c) 2019-2025 Gliim LLC. All contents on this web site is "AS IS" without warranties or guarantees of any kind.