dwww Home | Manual pages | Find package

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  lo-
       gin 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 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.15 on Sun Jun 16 21:31:56 CEST 2024.