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.14 on Fri Jan 24 06:02:52 CET 2025.