PostgreSQL user_clusters configuration example for Debian GNU/Linux 9 (stretch)

Get the default configuration file user_clusters for PostgreSQL, optimized for Debian GNU/Linux 9 (stretch). 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


    
  

Config Details

Location
/etc/postgresql-common/user_clusters
Operating system
Debian GNU/Linux 9 (stretch)
Length
22 lines
MD5 checksum
d2959e6ae6847342be07146ce06af33b

Usage

Download the raw file with wget or curl

Wget

wget -O user_clusters.example https://exampleconfig.com/static/raw/postgresql/debian9/etc/postgresql-common/user_clusters

cURL

curl https://exampleconfig.com/static/raw/postgresql/debian9/etc/postgresql-common/user_clusters > user_clusters.example