Get the default configuration file user_clusters for PostgreSQL, optimized for Debian GNU/Linux 8 (jessie). 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 whose postmaster
# is 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/debian8/etc/postgresql-common/user_clusters
curl https://exampleconfig.com/static/raw/postgresql/debian8/etc/postgresql-common/user_clusters > user_clusters.example
Other config files you might find useful