Get the default configuration file user_clusters for PostgreSQL, optimized for Debian GNU/Linux 10 (buster). This example configuration ensures optimal compatibility and performance for PostgreSQL, making it easy to set up and adjust to meet your needs.
Find and download the configuration file here: /etc/postgresql-common/user_clusters.
For more configurations and setup guides, visit our related files section to further customize your system.
# This file maps users against the database clusters to which they
# will connect by default. Any user may create ~/.postgresqlrc which
# will supersede the defaults stored here. If a database is
# specified, that will be the one connected to by client tools if none
# is specified on the command line. If the database specified here is
# "*", this is interpreted as the database whose name is the same as
# the user's login. (Setting the database to "*" will provide the
# current default upstream behaviour for command line tools.)
#
# When pg_wrapper scans this file, the first matching line is used.
# It is a good idea to provide a default explicitly, with a final line
# where both user and group are set to "*". If there is no default,
# the implicit default is to connect to the cluster listening on
# port 5432 and to the database matching the user's login name.
#
# In the context of this file, user and group refer to the Unix login
# or group, not to PostgreSQL users and groups.
#
# Please see user_clusters(5) and postgresqlrc(5) for more information.
#
# USER GROUP VERSION CLUSTER DATABASE
Download the raw file with wget or curl
wget -O user_clusters.example https://exampleconfig.com/static/raw/postgresql/debian10/etc/postgresql-common/user_clusters
curl https://exampleconfig.com/static/raw/postgresql/debian10/etc/postgresql-common/user_clusters > user_clusters.example
Other config files you might find useful