USER_CLUSTERS(5) Debian PostgreSQL infrastructure USER_CLUSTERS(5)
NAME
user_clusters - File linking users to PostgreSQL clusters
DESCRIPTION
The file /etc/postgresql-common/user_clusters maps users against the
database clusters to which they will connect by default. However, every
user can override these settings in ~/.postgresqlrc.
When scanning this file, the first matching line will be 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 clus-
ter listening on port 5432 and to the database matching the user's login
name.
FORMAT
Comments are introduced by the character #. Comments may follow data on
a line; the first comment character terminates the data. Leading white-
space and blank lines are ignored.
Each uncommented, non-blank line must describe a user, group or the de-
fault (where both user and group are set to *).
Fields must be given in the following order, separated by white space:
USER The login id of the Unix user to whom this line applies. The
wildcard character * means any user.
GROUP The group name of the Unix group to which this line applies. The
wildcard character * means any group.
VERSION
The major PostgreSQL version of the cluster to connect to.
CLUSTER
The name of a cluster to connect to. A remote cluster is speci-
fied with host:port. If port is empty, it defaults to 5432.
DATABASE
Within the cluster, the database to which the user will connect
by default if he does not specify a database on the command line.
If this is *, the default database will be the one named by the
user's login id.
NOTES
Since the first matching line is used, the default line must come last.
SEE ALSO
pg_wrapper(1), postgresqlrc(5)
Debian Feburary 2005 USER_CLUSTERS(5)
Generated by dwww version 1.16 on Tue Dec 16 07:31:15 CET 2025.