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 terminates 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
              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)