\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "version": "18", "link_map": {"/zh/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY": "/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "/zh/docs/18/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT": "/docs/18/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT"}, "body_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "bc85301fff092a214274d9d6153ebe190be8d2a345cce3c2709b668302c375f6", "content_hash": "c1277b6d494698686df4ead6f747175f4292db033607168286b699732490e7ed", "source_database": "center", "source_revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8"}, "signature": "scram_client_key", "tables_zh": [], "documented": true, "description": ["\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002"], "environment": [], "manual_html": "", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "sections_zh": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728Microsoft Windows\u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "localization": {"status": "complete", "sources": [{"url": "/docs/18/libpq-connect.html", "method": "same-major semantic node", "sha256": "bae58c13a65be235aa0408ef12f8bcc7e48f2908cd71080a7dedec225a74c083", "language": "zh", "matched_nodes": ["#LIBPQ-CONNECT/div[7]/div[2]/dl[0]/dd[85]"]}, {"url": "/docs/18/libpq-envars.html", "method": "same-major semantic node", "sha256": "8423affb67ef7d4f700d7ccc8c0ef66629341568c8d72530a0c765f3d155da2f", "language": "zh", "matched_nodes": ["#LIBPQ-ENVARS/p[2]"]}, {"url": "/docs/18/libpq-pgservice.html", "method": "same-major semantic node", "sha256": "a06dfcdffbbdf6bd55987cade2d9ff1db6cbfd9f75eb80c7866e8792cd70463e", "language": "zh", "matched_nodes": ["#LIBPQ-PGSERVICE/p[5]", "#LIBPQ-PGSERVICE/p[9]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "/versions/18/facts/0/label": "Client library", "/versions/18/facts/1/label": "Manual definition", "/versions/18/facts/1/value": "Documented", "/versions/18/facts/2/label": "Source environment fallback", "/versions/18/facts/2/value": "None declared in the option table", "/versions/18/facts/3/label": "Compiled fallback expression", "/versions/18/related/0/label": "Connection service file", "/versions/18/related/1/label": "Password file", "/versions/18/related/2/label": "All libpq environment variables", "/versions/18/sections/0/title": "Default resolution and service-file precedence", "/versions/18/sections/1/title": "Environment variable evidence", "/versions/18/sections/0/paragraphs/0": "The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "/versions/18/sections/0/paragraphs/1": "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "/versions/18/sections/0/paragraphs/2": "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "652794e037dc467c8b7676554f296f2030f4711d3195c749f1ebced8c97d7e30", "canonical_center_text_hash": "c1277b6d494698686df4ead6f747175f4292db033607168286b699732490e7ed"}, "source_option": {"keyword": "scram_client_key", "declaration": "\"scram_client_key\", NULL, NULL, NULL, \"SCRAM-Client-Key\", \"D\", SCRAM_MAX_KEY_LEN * 2, offsetof(struct pg_conn, scram_client_key)", "environment": "", "source_notes": [], "compiled_default_expression": "NULL"}, "description_zh": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "comparison_data": {"keyword": "scram_client_key", "definition": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "documented": true, "environment": "", "default_evidence": [], "compiled_default_expression": "NULL"}, "comparison_hash": "1e308566ea30d0f9e825a7c929cc15cc7d44ecc3630f5cfc34ae08efeac5f1b1", "manual_language": "zh", "default_evidence": [], "description_zh_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."], "center_zh_rendered": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "19": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef\u5e93", "value": "libpq 19rc2"}, {"label": "\u624b\u518c\u5b9a\u4e49", "value": "\u624b\u518c\u5df2\u8bb0\u8f7d"}, {"label": "\u6e90\u7801\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u56de\u9000", "value": "\u9009\u9879\u8868\u4e2d\u672a\u58f0\u660e"}, {"label": "\u7f16\u8bd1\u65f6\u56de\u9000\u8868\u8fbe\u5f0f", "value": "NULL"}], "tables": [], "keyword": "scram_client_key", "related": [{"url": "/docs/19/libpq-pgservice.html", "label": "\u8fde\u63a5\u670d\u52a1\u6587\u4ef6"}, {"url": "/docs/19/libpq-pgpass.html", "label": "\u53e3\u4ee4\u6587\u4ef6"}, {"url": "/docs/19/libpq-envars.html", "label": "\u6240\u6709 libpq \u73af\u5883\u53d8\u91cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "label": "19rc2", "major": "19", "channel": "preview", "manifest": {"major": "19", "release": "19rc2", "source_url": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "revision": "cd49a2a98fed04eec7571858125796f86e63613d1985225049f2aa8b0955f256", "evidence_kind": "English manual and source declarations", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "sources": [{"url": "/docs/19/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "file": "libpq-connect.html", "label": "19rc2 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "sha256": "0a9acc6fe923f679e1c29b9c9e055af343b9f18d57000d0d2f105b792e7a8639"}, {"url": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "19rc2 libpq connection option declarations", "sha256": "8c1ead9bb7a0fbbbc752d1ed9198e99b07c834495e502549309d0765d0bbf041", "archive_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, {"url": "/docs/19/libpq-envars.html", "file": "libpq-envars.html", "label": "19rc2 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "af62a12e22e80fff7cb75a6a7760562861c414f73a4afbd5ec2e1c2f1e9c94b9"}, {"url": "/docs/19/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "19rc2 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "eb83c4af16f3d34aa873fc313fdf55560bbdf1803d195d723e6eb88c9d8dcea4"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef\u5e93", "value": "libpq 19rc2"}, {"label": "\u624b\u518c\u5b9a\u4e49", "value": "\u624b\u518c\u5df2\u8bb0\u8f7d"}, {"label": "\u6e90\u7801\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u56de\u9000", "value": "\u9009\u9879\u8868\u4e2d\u672a\u58f0\u660e"}, {"label": "\u7f16\u8bd1\u65f6\u56de\u9000\u8868\u8fbe\u5f0f", "value": "NULL"}], "sections": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728 Microsoft Windows \u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.40.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "description_zh_html": "\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.40.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "version": "20", "link_map": {"/zh/docs/devel/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY": "/docs/devel/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "/zh/docs/devel/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT": "/docs/devel/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT"}, "body_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "80c402dcc6aa9b592e5f0928a75fd19bd79647d1c53ac4a28244dda66f4a75e6", "content_hash": "2cf102fc6e32c60b5dce683adcc4bd9fb6221b139cf022061b939bdbec3360c4", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "signature": "scram_client_key", "tables_zh": [], "documented": true, "description": ["\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.40.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002"], "environment": [], "manual_html": "", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "sections_zh": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728Microsoft Windows\u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u5728 libpq \u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u4f7f\u7528 servicefile \u5173\u952e\u5b57\uff0c\u6216\u8005\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "localization": {"status": "complete", "sources": [{"url": "/docs/devel/libpq-connect.html", "method": "same-major semantic node", "sha256": "80a1ddba976c7228bb9d179e08545f0a6328ffc9b880481df17a53fdebf42bb5", "language": "zh", "matched_nodes": ["#LIBPQ-CONNECT/div[7]/div[2]/dl[0]/dd[85]"]}, {"url": "/docs/devel/libpq-envars.html", "method": "same-major semantic node", "sha256": "b4afd6d100d2be289d48e1a6f6fb9804dd0b684798b7dabf8bae7d3db074117f", "language": "zh", "matched_nodes": ["#LIBPQ-ENVARS/p[2]"]}, {"url": "/docs/devel/libpq-pgservice.html", "method": "same-major semantic node", "sha256": "acea589bbba517979fe815bd3bff32cd6d5e6323e1d5b4f395d7864338868b26", "language": "zh", "matched_nodes": ["#LIBPQ-PGSERVICE/p[5]", "#LIBPQ-PGSERVICE/p[9]"]}], "language": "zh", "original_text": {"/summary": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.40.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "/category": "Authentication", "/versions/20/description/0": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.40.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "/versions/20/facts/0/label": "Client library", "/versions/20/facts/1/label": "Manual definition", "/versions/20/facts/1/value": "Documented", "/versions/20/facts/2/label": "Source environment fallback", "/versions/20/facts/2/value": "None declared in the option table", "/versions/20/facts/3/label": "Compiled fallback expression", "/versions/20/related/0/label": "Connection service file", "/versions/20/related/1/label": "Password file", "/versions/20/related/2/label": "All libpq environment variables", "/versions/20/sections/0/title": "Default resolution and service-file precedence", "/versions/20/sections/1/title": "Environment variable evidence", "/versions/20/sections/0/paragraphs/0": "The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "/versions/20/sections/0/paragraphs/1": "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified using the servicefile key word in a libpq connection string or by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "/versions/20/sections/0/paragraphs/2": "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "05538b466d4bb97aad380f0bccf17d146a44e8e63d89523ff0eb28fe620d36a2", "canonical_center_text_hash": "2cf102fc6e32c60b5dce683adcc4bd9fb6221b139cf022061b939bdbec3360c4"}, "source_option": {"keyword": "scram_client_key", "declaration": "\"scram_client_key\", NULL, NULL, NULL, \"SCRAM-Client-Key\", \"D\", SCRAM_MAX_KEY_LEN * 2, offsetof(struct pg_conn, scram_client_key)", "environment": "", "source_notes": [], "compiled_default_expression": "NULL"}, "description_zh": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.40.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "comparison_data": {"keyword": "scram_client_key", "definition": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.40.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "documented": true, "environment": "", "default_evidence": [], "compiled_default_expression": "NULL"}, "comparison_hash": "5d93103e7835231c72302ee8843c1fdeae988ac2dc3f5bcb7287ca9ca043c2cd", "manual_language": "zh", "default_evidence": [], "description_zh_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.40.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified using the servicefile key word in a libpq connection string or by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."], "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2", "previous_source_revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918"}}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef\u5e93", "value": "libpq 18.6"}, {"label": "\u624b\u518c\u5b9a\u4e49", "value": "\u624b\u518c\u5df2\u8bb0\u8f7d"}, {"label": "\u6e90\u7801\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u56de\u9000", "value": "\u9009\u9879\u8868\u4e2d\u672a\u58f0\u660e"}, {"label": "\u7f16\u8bd1\u65f6\u56de\u9000\u8868\u8fbe\u5f0f", "value": "NULL"}], "tables": [], "keyword": "scram_client_key", "related": [{"url": "/docs/18/libpq-pgservice.html", "label": "\u8fde\u63a5\u670d\u52a1\u6587\u4ef6"}, {"url": "/docs/18/libpq-pgpass.html", "label": "\u53e3\u4ee4\u6587\u4ef6"}, {"url": "/docs/18/libpq-envars.html", "label": "\u6240\u6709 libpq \u73af\u5883\u53d8\u91cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "file": "libpq-connect.html", "label": "18.6 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "sha256": "c26a7fc3dcda6066cfe540641ae2690faf3d3c03277f30b4dfc2328ab45c212f"}, {"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "18.6 libpq connection option declarations", "sha256": "44a6e386cbfd67ebe768d6ef5493098119c2e6b4796239d53e5ed7b122b206a5", "archive_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "/docs/18/libpq-envars.html", "file": "libpq-envars.html", "label": "18.6 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "d64db73f3d48127bb984a5f775e77b7bcca2ba4bd218333cf24a45fcdd7c4363"}, {"url": "/docs/18/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "18.6 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "6035a3f0ee1d0fd80db5bf58834390b884eecd23206659bdf6f07560deea5aa7"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "anchor": "LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "libpq-connect.html", "extraction": "exact-definition", "source_hash": "1555b03a2bc480920a9c72be9683ee3ddf99e8a5c17267c0dca73c42cd50e44c", "fragment_sha256": "5ebf09f2f3bbab77f67af6dafac1a4f9a7211dac417efe347843dfed1dcdfc97", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "f8697c7c53d194fd12b58d3f9481b62687fd7c5bacf39a2c1378aa4b255610a6", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8"}, "facts_zh": [{"label": "\u5ba2\u6237\u7aef\u5e93", "value": "libpq 18.6"}, {"label": "\u624b\u518c\u5b9a\u4e49", "value": "\u624b\u518c\u5df2\u8bb0\u8f7d"}, {"label": "\u6e90\u7801\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u56de\u9000", "value": "\u9009\u9879\u8868\u4e2d\u672a\u58f0\u660e"}, {"label": "\u7f16\u8bd1\u65f6\u56de\u9000\u8868\u8fbe\u5f0f", "value": "NULL"}], "sections": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728Microsoft Windows\u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "center_zh": {"title": "scram_client_key", "locale": "zh-Hans", "source": {"key": "scram-client-key", "locale": "zh-Hans", "version": "18", "text_hash": "c1277b6d494698686df4ead6f747175f4292db033607168286b699732490e7ed", "collection": "conn", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8"}, "payload": {"facts": [{"label": "\u5ba2\u6237\u7aef\u5e93", "value": "libpq 18.6"}, {"label": "\u624b\u518c\u5b9a\u4e49", "value": "\u624b\u518c\u5df2\u8bb0\u8f7d"}, {"label": "\u6e90\u7801\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u56de\u9000", "value": "\u9009\u9879\u8868\u4e2d\u672a\u58f0\u660e"}, {"label": "\u7f16\u8bd1\u65f6\u56de\u9000\u8868\u8fbe\u5f0f", "value": "NULL"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "anchor": "LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "libpq-connect.html", "extraction": "exact-definition", "source_hash": "1555b03a2bc480920a9c72be9683ee3ddf99e8a5c17267c0dca73c42cd50e44c", "fragment_sha256": "5ebf09f2f3bbab77f67af6dafac1a4f9a7211dac417efe347843dfed1dcdfc97", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "f8697c7c53d194fd12b58d3f9481b62687fd7c5bacf39a2c1378aa4b255610a6", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8"}, "sections": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728Microsoft Windows\u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "description_zh": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "description_zh_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "version": "18", "link_map": {"/zh/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY": "/docs/18/libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "/zh/docs/18/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT": "/docs/18/postgres-fdw.html#POSTGRES-FDW-OPTIONS-CONNECTION-MANAGEMENT"}, "body_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "bc85301fff092a214274d9d6153ebe190be8d2a345cce3c2709b668302c375f6", "content_hash": "c1277b6d494698686df4ead6f747175f4292db033607168286b699732490e7ed", "source_database": "center", "source_revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8"}, "signature": "scram_client_key", "tables_zh": [], "documented": true, "description": ["\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002"], "environment": [], "manual_html": "", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-SCRAM-CLIENT-KEY", "sections_zh": [{"title": "\u9ed8\u8ba4\u503c\u89e3\u6790\u4e0e\u670d\u52a1\u6587\u4ef6\u4f18\u5148\u7ea7", "paragraphs": ["\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf\u53ef\u7528\u4e8e\u9009\u62e9\u8fde\u63a5\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\uff0c\u4f9b PQconnectdb \u3001 PQsetdbLogin \u548c PQsetdb \u5728\u8c03\u7528\u4ee3\u7801\u672a\u76f4\u63a5\u6307\u5b9a\u53c2\u6570\u503c\u65f6\u4f7f\u7528\u3002\u4f8b\u5982\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u5728\u7b80\u5355\u7684\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786c\u7f16\u7801\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002", "\u670d\u52a1\u540d\u79f0\u53ef\u4ee5\u5728\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u6216\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u4e2d\u5b9a\u4e49\u3002\u5982\u679c\u540c\u4e00\u4e2a\u670d\u52a1\u540d\u79f0\u5b58\u5728\u4e8e\u7528\u6237\u6587\u4ef6\u548c\u7cfb\u7edf\u6587\u4ef6\u4e2d\uff0c\u5219\u7528\u6237\u6587\u4ef6\u4f18\u5148\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e2a\u7528\u6237\u7684\u670d\u52a1\u6587\u4ef6\u540d\u4e3a ~/.pg_service.conf \u3002\u5728Microsoft Windows\u4e0a\uff0c\u5b83\u7684\u540d\u79f0\u4e3a %APPDATA%\\postgresql\\.pg_service.conf \uff08\u5176\u4e2d %APPDATA% \u6307\u7528\u6237\u914d\u7f6e\u6587\u4ef6\u5939\u4e2d\u7684\u5e94\u7528\u6570\u636e\u5b50\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSERVICEFILE \u6765\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002\u7cfb\u7edf\u8303\u56f4\u7684\u6587\u4ef6\u540d\u4e3a pg_service.conf \u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728 PostgreSQL \u5b89\u88c5\u7684 etc \u76ee\u5f55\u4e2d\u5bfb\u627e\uff08\u4f7f\u7528 pg_config --sysconfdir \u6765\u51c6\u786e\u8bc6\u522b\u6b64\u76ee\u5f55\uff09\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf PGSYSCONFDIR \u6765\u6307\u5b9a\u53e6\u4e00\u4e2a\u76ee\u5f55\uff0c\u4f46\u4e0d\u80fd\u6307\u5b9a\u4e0d\u540c\u7684\u6587\u4ef6\u540d\u3002", "\u4ece\u670d\u52a1\u6587\u4ef6\u4e2d\u83b7\u53d6\u7684\u8fde\u63a5\u53c2\u6570\u4f1a\u4e0e\u5176\u4ed6\u6765\u6e90\u7684\u53c2\u6570\u5408\u5e76\u3002\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u4f1a\u8986\u76d6\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf\uff0c\u800c\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u76f4\u63a5\u7ed9\u51fa\u7684\u503c\u53c8\u4f1a\u8986\u76d6\u670d\u52a1\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\u3002\u4f8b\u5982\uff0c\u4f7f\u7528\u4e0a\u8ff0\u670d\u52a1\u6587\u4ef6\u65f6\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32 service=mydb port=5434 \u5c06\u4f7f\u7528\u4e3b\u673a somehost \u3001\u7aef\u53e3 5434 \u3001\u7528\u6237 admin \uff0c\u4ee5\u53ca\u7531\u73af\u5883\u53d8\u91cf\u6216\u5185\u7f6e\u9ed8\u8ba4\u503c\u8bbe\u7f6e\u7684\u5176\u4ed6\u53c2\u6570\u3002"]}, {"title": "\u73af\u5883\u53d8\u91cf\u8bc1\u636e", "paragraphs": []}], "localization": {"status": "complete", "sources": [{"url": "/docs/18/libpq-connect.html", "method": "same-major semantic node", "sha256": "bae58c13a65be235aa0408ef12f8bcc7e48f2908cd71080a7dedec225a74c083", "language": "zh", "matched_nodes": ["#LIBPQ-CONNECT/div[7]/div[2]/dl[0]/dd[85]"]}, {"url": "/docs/18/libpq-envars.html", "method": "same-major semantic node", "sha256": "8423affb67ef7d4f700d7ccc8c0ef66629341568c8d72530a0c765f3d155da2f", "language": "zh", "matched_nodes": ["#LIBPQ-ENVARS/p[2]"]}, {"url": "/docs/18/libpq-pgservice.html", "method": "same-major semantic node", "sha256": "a06dfcdffbbdf6bd55987cade2d9ff1db6cbfd9f75eb80c7866e8792cd70463e", "language": "zh", "matched_nodes": ["#LIBPQ-PGSERVICE/p[5]", "#LIBPQ-PGSERVICE/p[9]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "/versions/18/facts/0/label": "Client library", "/versions/18/facts/1/label": "Manual definition", "/versions/18/facts/1/value": "Documented", "/versions/18/facts/2/label": "Source environment fallback", "/versions/18/facts/2/value": "None declared in the option table", "/versions/18/facts/3/label": "Compiled fallback expression", "/versions/18/related/0/label": "Connection service file", "/versions/18/related/1/label": "Password file", "/versions/18/related/2/label": "All libpq environment variables", "/versions/18/sections/0/title": "Default resolution and service-file precedence", "/versions/18/sections/1/title": "Environment variable evidence", "/versions/18/sections/0/paragraphs/0": "The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "/versions/18/sections/0/paragraphs/1": "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "/versions/18/sections/0/paragraphs/2": "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "652794e037dc467c8b7676554f296f2030f4711d3195c749f1ebced8c97d7e30", "canonical_center_text_hash": "c1277b6d494698686df4ead6f747175f4292db033607168286b699732490e7ed"}, "source_option": {"keyword": "scram_client_key", "declaration": "\"scram_client_key\", NULL, NULL, NULL, \"SCRAM-Client-Key\", \"D\", SCRAM_MAX_KEY_LEN * 2, offsetof(struct pg_conn, scram_client_key)", "environment": "", "source_notes": [], "compiled_default_expression": "NULL"}, "description_zh": "\u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1 \u7b2c F.38.1.10 \u8282 \u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002", "comparison_data": {"keyword": "scram_client_key", "definition": "The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.", "documented": true, "environment": "", "default_evidence": [], "compiled_default_expression": "NULL"}, "comparison_hash": "1e308566ea30d0f9e825a7c929cc15cc7d44ecc3630f5cfc34ae08efeac5f1b1", "manual_language": "zh", "default_evidence": [], "description_zh_html": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."], "center_zh_rendered": "\u8fde\u63a5\u53c2\u6570 scram_client_key\u3002
\n \u4ee5 Base64 \u7f16\u7801\u7684 SCRAM \u5ba2\u6237\u7aef\u5bc6\u94a5\u3002\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u6216\u7c7b\u4f3c\u4e2d\u95f4\u4ef6\u53ef\u4ee5\u5229\u7528\u5b83\u542f\u7528\u900f\u4f20\u5f0f SCRAM \u8ba4\u8bc1\u3002\u4e00\u4e2a\u5b9e\u73b0\u793a\u4f8b\u89c1\u7b2c\u00a0F.38.1.10\u00a0\u8282\u3002\u7528\u6237\u6216\u5ba2\u6237\u7aef\u5e94\u7528\u4e0d\u5e94\u76f4\u63a5\u6307\u5b9a\u5b83\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,8 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+ \"compiled_default_expression\": \"NULL\",\n+ \"default_evidence\": [],\n+ \"definition\": \"The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for one such implementation. It is not meant to be specified directly by users or client applications.\",\n+ \"documented\": true,\n+ \"environment\": \"\",\n+ \"keyword\": \"scram_client_key\"\n+}"}}