\u8fde\u63a5\u53c2\u6570 servicefile\u3002
\n \u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1\u7b2c\u00a032.16\u00a0\u8282\uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf\uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f\n %APPDATA%\\postgresql\\.pg_service.conf\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1 \u7b2c 32.16 \u8282 \uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf \uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f %APPDATA%\\postgresql\\.pg_service.conf \u3002", "version": "20", "link_map": {"/zh/docs/devel/libpq-pgservice.html": "/docs/devel/libpq-pgservice.html", "/zh/docs/devel/libpq-connect.html#LIBPQ-CONNECT-SERVICEFILE": "/docs/devel/libpq-connect.html#LIBPQ-CONNECT-SERVICEFILE"}, "body_html": "\u8fde\u63a5\u53c2\u6570 servicefile\u3002
\n \u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1\u7b2c\u00a032.16\u00a0\u8282\uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf\uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f\n %APPDATA%\\postgresql\\.pg_service.conf\u3002\n
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "efd15a8ac14bdbbe2a792e27fb78ebdd1e58089f2638de2435b4df7db7609de9", "content_hash": "42fc3fd70a9ca68dd568976452b9666bf9a200d20af33b27a6ba0a90459fc0e6", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "signature": "servicefile", "tables_zh": [{"key": "environment", "rows": [{"name": {"url": "/docs/devel/libpq-envars.html", "text": "PGSERVICEFILE"}, "description": "PGSERVICEFILE \u7684\u884c\u4e3a\u4e0e servicefile \u8fde\u63a5\u53c2\u6570\u76f8\u540c\u3002"}], "title": "\u73af\u5883\u53d8\u91cf\u56de\u9000", "columns": [{"key": "name", "label": "\u53d8\u91cf"}, {"key": "description", "label": "\u624b\u518c\u8bb0\u8f7d\u7684\u884c\u4e3a"}]}], "documented": true, "description": ["\u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1 \u7b2c 32.16 \u8282 \uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf \uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f %APPDATA%\\postgresql\\.pg_service.conf \u3002"], "environment": [{"name": "PGSERVICEFILE", "source_url": "/docs/devel/libpq-envars.html", "description": "PGSERVICEFILE behaves the same as the servicefile connection parameter."}], "manual_html": "", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-SERVICEFILE", "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": ["PGSERVICEFILE \u7684\u884c\u4e3a\u4e0e servicefile \u8fde\u63a5\u53c2\u6570\u76f8\u540c\u3002"]}], "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[91]"]}, {"url": "/docs/devel/libpq-envars.html", "method": "same-major semantic node", "sha256": "b4afd6d100d2be289d48e1a6f6fb9804dd0b684798b7dabf8bae7d3db074117f", "language": "zh", "matched_nodes": ["#LIBPQ-ENVARS/div[3]/ul[0]/li[11]", "#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": "This option specifies the name of the per-user connection service file (see Section 32.16 ). Defaults to ~/.pg_service.conf , or %APPDATA%\\postgresql\\.pg_service.conf on Microsoft Windows.", "/category": "Session and protocol", "/versions/20/description/0": "This option specifies the name of the per-user connection service file (see Section 32.16 ). Defaults to ~/.pg_service.conf , or %APPDATA%\\postgresql\\.pg_service.conf on Microsoft Windows.", "/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/3/label": "Compiled fallback expression", "/versions/20/tables/0/title": "Environment fallback", "/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.", "/versions/20/sections/1/paragraphs/0": "PGSERVICEFILE behaves the same as the servicefile connection parameter.", "/versions/20/tables/0/columns/0/label": "Variable", "/versions/20/tables/0/columns/1/label": "Documented behavior", "/versions/20/tables/0/rows/0/description": "PGSERVICEFILE behaves the same as the servicefile connection parameter."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "23feec342fb1baf379483892b59b8e0f5ad28a9c073f014cae3a13383e739b8d", "canonical_center_text_hash": "42fc3fd70a9ca68dd568976452b9666bf9a200d20af33b27a6ba0a90459fc0e6"}, "source_option": {"keyword": "servicefile", "declaration": "\"servicefile\", \"PGSERVICEFILE\", NULL, NULL, \"Database-Service-File\", \"\", 64, offsetof(struct pg_conn, pgservicefile)", "environment": "PGSERVICEFILE", "source_notes": [], "compiled_default_expression": "NULL"}, "description_zh": "\u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1 \u7b2c 32.16 \u8282 \uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf \uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f %APPDATA%\\postgresql\\.pg_service.conf \u3002", "comparison_data": {"keyword": "servicefile", "definition": "This option specifies the name of the per-user connection service file (see Section 32.16 ). Defaults to ~/.pg_service.conf , or %APPDATA%\\postgresql\\.pg_service.conf on Microsoft Windows.", "documented": true, "environment": "PGSERVICEFILE", "default_evidence": [], "compiled_default_expression": "NULL"}, "comparison_hash": "63a45d2dde9d63c6a8a756a5317f197b353ab0f37343ba18c5b7ffb640afddc6", "manual_language": "zh", "default_evidence": [], "description_zh_html": "\u8fde\u63a5\u53c2\u6570 servicefile\u3002
\n \u8be5\u9009\u9879\u6307\u5b9a\u6bcf\u4e2a\u7528\u6237\u7684\u8fde\u63a5\u670d\u52a1\u6587\u4ef6\u540d\u79f0\uff08\u53c2\u89c1\u7b2c\u00a032.16\u00a0\u8282\uff09\u3002\u9ed8\u8ba4\u503c\u662f ~/.pg_service.conf\uff0c\u5728 Microsoft Windows \u4e0a\u5219\u662f\n %APPDATA%\\postgresql\\.pg_service.conf\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": null, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}