Wiki / 配置参数

This parameter enables per-database user names. It is off by default. This parameter can only be set in the postgresql.conf file or on the server command line. If this is on, you should create users as username@dbname. When username is passed by a connecting client, @ and the database name are appended to the user name and that database-specific user name is looked up by the server. Note that when you create users with names containing @ within the SQL environment, you will need to quote the user name. With this parameter enabled, you can still create ordinary global users. Simply append @ when specifying the user name in the client, e.g., joe@. The @ will be stripped off before the user name is looked up by the server. db_user_namespace causes the client's and server's user name representation to differ. Authentication checks are always done with the server's user name so authentication methods must be configured for the server's user name, not the client's. Because md5 uses the user name as salt on both the client and server, md5 cannot be used with db_user_namespace. Note This feature is intended as a temporary measure until a complete solution is found. At that time, this option will be removed.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

off

category

Connections and Authentication / Authentication

context

sighup

documented

true

enumvals

未知

extra desc

未知

lang

en

max val

未知

metadata version

16

min val

未知

name

db_user_namespace

short desc

Enables per-database user names.

source

pg-settings-source-snapshot

unit

未知

vartype

bool