USER_CLUSTERS(5)         (Feburary 2005)         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 cluster 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 termi-
          nates the data. Leading whitespace and blank lines are
          ignored.

          Each uncommented, non-blank line must describe a user, group
          or the default (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 specified with host:port. If port is empty, it
               defaults to 5432.

          DATABASE

     Page 1                       Debian             (printed 5/26/22)

     USER_CLUSTERS(5)         (Feburary 2005)         USER_CLUSTERS(5)

               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)

     Page 2                       Debian             (printed 5/26/22)