{"id":40293,"date":"2023-03-21T11:05:06","date_gmt":"2023-05-26T02:30:57","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/"},"modified":"2024-04-29T19:55:23","modified_gmt":"2024-04-29T11:55:23","slug":"%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/","title":{"rendered":"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u5f15\u53d1\u6211\u5199\u8fd9\u7bc7\u6587\u7ae0\u7684\u5951\u673a\u662f\u8fd9\u91cc\u7684\u5fae\u8f6f\u5b98\u65b9\u9875\u9762\u3002<\/p>\n<p>\u5728 Azure \u7528\u4e8e PostgreSQL \u7684\u6570\u636e\u5e93\u4e2d\uff0c\u4f7f\u7528 Spring Data JDBC\u3002<\/p>\n<p>\u8fd9\u4e2a\u9875\u9762\u4e0a\u5173\u4e8e PostgreSQL \u8ba4\u8bc1\u548c Azure AD \u8ba4\u8bc1\u7684\u6784\u5efa\u65b9\u6cd5\u6df7\u5408\u5728\u4e00\u8d77\uff0c\u975e\u5e38\u96be\u4ee5\u7406\u89e3\u3002\u800c\u4e14\u65e0\u8bba\u662f\u54ea\u79cd\u60c5\u51b5\uff0c\u6309\u7167\u9875\u9762\u4e0a\u7684\u8bf4\u660e\u5b9e\u65bd\u4ecd\u7136\u4f1a\u51fa\u73b0\u95ee\u9898\u3002\u5728 GitHub \u4e0a\u516c\u5f00\u7684\u793a\u4f8b\u7a0b\u5e8f\u4e5f\u65e0\u6cd5\u8fd0\u884c\u3002\u867d\u7136\u6211\u6253\u7b97\u63d0\u4ea4 Pull Request \u5e76\u8010\u5fc3\u5730\u8fdb\u884c\u4fee\u590d\uff0c\u4f46\u6211\u4e0d\u77e5\u9053\u4f55\u65f6\u624d\u80fd\u5f97\u5230\u53cd\u9988\u3002\u56e0\u6b64\uff0c\u6211\u5c06\u57282023\/8\u4e4b\u524d\u786e\u4fdd\u8bb0\u4e0b\u786e\u5207\u53ef\u884c\u7684\u64cd\u4f5c\u65b9\u6cd5\u3002<\/p>\n<p>\u4ee5\u4e0b\u7684\u8bf4\u660e\u662f\u4e2a\u4eba\u6839\u636eMicrosoft\u5b98\u65b9\u7f51\u9875\u8865\u5145\u7684\u5185\u5bb9\u3002<\/p>\n<h1>\u73af\u5883<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">openjdk 17.0.8 2023-07-18 LTS<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Apache Maven 3.9.4<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">pgAdmin 4<\/ul>\n<p>\u5728Mac\u73af\u5883\u4e0b\u5df2\u7ecf\u786e\u8ba4\u8fc7\u4e86\u3002\u867d\u7136\u5728Windows\u73af\u5883\u4e0b\u6ca1\u6709\u786e\u8ba4\u8fc7\uff0c\u4f46\u5e94\u8be5\u6ca1\u6709\u7279\u522b\u9700\u8981\u66f4\u6539\u7684\u5730\u65b9\u3002<\/p>\n<p>\u5982\u679c\u60a8\u5728\u8bbe\u7f6e\u76f8\u540c\u7684\u73af\u5883\u65f6\u4e0d\u60f3\u5728\u672c\u5730\u5b89\u88c5Java\u73af\u5883\u548c\u7248\u672c\u7ba1\u7406\uff0c\u6211\u5efa\u8bae\u60a8\u4f7f\u7528VSCode\u7684Remote Container\uff08DevContainer\uff09\u529f\u80fd\u3002\u5982\u679c\u60a8\u9009\u62e9\u4f7f\u7528\u5b83\uff0c\u8bf7\u4f7f\u7528\u4ee5\u4e0b\u7684devcontainer.json\u6587\u4ef6\u3002<\/p>\n<p>\u5982\u679c\u60a8\u5728\u73af\u5883\u4e2d\u4e0d\u9700\u8981 Azure CLI\uff0c\u8bf7\u5220\u9664\u4e0b\u4e00\u884c\u3002\u4f46\u662f\uff0c\u5982\u679c\u8981\u6d4b\u8bd5Azure AD\u8eab\u4efd\u9a8c\u8bc1\uff08\u4e0d\u4f7f\u7528\u5bc6\u7801\uff09\uff0c\u4f7f\u7528Azure CLI\u4f1a\u66f4\u65b9\u4fbf\u3002<\/p>\n<blockquote><p>&#8220;ghcr.io\/devcontainers\/features\/azure-cli:1&#8221;: {}<br \/>\n&#8220;ghcr.io\/devcontainers\/features\/azure-cli:1&#8243;\uff1a{}<\/p><\/blockquote>\n<pre class=\"post-pre\"><code><span class=\"err\">\/\/<\/span> <span class=\"err\">For<\/span> <span class=\"err\">format<\/span> <span class=\"err\">details,<\/span> <span class=\"err\">see<\/span> <span class=\"err\">https:\/\/aka.ms\/devcontainer.json.<\/span> <span class=\"err\">For<\/span> <span class=\"err\">config<\/span> <span class=\"err\">options,<\/span> <span class=\"err\">see<\/span> <span class=\"err\">the<\/span>\r\n<span class=\"err\">\/\/<\/span> <span class=\"err\">README<\/span> <span class=\"err\">at:<\/span> <span class=\"err\">https:\/\/github.com\/devcontainers\/templates\/tree\/main\/src\/java<\/span>\r\n<span class=\"p\">{<\/span>\r\n\t<span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"Java\"<\/span><span class=\"p\">,<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"err\">Or<\/span> <span class=\"err\">use<\/span> <span class=\"err\">a<\/span> <span class=\"err\">Dockerfile<\/span> <span class=\"err\">or<\/span> <span class=\"err\">Docker<\/span> <span class=\"err\">Compose<\/span> <span class=\"err\">file.<\/span> <span class=\"err\">More<\/span> <span class=\"err\">info:<\/span> <span class=\"err\">https:\/\/containers.dev\/guide\/dockerfile<\/span>\r\n\t<span class=\"nl\">\"image\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"mcr.microsoft.com\/devcontainers\/java:1-17-bullseye\"<\/span><span class=\"p\">,<\/span>\r\n\t<span class=\"nl\">\"features\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n\t\t<span class=\"nl\">\"ghcr.io\/devcontainers\/features\/java:1\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n\t\t\t<span class=\"nl\">\"version\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"none\"<\/span><span class=\"p\">,<\/span>\r\n\t\t\t<span class=\"nl\">\"installMaven\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"true\"<\/span><span class=\"p\">,<\/span>\r\n\t\t\t<span class=\"nl\">\"installGradle\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"false\"<\/span>\r\n\t\t<span class=\"p\">},<\/span>\r\n\t\t<span class=\"nl\">\"ghcr.io\/devcontainers\/features\/azure-cli:1\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{}<\/span>\r\n\t<span class=\"p\">},<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"err\">Use<\/span> <span class=\"err\">'forwardPorts'<\/span> <span class=\"err\">to<\/span> <span class=\"err\">make<\/span> <span class=\"err\">a<\/span> <span class=\"err\">list<\/span> <span class=\"err\">of<\/span> <span class=\"err\">ports<\/span> <span class=\"err\">inside<\/span> <span class=\"err\">the<\/span> <span class=\"err\">container<\/span> <span class=\"err\">available<\/span> <span class=\"err\">locally.<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"nl\">\"forwardPorts\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[],<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"err\">Use<\/span> <span class=\"err\">'postCreateCommand'<\/span> <span class=\"err\">to<\/span> <span class=\"err\">run<\/span> <span class=\"err\">commands<\/span> <span class=\"err\">after<\/span> <span class=\"err\">the<\/span> <span class=\"err\">container<\/span> <span class=\"err\">is<\/span> <span class=\"err\">created.<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"nl\">\"postCreateCommand\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"java -version\"<\/span><span class=\"p\">,<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"err\">Configure<\/span> <span class=\"err\">tool-specific<\/span> <span class=\"err\">properties.<\/span>\r\n\t<span class=\"nl\">\"customizations\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n\t\t<span class=\"nl\">\"vscode\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n\t\t\t<span class=\"nl\">\"extensions\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n\t\t\t\t<span class=\"s2\">\"vscjava.vscode-java-pack\"<\/span><span class=\"p\">,<\/span>\r\n\t\t\t\t<span class=\"s2\">\"vmware.vscode-boot-dev-pack\"<\/span><span class=\"p\">,<\/span>\r\n\t\t\t\t<span class=\"s2\">\"pkief.material-icon-theme\"<\/span>\r\n\t\t\t<span class=\"p\">]<\/span>\r\n\t\t<span class=\"p\">}<\/span>\r\n\t<span class=\"p\">}<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"err\">Uncomment<\/span> <span class=\"err\">to<\/span> <span class=\"err\">connect<\/span> <span class=\"err\">as<\/span> <span class=\"err\">root<\/span> <span class=\"err\">instead.<\/span> <span class=\"err\">More<\/span> <span class=\"err\">info:<\/span> <span class=\"err\">https:\/\/aka.ms\/dev-containers-non-root.<\/span>\r\n\t<span class=\"err\">\/\/<\/span> <span class=\"nl\">\"remoteUser\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"root\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h1>\u521b\u5efa Azure \u6570\u636e\u5e93 for PostgreSQL<\/h1>\n<p>\u5728Azure\u6570\u636e\u5e93\u4e2d\uff0c\u53ef\u4ee5\u9009\u62e9Single Server\u548cFlexible Server\u4e24\u79cd\u7c7b\u578b\u7684PostgreSQL\u3002\u52a1\u5fc5\u9009\u62e9Flexible Server\u3002Single Server\u8ba1\u5212\u57282025\u5e743\u670828\u65e5\u505c\u7528\u3002\u8bf7\u67e5\u9605\u6b64\u5904\u4ee5\u4e86\u89e3\u66f4\u591a\u8be6\u7ec6\u4fe1\u606f\u3002<\/p>\n<h2>\u8eab\u4efd\u9a8c\u8bc1\u7684\u7c7b\u578b de<\/h2>\n<p>\u5728Azure\u6570\u636e\u5e93\u4e2d\u7684PostgreSQL\uff0c\u60a8\u53ef\u4ee5\u5728\u521b\u5efa\u65f6\u9009\u62e9\u4e09\u79cd\u4e0d\u540c\u7684\u8ba4\u8bc1\u7c7b\u578b\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL \u306e\u8a8d\u8a3c\u306e\u307f<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Azure Active Directory \u8a8d\u8a3c\u306e\u307f<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">PostgreSQL \u3068 Azure Active Directory \u306e\u8a8d\u8a3c<\/ul>\n<p>\u8fd9\u6b21\u6211\u4eec\u9009\u62e9\u4f7f\u7528\u6700\u65b0\u7248\u672c\u7684PostgreSQL\u548cAzure Active Directory\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u3002\u4e3a\u4e86\u8bf4\u660e\u4f7f\u7528Spring Boot\u5982\u4f55\u8fdb\u884c\u8bbe\u7f6e\uff0c\u5728\u6bcf\u4e2a\u8eab\u4efd\u9a8c\u8bc1\u65b9\u6848\u4e2d\uff0c\u8bf7\u5148\u8fdb\u884cAzure AD\u7ba1\u7406\u5458\u7684\u914d\u7f6e\u5e76\u9009\u62e9\u60a8\u81ea\u5df1\u3002\uff08\u8bf7\u6ce8\u610f\uff0c\u8eab\u4efd\u9a8c\u8bc1\u7c7b\u578b\u5728\u521b\u5efa\u540e\u53ef\u4ee5\u66f4\u6539\uff09<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/18-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u5728\u4e0a\u56fe\u7684\u5c4f\u5e55\u622a\u56fe\u4e2d\uff0cAzure AD\u7ba1\u7406\u5458\u7684\u8bbe\u7f6e\u672a\u88ab\u9009\u62e9\uff0c\u4f46\u5b9e\u9645\u4e0a\u8bf7\u786e\u4fdd\u9009\u62e9\u81ea\u5df1\u3002<\/p>\n<h2>\u8bbe\u7f6eAzure\u6570\u636e\u5e93\u7684PostgreSQL\u9632\u706b\u5899<\/h2>\n<p>Azure Database for PostgreSQL\u6709\u9632\u706b\u5899\u529f\u80fd\uff0c\u5fc5\u987b\u660e\u786e\u5141\u8bb8IP\u5730\u5740\u624d\u80fd\u8bbf\u95ee\u3002\u4e3a\u4e86\u4ece\u672c\u5730\u8fd0\u884c\u7684Spring Boot\u8bbf\u95eeAzure Database for PostgreSQL\uff0c\u9700\u8981\u5c06\u672c\u5730\u8ba1\u7b97\u673a\u7684\u5168\u5c40IP\u5730\u5740\u6ce8\u518c\u5230\u9632\u706b\u5899\u4e0a\u3002<\/p>\n<p>\u5728Azure Portal\u4e2d\u6253\u5f00Azure Database for PostgreSQL\uff0c\u5e76\u9009\u62e9\u5de6\u4fa7\u83dc\u5355\u4e2d\u7684\u7f51\u7edc\u9009\u9879\u3002\u5728\u53f3\u4fa7\u5c4f\u5e55\u7684\u5e95\u90e8\u627e\u5230\u201c\u6dfb\u52a0\u5f53\u524d\u5ba2\u6237\u7aefIP\u5730\u5740\u201d\u7684\u9009\u9879\u5e76\u70b9\u51fb\uff0c\u7136\u540e\u70b9\u51fb\u5c4f\u5e55\u9876\u90e8\u7684\u4fdd\u5b58\u56fe\u6807\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/23-0.png\" alt=\"image.png\" \/><\/div>\n<h2>\u521b\u5efa\u6570\u636e\u5e93<\/h2>\n<p>\u6211\u4f1a\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u4f5c\u4e3a\u8fd9\u6b21\u7684\u8fde\u63a5\u3002\u4eceAzure\u95e8\u6237\u521b\u5efa\u6570\u636e\u5e93\u662f\u6700\u7b80\u5355\u7684\u3002\u9009\u62e9\u5de6\u4fa7\u83dc\u5355\u7684\u6570\u636e\u5e93\uff0c\u7136\u540e\u70b9\u51fb\u53f3\u4fa7\u5c4f\u5e55\u9876\u90e8\u7684\u6dfb\u52a0\u6309\u94ae\u6765\u521b\u5efa\u6570\u636e\u5e93\u3002\u6211\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3atestdb\u7684\u6570\u636e\u5e93\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/26-0.png\" alt=\"image.png\" \/><\/div>\n<h1>\u4f7f\u7528Spring Boot\u4ecePostgreSQL\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u8bbf\u95ee<\/h1>\n<p>\u9996\u5148\u662f\u6700\u57fa\u672c\u7684PostgreSQL\u8ba4\u8bc1\u3002\u8fd9\u662f\u5fae\u8f6f\u5b98\u65b9\u9875\u9762\u4e2d\u4f5c\u4e3a\u5bc6\u7801\uff08\u8ba4\u8bc1\uff09\u7684\u6307\u793a\u3002\u8bf7\u6ce8\u610f\u6839\u636e\u5b89\u5168\u8003\u8651\uff0c\u5fae\u8f6f\u4e0d\u63a8\u8350\u4f7f\u7528\u8be5\u8ba4\u8bc1\u65b9\u6cd5\u3002<\/p>\n<h2>\u521b\u5efa\u666e\u901a\u7528\u6237<\/h2>\n<p>\u5728Microsoft\u7684\u5b98\u65b9\u7f51\u9875\u4e0a\uff0c\u6211\u4eec\u4ece\u521b\u5efa\u666e\u901a\u7528\u6237\u800c\u4e0d\u662f\u7ba1\u7406\u5458\u7528\u6237\u5f00\u59cb\u8fdb\u884c\u64cd\u4f5c\uff0c\u4f46\u8fd9\u4e2a\u6b65\u9aa4\u5e76\u975e\u5fc5\u987b\u3002\u6211\u8ba4\u4e3a\u8fd9\u662f\u4e3a\u4e86\u9632\u6b62\u7ba1\u7406\u5458\u7528\u6237\u5bc6\u7801\u6cc4\u9732\u800c\u4ece\u5b89\u5168\u89d2\u5ea6\u51fa\u53d1\u9996\u5148\u521b\u5efa\u666e\u901a\u7528\u6237\uff0c\u4f46\u8fd9\u4e2a\u6b65\u9aa4\u4f1a\u5bfc\u81f4\u5728\u51fa\u73b0\u95ee\u9898\u65f6\u96be\u4ee5\u786e\u5b9a\u95ee\u9898\u6240\u5728\u3002\u6700\u597d\u7684\u65b9\u6cd5\u662f\u9996\u5148\u4f7f\u7528\u7ba1\u7406\u5458\u7528\u6237\u8fdb\u884c\u8fde\u63a5\u5c1d\u8bd5\uff0c\u7136\u540e\u518d\u521b\u5efa\u666e\u901a\u7528\u6237\u5e76\u5207\u6362\u8fde\u63a5\u4fe1\u606f\u3002<\/p>\n<p>\u7531\u4e8eMicrosoft\u5b98\u65b9\u9875\u9762\u7684\u4fe1\u606f\u5b58\u5728\u4e0d\u5b8c\u5584\u4e4b\u5904\uff0c\u6211\u4f1a\u5728\u63a5\u4e0b\u6765\u7684\u5185\u5bb9\u4e2d\u89e3\u91ca\u4e00\u822c\u7528\u6237\u7684\u521b\u5efa\u65b9\u5f0f\u4ee5\u53ca\u6743\u9650\u7684\u6388\u4e88\u3002<\/p>\n<h2>\u4f7f\u7528DB\u5de5\u5177\u8fde\u63a5\u5230Azure\u6570\u636e\u5e93\u7684PostgreSQL\u3002<\/h2>\n<p>\u5982\u679c\u5728\u672c\u5730\u5b89\u88c5\u4e86PostgreSQL\uff0c\u5219\u4f1a\u540c\u65f6\u5b89\u88c5\u4e00\u6b3e\u540d\u4e3apsql\u7684\u547d\u4ee4\u884c\u5de5\u5177\uff0c\u53ef\u4ee5\u4f7f\u7528\u8be5\u5de5\u5177\u8fde\u63a5\u5230Azure Database for PostgreSQL\u3002\u7136\u800c\uff0c\u5982\u679c\u4e0d\u9700\u8981\u51c6\u5907\u672c\u5730\u6570\u636e\u5e93\uff0c\u5219\u53ef\u4ee5\u9009\u62e9\u4ec5\u5b89\u88c5psql\uff0c\u6216\u4f7f\u7528\u7c7b\u4f3cpgAdmin\u7684\u5de5\u5177\u3002<\/p>\n<p>\u7531\u4e8e\u6211\u559c\u6b22\u4f7f\u7528\u50cfpgAdmin\u8fd9\u6837\u7684\u56fe\u5f62\u7528\u6237\u754c\u9762\u5de5\u5177\u5904\u7406\u6570\u636e\u5e93\uff0c\u6240\u4ee5\u6211\u9009\u62e9\u4f7f\u7528pgAdmin\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u4f7f\u7528 pgAdmin \u8fdb\u884c\u8fde\u63a5\u65f6\uff0c\u8bf7\u4f7f\u7528\u5728\u521b\u5efa Azure \u6570\u636e\u5e93 for PostgreSQL \u65f6\u6307\u5b9a\u7684\u7528\u6237ID\/\u5bc6\u7801\u8fdb\u884c\u8fde\u63a5\u3002<\/p>\n<h2>\u4e3a\u4e86\u505a\u6d4b\u8bd5\uff0c\u5236\u4f5c\u4e00\u5f20\u684c\u5b50\u3002<\/h2>\n<p>\u6253\u5f00Microsoft\u5b98\u65b9\u9875\u9762\uff0c\u5c06\u5176\u4f5c\u4e3a\u53c2\u8003\u3002\u7136\u540e\u6253\u5f00pgAdmin\u67e5\u8be2\u5de5\u5177\uff0c\u5bf9\u4e4b\u524d\u521b\u5efa\u7684\u6570\u636e\u5e93\u8fd0\u884c\u4ee5\u4e0bSQL\u8bed\u53e5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">DROP<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">IF<\/span> <span class=\"k\">EXISTS<\/span> <span class=\"n\">todo<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">todo<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"nb\">SERIAL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">description<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">255<\/span><span class=\"p\">),<\/span> <span class=\"n\">details<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">4096<\/span><span class=\"p\">),<\/span> <span class=\"n\">done<\/span> <span class=\"nb\">BOOLEAN<\/span><span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/40-0.png\" alt=\"image.png\" \/><\/div>\n<h2>\u521b\u5efa\u4e00\u4e2aSpring Boot\u5e94\u7528\u7a0b\u5e8f<\/h2>\n<h3>\u4f7f\u7528Spring Initializr<\/h3>\n<p>\u4f7f\u7528VSCode\u7684Spring\u6269\u5c55\uff0c\u5c31\u4e0d\u9700\u8981\u5728\u6d4f\u89c8\u5668\u4e2d\u4f7f\u7528Spring Initializr\uff0c\u4f46\u4e3a\u4e86\u65b9\u4fbf\u7406\u89e3\u4f7f\u7528\u4e86\u54ea\u4e9b\u4f9d\u8d56\uff0c\u6211\u5728\u8fd9\u91cc\u9644\u4e0aSpring Initializr\u9875\u9762\u7684\u622a\u56fe\u3002<\/p>\n<p>\u8bf7\u52a1\u5fc5\u6dfb\u52a0\u4ee5\u4e0b\u4e09\u4e2a\u4f9d\u5b58\u5173\u7cfb\uff0c\u5176\u4ed6\u5219\u53ef\u81ea\u9009\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring Web<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring Data JDBC<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">PostgreSQL Driver<\/ul>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/46-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u5728Microsoft\u5b98\u65b9\u9875\u9762\u4e0a\uff0c\u6211\u4eec\u9700\u8981\u5c06Spring Cloud Azure\u7684\u6a21\u5757\u6dfb\u52a0\u5230pom.xml\u6587\u4ef6\u4e2d\uff0c\u4f46\u5bf9\u4e8ePostgreSQL\u8ba4\u8bc1\u6765\u8bf4\uff0c\u8fd9\u662f\u4e0d\u5fc5\u8981\u7684\u3002<\/p>\n<h3>\u5728application.properties\u6587\u4ef6\u4e2d\u5199\u5165\u914d\u7f6e<\/h3>\n<p>\u8bf7\u6253\u5f00 application.properties \u6587\u4ef6\uff0c\u5e76\u8fdb\u884c\u4ee5\u4e0b\u8bbe\u7f6e\u3002\u8bf7\u6839\u636e\u81ea\u5df1\u7684\u73af\u5883\u8fdb\u884c\u56db\u5904\u4fee\u6539\u3002\u5f53\u7136\uff0c\u5220\u9664\u524d\u540e\u7684 &lt;&gt; \u7b26\u53f7\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">your_postgresql_name<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">dbname\uff08url\u306e\u5f8c\u308d\u306b\u4ed8\u3044\u3066\u3044\u308b\u306e\u3067\u304a\u898b\u9003\u3057\u306a\u3044\u3088\u3046\u306b\uff09<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">your_postgresql_username<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">your_postgresql_password<\/ul>\n<pre class=\"post-pre\"><code><span class=\"py\">logging.level.org.springframework.jdbc.core<\/span><span class=\"p\">=<\/span><span class=\"s\">DEBUG<\/span>\r\n\r\n<span class=\"py\">spring.datasource.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:postgresql:\/\/&lt;your_postgresql_name&gt;.postgres.database.azure.com:5432\/&lt;dbname&gt;?sslmode=require<\/span>\r\n<span class=\"py\">spring.datasource.username<\/span><span class=\"p\">=<\/span><span class=\"s\">&lt;your_postgresql_username&gt;<\/span>\r\n<span class=\"py\">spring.datasource.password<\/span><span class=\"p\">=<\/span><span class=\"s\">&lt;your_postgresql_password&gt;<\/span>\r\n<span class=\"py\">spring.datasource.driver-class-name<\/span><span class=\"p\">=<\/span><span class=\"s\">org.postgresql.Driver<\/span>\r\n<\/code><\/pre>\n<h3>\u5b9e\u73b0DB\u8bbf\u95ee<\/h3>\n<p>\u5728Microsoft\u5b98\u65b9\u9875\u9762\u4e0a\uff0c\u63d0\u5230\u4e86GitHub\u7684URL\u4f5c\u4e3a\u793a\u4f8b\u5b9e\u73b0\u7684\u516c\u5f00\u4f4d\u7f6e\u3002\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u8be5GitHub\u4e0a\u7684\u5b9e\u73b0\u3002<\/p>\n<p>\u4ee5\u4e0b\u7684\u4e09\u4e2a\u6587\u4ef6\u662f\u5728 src\/main\/java\/com\/example\/demo \u4e2d\u521b\u5efa\u7684\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/55-0.png\" alt=\"image.png\" \/><\/div>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">com.example.demo<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.data.annotation.Id<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">Todo<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nf\">Todo<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nf\">Todo<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">description<\/span><span class=\"o\">,<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">details<\/span><span class=\"o\">,<\/span> <span class=\"kt\">boolean<\/span> <span class=\"n\">done<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">description<\/span> <span class=\"o\">=<\/span> <span class=\"n\">description<\/span><span class=\"o\">;<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">details<\/span> <span class=\"o\">=<\/span> <span class=\"n\">details<\/span><span class=\"o\">;<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">done<\/span> <span class=\"o\">=<\/span> <span class=\"n\">done<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Id<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Long<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">description<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">details<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"kt\">boolean<\/span> <span class=\"n\">done<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Long<\/span> <span class=\"nf\">getId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setId<\/span><span class=\"o\">(<\/span><span class=\"nc\">Long<\/span> <span class=\"n\">id<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">getDescription<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">description<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setDescription<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">description<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">description<\/span> <span class=\"o\">=<\/span> <span class=\"n\">description<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">getDetails<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">details<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setDetails<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">details<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">details<\/span> <span class=\"o\">=<\/span> <span class=\"n\">details<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">boolean<\/span> <span class=\"nf\">isDone<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">done<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setDone<\/span><span class=\"o\">(<\/span><span class=\"kt\">boolean<\/span> <span class=\"n\">done<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">done<\/span> <span class=\"o\">=<\/span> <span class=\"n\">done<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">com.example.demo<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.http.HttpStatus<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.*<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@RestController<\/span>\r\n<span class=\"nd\">@RequestMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"o\">)<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">TodoController<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"kd\">final<\/span> <span class=\"nc\">TodoRepository<\/span> <span class=\"n\">todoRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nf\">TodoController<\/span><span class=\"o\">(<\/span><span class=\"nc\">TodoRepository<\/span> <span class=\"n\">todoRepository<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">todoRepository<\/span> <span class=\"o\">=<\/span> <span class=\"n\">todoRepository<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@PostMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"nd\">@ResponseStatus<\/span><span class=\"o\">(<\/span><span class=\"nc\">HttpStatus<\/span><span class=\"o\">.<\/span><span class=\"na\">CREATED<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Todo<\/span> <span class=\"nf\">createTodo<\/span><span class=\"o\">(<\/span><span class=\"nd\">@RequestBody<\/span> <span class=\"nc\">Todo<\/span> <span class=\"n\">todo<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">todoRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">save<\/span><span class=\"o\">(<\/span><span class=\"n\">todo<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@GetMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Iterable<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Todo<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getTodos<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">todoRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findAll<\/span><span class=\"o\">();<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">com.example.demo<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.data.repository.CrudRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">interface<\/span> <span class=\"nc\">TodoRepository<\/span> <span class=\"kd\">extends<\/span> <span class=\"nc\">CrudRepository<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Todo<\/span><span class=\"o\">,<\/span> <span class=\"nc\">Long<\/span><span class=\"o\">&gt;<\/span> <span class=\"o\">{<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<h2>\u786e\u8ba4<\/h2>\n<p>\u4e0b\u8f7ddependency\u3002<\/p>\n<pre class=\"post-pre\"><code>.\/mvnw clean <span class=\"nb\">install<\/span>\r\n<\/code><\/pre>\n<p>\u6267\u884cSpring Boot\u5e94\u7528\u7a0b\u5e8f\u3002<\/p>\n<pre class=\"post-pre\"><code>.\/mvnw spring-boot:run\r\n<\/code><\/pre>\n<p>\u5f53\u8bbf\u95ee http:\/\/localhost:8080 \u65f6\uff0c\u5c06\u663e\u793a\u4ee5\u4e0b\u7ed3\u679c\uff0c\u786e\u8ba4\u5df2\u6210\u529f\u8fde\u63a5\u5230 Azure Database for PostgreSQL\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"p\">[<\/span>\r\n    <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"description\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"\u30c6\u30b9\u30c8\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"details\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"\u8a73\u7d30\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"done\"<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<h1>\u4f7f\u7528 Azure Active Directory \u8eab\u4efd\u9a8c\u8bc1\u4ece Spring Boot \u8bbf\u95ee<\/h1>\n<p>\u5728Microsoft\u5b98\u65b9\u9875\u9762\u4e0a\uff0c\u63d0\u5230\u4e86\u4e00\u79cd\u88ab\u79f0\u4e3a&#8221;\u65e0\u5bc6\u7801\uff08\u63a8\u8350\uff09&#8221;\u7684\u65b9\u6cd5\u3002\u901a\u8fc7\u4f7f\u7528Azure AD\uff0c\u65e0\u9700\u5199\u5165\u4efb\u4f55\u5bc6\u7801\uff0c\u4ece\u800c\u964d\u4f4e\u4e86\u6cc4\u6f0f\u4e8b\u6545\u7684\u53d1\u751f\u53ef\u80fd\u6027\u3002<\/p>\n<h2>\u521b\u5efa\u666e\u901a\u7528\u6237<\/h2>\n<p>\u5373\u4f7f\u4e0d\u4f7f\u7528\u5bc6\u7801\uff0c\u4e5f\u53ef\u4ee5\u50cf\u5bc6\u7801\u9a8c\u8bc1\u4e00\u6837\uff0c\u5728Microsoft\u5b98\u65b9\u9875\u9762\u4e0a\u521b\u5efa\u666e\u901a\u7528\u6237\u800c\u5f00\u59cb\u64cd\u4f5c\u3002\u4f46\u8fd9\u4e2a\u6b65\u9aa4\u4e0d\u662f\u5fc5\u9700\u7684\u3002\u9996\u5148\uff0c\u5728\u521b\u5efaAzure Database for PostgreSQL\u65f6\uff0c\u60a8\u5e94\u8be5\u5df2\u7ecf\u5c06\u81ea\u5df1\u6307\u5b9a\u4e3aAzure AD\u7ba1\u7406\u5458\uff08\u5982\u4e0a\u6240\u8ff0\u7684\u6b65\u9aa4\uff09\u3002\u4e00\u65e6\u786e\u8ba4\u4e86\u81ea\u5df1\u4f5c\u4e3a\u7ba1\u7406\u5458\u80fd\u591f\u767b\u5f55\uff0c\u5c31\u53ef\u4ee5\u5c06\u5176\u4ed6Azure AD\u7528\u6237\u8bbe\u7f6e\u4e3a\u666e\u901a\u7528\u6237\uff0c\u5e76\u786e\u4fdd\u4ed6\u4eec\u80fd\u591f\u767b\u5f55\u3002<\/p>\n<p>\u521b\u5efa\u666e\u901a\u7528\u6237\u7684\u65b9\u6cd5\u5728Microsoft\u5b98\u65b9\u9875\u9762\u4e2d\u6709\u8bf4\u660e\uff0c\u4f46\u4f7f\u7528\u8fd9\u79cd\u65b9\u6cd5\u53ef\u80fd\u4f1a\u51fa\u73b0\u95ee\u9898\uff08\u6211\u6ca1\u6709\u6210\u529f\uff09\u3002\u5728\u4e0b\u9762\u7684\u6b65\u9aa4\u4e2d\uff0c\u6211\u5c06\u4ecb\u7ecd\u9010\u6b65\u521b\u5efa\u7684\u65b9\u6cd5\uff0c\u8bf7\u9700\u8981\u7684\u4eba\u53c2\u8003\u90a3\u91cc\u3002<\/p>\n<h2>\u6388\u4e88Azure AD\u7528\u6237\uff08\u81ea\u5df1\uff09\u6743\u9650\u3002<\/h2>\n<p>\u5728\u521b\u5efaAzure Database for PostgreSQL\u65f6\u6307\u5b9a\u7684Azure AD\u7ba1\u7406\u5458\u7528\u6237\uff0c\u7531\u4e8e\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u6ca1\u6709\u8bbf\u95ee\u6570\u636e\u5e93\u8868\u7684\u6743\u9650\uff0c\u56e0\u6b64\u9700\u8981\u6388\u4e88\u5176\u6743\u9650\u3002\u5728\u6388\u4e88\u6743\u9650\u65f6\uff0c\u8bf7\u4f7f\u7528PostgreSQL\u8eab\u4efd\u9a8c\u8bc1\uff08\u4f7f\u7528\u7528\u6237\u540d\u548c\u5bc6\u7801\uff09\uff0c\u5e76\u4f7f\u7528pgAdmin\u8fdb\u884c\u767b\u5f55\u3002<\/p>\n<p>\u767b\u5f55\u540e\uff0c\u6253\u5f00\u767b\u5f55\/\u7fa4\u7ec4\u89d2\u8272\u3002\u7136\u540e\uff0c\u60a8\u5e94\u8be5\u80fd\u591f\u770b\u5230\u4e0eAzure AD\u7528\u6237\u4e3b\u4f53\u540d\u76f8\u540c\u7684\u7528\u6237\u5df2\u88ab\u521b\u5efa\u3002\u8bf7\u590d\u5236\u8be5\u7528\u6237\u540d\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/73-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u6253\u5f00\u67e5\u8be2\u5de5\u5177\uff0c\u8fd0\u884c\u4ee5\u4e0bSQL\u8bed\u53e5\u6765\u6388\u4e88\u6743\u9650\u3002\u8bf7\u5c06DBName\u548cYOUR_USER_PRINCIPAL_NAME\u66f4\u6539\u4e3a\u60a8\u81ea\u5df1\u7684\u3002\uff08\u5220\u9664\u5c16\u62ec\u53f7\u7684\u524d\u540e\u5185\u5bb9\uff09<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"o\">&lt;<\/span><span class=\"n\">DBName<\/span><span class=\"o\">&gt;<\/span> <span class=\"k\">TO<\/span> <span class=\"nv\">\"&lt;YOUR_USER_PRINCIPAL_NAME&gt;\"<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"k\">ALL<\/span> <span class=\"n\">TABLES<\/span> <span class=\"k\">IN<\/span> <span class=\"k\">SCHEMA<\/span> <span class=\"k\">public<\/span> <span class=\"k\">TO<\/span> <span class=\"nv\">\"&lt;YOUR_USER_PRINCIPAL_NAME&gt;\"<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<h2>\u5236\u4f5cSpring Boot\u5e94\u7528\u7a0b\u5e8f<\/h2>\n<p>\u4f7f\u7528Spring Initializr\u521b\u5efa\u7684\u65b9\u6cd5\u4e0e\u5728\u4e0a\u9762\u63d0\u5230\u7684\u7528\u5bc6\u7801\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u65b9\u6cd5\u76f8\u540c\u3002<\/p>\n<h3>\u5728application.properties\u6587\u4ef6\u4e2d\u5199\u5165\u914d\u7f6e<\/h3>\n<p>\u6253\u5f00 application.properties \u6587\u4ef6\uff0c\u5e76\u8fdb\u884c\u4ee5\u4e0b\u8bbe\u7f6e\u3002\u8bf7\u6839\u636e\u60a8\u7684\u73af\u5883\u4fee\u6539\u4e09\u4e2a\u4f4d\u7f6e\u3002\u5f53\u7136\uff0c\u5220\u9664 &lt;&gt; \u524d\u540e\u7684\u5185\u5bb9\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">your_postgresql_name<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">dbname\uff08url\u306e\u5f8c\u308d\u306b\u4ed8\u3044\u3066\u3044\u308b\u306e\u3067\u304a\u898b\u9003\u3057\u306a\u3044\u3088\u3046\u306b\uff09<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">your_postgresql_username<\/ul>\n<pre class=\"post-pre\"><code><span class=\"py\">logging.level.org.springframework.jdbc.core<\/span><span class=\"p\">=<\/span><span class=\"s\">DEBUG<\/span>\r\n\r\n<span class=\"py\">spring.datasource.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:postgresql:\/\/&lt;your_postgresql_name&gt;.postgres.database.azure.com:5432\/&lt;dbname&gt;?sslmode=require<\/span>\r\n<span class=\"py\">spring.datasource.username<\/span><span class=\"p\">=<\/span><span class=\"s\">&lt;your_postgresql_username&gt;<\/span>\r\n<span class=\"py\">spring.datasource.azure.passwordless-enabled<\/span><span class=\"p\">=<\/span><span class=\"s\">true<\/span>\r\n<\/code><\/pre>\n<h2>\u6dfb\u52a0\u7528\u4e8e Azure AD \u8ba4\u8bc1\u7684\u4f9d\u8d56<\/h2>\n<p>\u8bf7\u6ce8\u610f\uff0c\u60a8\u9700\u8981\u5411pom.xml\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4e24\u4e2a\u5185\u5bb9\uff0c\u4f46\u662f\u8bf7\u6ce8\u610f\u5b83\u4eec\u9700\u8981\u6dfb\u52a0\u5230\u4e0d\u540c\u7684\u4f4d\u7f6e\u3002<\/p>\n<p>spring-cloud-azure-starter-jdbc-postgresql<br \/>\n\u5e94\u5f53\u653e\u7f6e\u5728 Project\/dependencies \u7684\u5b50\u76ee\u5f55\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t<span class=\"nt\">&lt;groupId&gt;<\/span>com.azure.spring<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-cloud-azure-starter-jdbc-postgresql<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u7b2c\u4e8c\u4e2a spring-cloud-azure-dependencies \u5e94\u8be5\u76f4\u63a5\u5728\u9879\u76ee\u4e0b\u5217\u51fa\u3002\u7248\u672c\u53f7\u662f5.5.0\uff0c\u4f46\u5e94\u8be5\u8bbe\u7f6e\u4e3a\u6700\u65b0\u7248\u672c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nt\">&lt;dependencyManagement&gt;<\/span>\r\n\t<span class=\"nt\">&lt;dependencies&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>com.azure.spring<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-cloud-azure-dependencies<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;version&gt;<\/span>5.5.0<span class=\"nt\">&lt;\/version&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;type&gt;<\/span>pom<span class=\"nt\">&lt;\/type&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;scope&gt;<\/span>import<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t<span class=\"nt\">&lt;\/dependencies&gt;<\/span>\r\n<span class=\"nt\">&lt;\/dependencyManagement&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u4e3a\u4e86\u8c28\u614e\u8d77\u89c1\uff0c\u6211\u4f1a\u9644\u4e0a\u5df2\u6dfb\u52a0\u7684 pom.xml \u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"cp\">&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;<\/span>\r\n<span class=\"nt\">&lt;project<\/span> <span class=\"na\">xmlns=<\/span><span class=\"s\">\"http:\/\/maven.apache.org\/POM\/4.0.0\"<\/span> <span class=\"na\">xmlns:xsi=<\/span><span class=\"s\">\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"<\/span>\r\n\t<span class=\"na\">xsi:schemaLocation=<\/span><span class=\"s\">\"http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\"<\/span><span class=\"nt\">&gt;<\/span>\r\n\t<span class=\"nt\">&lt;modelVersion&gt;<\/span>4.0.0<span class=\"nt\">&lt;\/modelVersion&gt;<\/span>\r\n\t<span class=\"nt\">&lt;parent&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-starter-parent<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;version&gt;<\/span>3.1.3<span class=\"nt\">&lt;\/version&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;relativePath\/&gt;<\/span> <span class=\"c\">&lt;!-- lookup parent from repository --&gt;<\/span>\r\n\t<span class=\"nt\">&lt;\/parent&gt;<\/span>\r\n\t<span class=\"nt\">&lt;groupId&gt;<\/span>com.example<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t<span class=\"nt\">&lt;artifactId&gt;<\/span>demo<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t<span class=\"nt\">&lt;version&gt;<\/span>0.0.1-SNAPSHOT<span class=\"nt\">&lt;\/version&gt;<\/span>\r\n\t<span class=\"nt\">&lt;name&gt;<\/span>demo<span class=\"nt\">&lt;\/name&gt;<\/span>\r\n\t<span class=\"nt\">&lt;description&gt;<\/span>Demo project for Spring Boot<span class=\"nt\">&lt;\/description&gt;<\/span>\r\n\t<span class=\"nt\">&lt;properties&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;java.version&gt;<\/span>17<span class=\"nt\">&lt;\/java.version&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;spring-cloud-azure.version&gt;<\/span>5.5.0<span class=\"nt\">&lt;\/spring-cloud-azure.version&gt;<\/span>\r\n\t<span class=\"nt\">&lt;\/properties&gt;<\/span>\r\n\t<span class=\"nt\">&lt;dependencies&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-starter-web<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-starter-data-jdbc<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-devtools<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;scope&gt;<\/span>runtime<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;optional&gt;<\/span>true<span class=\"nt\">&lt;\/optional&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.postgresql<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>postgresql<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;scope&gt;<\/span>runtime<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-starter-test<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;scope&gt;<\/span>test<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>com.azure.spring<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-cloud-azure-starter-jdbc-postgresql<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\r\n\t<span class=\"nt\">&lt;\/dependencies&gt;<\/span>\r\n\r\n\t<span class=\"nt\">&lt;dependencyManagement&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;dependencies&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;dependency&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>com.azure.spring<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-cloud-azure-dependencies<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;version&gt;<\/span>5.5.0<span class=\"nt\">&lt;\/version&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;type&gt;<\/span>pom<span class=\"nt\">&lt;\/type&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;scope&gt;<\/span>import<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/dependencies&gt;<\/span>\r\n\t<span class=\"nt\">&lt;\/dependencyManagement&gt;<\/span>\r\n\r\n\t<span class=\"nt\">&lt;build&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;plugins&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;plugin&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;groupId&gt;<\/span>org.springframework.boot<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n\t\t\t\t<span class=\"nt\">&lt;artifactId&gt;<\/span>spring-boot-maven-plugin<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n\t\t\t<span class=\"nt\">&lt;\/plugin&gt;<\/span>\r\n\t\t<span class=\"nt\">&lt;\/plugins&gt;<\/span>\r\n\t<span class=\"nt\">&lt;\/build&gt;<\/span>\r\n\r\n<span class=\"nt\">&lt;\/project&gt;<\/span>\r\n<\/code><\/pre>\n<h2>\u786e\u8ba4<\/h2>\n<p>\u8bf7\u4f7f\u7528\u5bc6\u7801\u8fdb\u884c\u8ba4\u8bc1\u65f6\uff0c\u786e\u8ba4\u5b9e\u65bd\u4e0e\u8ba4\u8bc1\u4e00\u81f4\u3002\u8bf7\u5b9e\u65bdTodo\u3001TodoController\u548cTodoRepository\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\uff0c\u60a8\u9700\u8981\u5728\u6267\u884c\u73af\u5883\u4e2d\u4f7f\u7528Azure CLI\u8fdb\u884c\u767b\u5f55\u3002\u8bf7\u786e\u4fdd\u4f7f\u7528\u521b\u5efaAzure Database for PostgreSQL\u65f6\u6307\u5b9a\u7684\u5e10\u6237\u767b\u5f55\u3002<\/p>\n<pre class=\"post-pre\"><code>az login\r\n<\/code><\/pre>\n<p>\u53ea\u9700\u4f7f\u7528\u5df2\u767b\u5f55\u72b6\u6001\u6765\u6267\u884cSpring Boot\u5e94\u7528\u7a0b\u5e8f\uff0c\u5b83\u5c06\u81ea\u52a8\u83b7\u53d6\u767b\u5f55\u7684\u4ee4\u724c\u4fe1\u606f\u5e76\u8fdb\u884c\u767b\u5f55\uff0c\u8bf7\u5c1d\u8bd5\u4e00\u4e0b\u3002\u8fd9\u662f\u56e0\u4e3aSpring Cloud Azure\u4f7f\u7528\u4e86DefaultAzureCredential\u6765\u8fdb\u884c\u767b\u5f55\u3002<\/p>\n<p>DefaultAzureCredential \u901a\u8fc7\u6309\u4f18\u5148\u987a\u5e8f\u83b7\u53d6\u8fd0\u884c\u65f6\u7684\u767b\u5f55\u51ed\u636e\u3002\u9996\u5148\u68c0\u7d22\u73af\u5883\u53d8\u91cf\uff0c\u7136\u540e\u662f\u6258\u7ba1\u6807\u8bc6\uff0c\u63a5\u7740\u662f IntelliJ\u3001VSCode\uff0c\u6700\u540e\u662f Azure CLI \u7684\u767b\u5f55\u51ed\u636e\u3002\u56e0\u6b64\uff0c\u5982\u679c\u4f7f\u7528\u6b64\u6e90\u4ee3\u7801\u90e8\u7f72\u5230 Azure\uff0c\u5219\u53ea\u9700\u5c06\u767b\u5f55\u6240\u9700\u7684\u51ed\u636e\u4f5c\u4e3a\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u5728 Azure \u4fa7\uff0c\u7cfb\u7edf\u4f1a\u81ea\u52a8\u4f7f\u7528\u5b83\u4eec\u8fdb\u884c\u767b\u5f55\uff08\u5efa\u8bae\u4f7f\u7528\u6258\u7ba1\u6807\u8bc6\u6216\u670d\u52a1\u8fde\u63a5\u5668\uff09\u3002<\/p>\n<p>\u8bf7\u67e5\u770b Microsoft \u5b98\u65b9\u9875\u9762\u4e86\u89e3\u6709\u5173 DefaultAzureCredential \u7684\u8be6\u7ec6\u4fe1\u606f\u3002<\/p>\n<h1>(PostgreSQL\u9644\u52a0\u8bf4\u660e) \u521b\u5efa\u666e\u901a\u7528\u6237\u7684\u8ba4\u8bc1\u65b9\u5f0f<\/h1>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/98-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u5728\u6253\u5f00\u7684\u67e5\u8be2\u5de5\u5177\u4e2d\u8f93\u5165\u4ee5\u4e0bSQL\u3002\u5728\u6b64\uff0c\u6211\u4eec\u4f7f\u7528\u540d\u4e3auser1\u7684\u7528\u6237\uff0c\u5e76\u4e3atestdb\u6570\u636e\u5e93\u53ca\u5176\u5185\u90e8\u7684\u8868\u8d4b\u4e88\u4e86\u5168\u90e8\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">USER<\/span> <span class=\"nv\">\"user1\"<\/span> <span class=\"k\">WITH<\/span> <span class=\"n\">LOGIN<\/span> <span class=\"n\">PASSWORD<\/span> <span class=\"s1\">'YOUR_PASSWORD'<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">testdb<\/span> <span class=\"k\">TO<\/span> <span class=\"nv\">\"user1\"<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"k\">ALL<\/span> <span class=\"n\">TABLES<\/span> <span class=\"k\">IN<\/span> <span class=\"k\">SCHEMA<\/span> <span class=\"k\">public<\/span> <span class=\"k\">TO<\/span> <span class=\"nv\">\"user1\"<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u8bf7\u6ce8\u610f\uff0c\u7531\u4e8eMicrosoft\u5b98\u65b9\u9875\u9762\u672a\u63d0\u4f9b\u8868\u683c\u6388\u6743\u529f\u80fd\uff0c\u6240\u4ee5\u65e0\u6cd5\u5b9e\u73b0\u6b64\u64cd\u4f5c\u3002<\/p>\n<h1>\u521b\u5efaAzure AD\u901a\u7528\u7528\u6237\u7684\u65b9\u5f0f\uff08\u9644\u8d60\uff09<\/h1>\n<p>\u67e5\u770bMicrosoft\u5b98\u65b9\u9875\u9762\uff0c\u91cc\u9762\u8bf4\u5982\u679c\u7528Azure CLI\u8f93\u5165\u4e0b\u9762\u7684\u547d\u4ee4\u5c31\u53ef\u4ee5\u4e86\u3002\u7136\u800c\uff0c\u8fd9\u79cd\u65b9\u6cd5\u5f80\u5f80\u884c\u4e0d\u901a\u3002\u5982\u679c\u8fd9\u4e2a\u547d\u4ee4\u80fd\u591f\u8fd0\u884c\uff0c\u90a3\u4e48\u5c31\u4e0d\u9700\u8981\u53c2\u8003\u4ee5\u4e0b\u6b65\u9aa4\u4e86\u3002\u5728\u6211\u7684\u60c5\u51b5\u4e0b\uff0c\u5b83\u6ca1\u6709\u6b63\u5e38\u5de5\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code>az connection create postgres-flexible <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--resource-group<\/span> &lt;your_resource_group_name&gt; <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--connection<\/span> postgres_conn <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--target-resource-group<\/span> &lt;your_resource_group_name&gt; <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--server<\/span> postgresqlflexibletest <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--database<\/span> demo <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--user-account<\/span> <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--query<\/span> authInfo.userName <span class=\"se\">\\<\/span>\r\n       <span class=\"nt\">--output<\/span> tsv\r\n<\/code><\/pre>\n<p>\u9996\u5148\uff0c\u60a8\u9700\u8981\u4f7f\u7528\u5728\u521b\u5efaAzure Database for PostgreSQL\u65f6\u6307\u5b9a\u7684Azure AD\u7ba1\u7406\u5458\u8eab\u4efd\u8fde\u63a5\u5230Azure Database for PostgreSQL\u3002\u5982\u679c\u4e0d\u4f7f\u7528\u8be5\u7528\u6237\u8fdb\u884c\u8fde\u63a5\uff0c\u5c06\u65e0\u6cd5\u521b\u5efaAzure AD\u8ba4\u8bc1\u7684\u666e\u901a\u7528\u6237\u3002\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528\u8be5\u7528\u6237\u8fde\u63a5\u5230Azure Database for PostgreSQL\u3002<\/p>\n<h2>\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u3002<\/h2>\n<h3>\u83b7\u53d6\u4ee4\u724c<\/h3>\n<p>\u5f53\u8fde\u63a5\u5230Azure\u6570\u636e\u5e93\u4ee5\u4f7f\u7528Azure AD\u65f6\uff0c\u60a8\u9700\u8981\u83b7\u53d6\u7528\u4e8e\u8fde\u63a5\u5230Azure Database for PostgreSQL\u7684\u8bbf\u95ee\u4ee4\u724c\uff0c\u76f8\u5f53\u4e8e\u5bc6\u7801\u3002\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u83b7\u53d6\u8be5\u4ee4\u724c\u3002<\/p>\n<pre class=\"post-pre\"><code>az account get-access-token <span class=\"nt\">--resource-type<\/span> oss-rdbms\r\n<\/code><\/pre>\n<p>\u5728\u663e\u793a\u7684Json\u4e2d\uff0caccessToken\u952e\u7684\u503c\u662fToken\u3002\u6211\u4f1a\u5c06\u5176\u8bb0\u5f55\u5728\u67d0\u4e2a\u5730\u65b9\u3002<\/p>\n<h3>\u83b7\u53d6\u7528\u6237\u4e3b\u4f53\u540d\u79f0<\/h3>\n<p>\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u662f\u5728Azure AD\u4e2d\u552f\u4e00\u8bc6\u522b\u7528\u6237\u7684\u5185\u5bb9\u3002\u8bf7\u52a1\u5fc5\u786e\u8ba4\u5b83\u4e0d\u540c\u4e8e\u767b\u5f55ID\u3002\u4e0a\u8ff0\u4ecb\u7ecd\u4e86\u5982\u4f55\u4ecepgAdmin\u8fde\u63a5\u6253\u5f00\u7528\u6237\/\u7ec4\u89d2\u8272\u5e76\u663e\u793a\u7528\u6237\u5217\u8868\u4ee5\u83b7\u53d6\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u7684\u65b9\u6cd5\uff0c\u8fd8\u6709\u53e6\u4e00\u79cd\u65b9\u6cd5\u3002\u5728Azure\u95e8\u6237\u4e2d\u6253\u5f00Azure AD\uff0c\u5e76\u9009\u62e9\u5de6\u4fa7\u83dc\u5355\u4e2d\u7684&#8221;\u7528\u6237&#8221;\u3002\u641c\u7d22\u5e76\u627e\u5230\u60a8\u5728\u521b\u5efaAzure Database for PostgreSQL\u65f6\u6307\u5b9a\u7684\u7528\u6237\uff0c\u5e76\u70b9\u51fb\u5b83\uff0c\u5c31\u53ef\u4ee5\u770b\u5230\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u7684\u8bb0\u5f55\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/113-0.png\" alt=\"image.png\" \/><\/div>\n<h3>\u4f7f\u7528 pgAdmin \u8fdb\u884c\u8fde\u63a5<\/h3>\n<p>\u521b\u5efa\u65b0\u7684\u670d\u52a1\u5668\u8fde\u63a5\u4fe1\u606f\u3002\u5728\u6b64\u8fc7\u7a0b\u4e2d\uff0c\u5c06\u201c\u7acb\u5373\u8fde\u63a5\u201d\u8bbe\u7f6e\u4e3a\u5173\u95ed\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/116-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u8bbe\u7f6e\u7528\u6237\u540d\u65f6\uff0c\u8bf7\u4f7f\u7528 Azure AD \u7ba1\u7406\u5458\u7684\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u3002\u8bf7\u52a1\u5fc5\u901a\u8fc7\u4e0a\u8ff0\u65b9\u6cd5\u53c2\u8003 Azure AD \u5e76\u8fdb\u884c\u786e\u8ba4\u3002\u7531\u4e8e\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u4e0d\u4e00\u5b9a\u4e0e\u767b\u5f55\u65f6\u7684\u7535\u5b50\u90ae\u4ef6\u5730\u5740\u76f8\u540c\uff0c\u8bf7\u6ce8\u610f\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/118-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u4fdd\u5b58\u540e\uff0c\u8fde\u63a5\u65f6\u4f1a\u5f39\u51fa\u5bc6\u7801\u8f93\u5165\u63d0\u793a\u3002\u53ea\u9700\u8f93\u5165\u4e4b\u524d\u83b7\u53d6\u5230\u7684\u4ee4\u724c(Token)\uff0c\u5373\u53ef\u5b8c\u6210\u8fde\u63a5\u3002<\/p>\n<h2>\u521b\u5efa\u4e00\u4e2a\u666e\u901a\u7528\u6237<\/h2>\n<p>\u521b\u5efa\u4e00\u4e2a\u9488\u5bf9 Azure Database for PostgreSQL \u4e2d Azure AD \u8ba4\u8bc1\u7684\u5e38\u89c4\u7528\u6237\uff0c\u662f\u6307\u4e0b\u5217\u5de5\u4f5c\uff1a<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728 Azure AD \u4e2d\u521b\u5efa\u4e00\u4e2a\u5e38\u89c4\u7528\u6237\u6216\u4f7f\u7528\u73b0\u6709\u7528\u6237<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u5728 PostgreSQL \u4e2d\u521b\u5efa\u4e00\u4e2a\u4e0e\u5e38\u89c4\u7528\u6237\u7684\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u76f8\u540c\u7684\u7528\u6237\uff0c\u5e76\u5c06 Azure AD \u7684\u5e38\u89c4\u7528\u6237\u548c PostgreSQL \u7684\u7528\u6237\u5173\u8054\u8d77\u6765<\/ol>\n<p>\u8fd9\u4e2a\u4efb\u52a1\u5e76\u4e0d\u662f\u5f88\u590d\u6742\uff0c\u4f46\u521a\u5f00\u59cb\u65f6\u53ef\u80fd\u4f1a\u6709\u4e9b\u96be\u7406\u89e3\u3002\u6211\u4eec\u4e00\u6b65\u4e00\u6b65\u6765\u505a\u5427\u3002<\/p>\n<h3>\u5728 Azure AD \u4e0a\u521b\u5efa\u7528\u4e8e\u6d4b\u8bd5\u7684\u7528\u6237<\/h3>\n<p>\u5982\u679c\u60a8\u5c06\u73b0\u6709\u7528\u6237\u6ce8\u518c\u4e3a\u5e38\u89c4\u7528\u6237\uff0c\u5219\u65e0\u9700\u6267\u884c\u6b64\u64cd\u4f5c\u3002\u5982\u679c\u60a8\u60f3\u5728 Azure AD \u4e2d\u521b\u5efa\u5e38\u89c4\u7528\u6237\u8fdb\u884c\u6d4b\u8bd5\uff0c\u5219\u9700\u8981\u5177\u5907\u521b\u5efa\u6743\u9650\u3002\u5982\u679c\u6709\u521b\u5efa\u6743\u9650\uff0c\u8bf7\u6253\u5f00 Azure \u95e8\u6237\u5e76\u521b\u5efa\u7528\u6237\u3002\u5982\u679c\u6ca1\u6709\u521b\u5efa\u6743\u9650\uff0c\u5219\u53ef\u4ee5\u4f7f\u7528\u670d\u52a1\u4e3b\u4f53\u66ff\u4ee3\u3002<\/p>\n<p>\u53ef\u4ee5\u901a\u8fc7Azure AD\u7684&#8221;\u5e94\u7528\u7a0b\u5e8f\u6ce8\u518c&#8221;\u6765\u521b\u5efa\u670d\u52a1\u4e3b\u4f53\uff0c\u4f46\u8fd9\u6837\u6bd4\u8f83\u9ebb\u70e6\uff0c\u56e0\u6b64\u6211\u4eec\u5c06\u4f7f\u7528Azure CLI\u6765\u521b\u5efa\u3002\u901a\u8fc7\u5728\u8fd9\u91cc\u521b\u5efa\u7684\u670d\u52a1\u4e3b\u4f53\uff0c\u53ef\u4ee5\u5728Azure AD\u7684&#8221;\u5e94\u7528\u7a0b\u5e8f\u6ce8\u518c&#8221;\u4e2d\u6253\u5f00\u5e76\u70b9\u51fb&#8221;\u62e5\u6709\u7684\u5e94\u7528\u7a0b\u5e8f&#8221;\u6765\u67e5\u770b\u3002\u5982\u679c\u4e0d\u518d\u9700\u8981\uff0c\u4ece\u8fd9\u91cc\u5220\u9664\u5c06\u4f1a\u5f88\u5bb9\u6613\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/127-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u521b\u5efa\u670d\u52a1\u4e3b\u4f53\u3002\u60a8\u53ef\u4ee5\u81ea\u7531\u9009\u62e9\u901a\u8fc7&#8211;name\u9009\u9879\u6765\u547d\u540d\u3002\u7531\u4e8e\u670d\u52a1\u4e3b\u4f53\u9700\u8981\u8bbf\u95eeAzure Database for PostgreSQL\uff0c\u56e0\u6b64\u5728\u521b\u5efa\u65f6\u6211\u5df2\u7ecf\u6388\u4e88\u4e86Contributor\u89d2\u8272\u3002\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff0c\u8fd9\u662f\u5728\u8ba2\u9605\u7ea7\u522b\u4e0a\u8fdb\u884c\u7684\uff0c\u6240\u4ee5\u8303\u56f4\u76f8\u5f53\u5927\u3002\u5f53\u7136\uff0c\u4ece\u5b89\u5168\u89d2\u5ea6\u8003\u8651\uff0c\u6211\u4eec\u5e94\u8be5\u8fdb\u4e00\u6b65\u7f29\u5c0f\u8303\u56f4\u5e76\u6388\u4e88\u6bd4Contributor\u89d2\u8272\u66f4\u5c0f\u7684\u6743\u9650\uff0c\u8fd9\u662f\u5f53\u7136\u7684\u3002<\/p>\n<p>\u8bf7\u786e\u4fdd\u5373\u4f7f\u662f\u73b0\u6709\u7684 Azure AD \u7528\u6237\u4e5f\u80fd\u591f\u5728\u8fdb\u884c Azure AD \u8ba4\u8bc1\u7684\u60c5\u51b5\u4e0b\u8bbf\u95ee Azure Database for PostgreSQL\uff0c\u5e76\u62e5\u6709\u76f8\u5e94\u7684\u8bbf\u95ee\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code>az ad sp create-for-rbac <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--name<\/span> postgresql-test <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--role<\/span> Contributor <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--scopes<\/span> \/subscriptions\/00000000-0000-0000-0000-000000000000 \r\n<\/code><\/pre>\n<p>\u6267\u884c\u8be5\u547d\u4ee4\u540e\uff0c\u60a8\u5c06\u83b7\u5f97appId\u548cpassword\u7684\u8fd4\u56de\u7ed3\u679c\uff0c\u8bf7\u8bb0\u4e0b\u6765\u3002<\/p>\n<h3>\u521b\u5efa\u4e00\u4e2a\u5728PostgreSQL\u4e2d\u62e5\u6709\u4e0eAzure AD\u7528\u6237\u5173\u8054\u7684\u901a\u5e38\u4e0e\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u76f8\u540c\u7684\u7528\u6237\u3002<\/h3>\n<p>\u53ea\u9700\u8981\u4e00\u500b\u9078\u9805\uff0c\u4ee5\u4e0b\u662f\u7528\u4e2d\u6587\u5c0d\u4e0a\u8ff0\u5167\u5bb9\u9032\u884c\u6539\u8ff0\uff1a<\/p>\n<p>\u5728\u4f7f\u7528 Azure AD \u7ba1\u7406\u8005\u5e33\u6236\u9023\u63a5\u5230 pgAdmin \u7684\u60c5\u6cc1\u4e0b\uff0c\u53ea\u9700\u57f7\u884c\u4e00\u6b21 SQL \u67e5\u8a62\u5373\u53ef\u5b8c\u6210\u6b64\u64cd\u4f5c\u3002\u6253\u958b\u67e5\u8a62\u5de5\u5177\u4e26\u5c0d postgres \u6578\u64da\u5eab\u767c\u9001\u4ee5\u4e0b SQL \u4ee3\u78bc\u3002\u4f60\u53ef\u80fd\u6703\u8a8d\u70ba\u5b83\u61c9\u8a72\u662f\u5275\u5efa\u8a9e\u53e5\u800c\u4e0d\u662f\u9078\u64c7\u8a9e\u53e5\uff0c\u4f46\u5be6\u969b\u4e0a\u9019\u662f\u6b63\u78ba\u7684\u3002<\/p>\n<p>\u7b2c\u4e00\u4e2a\u53c2\u6570\u9700\u8981\u8bbe\u7f6eAzure AD\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u3002\u5982\u679c\u521b\u5efa\u4e86\u670d\u52a1\u4e3b\u4f53\uff0c\u5219\u4e3a\u6307\u5b9a\u7684\u670d\u52a1\u4e3b\u4f53\u540d\u79f0\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">pgaadauth_create_principal<\/span><span class=\"p\">(<\/span><span class=\"s1\">'postgresql-test'<\/span><span class=\"p\">,<\/span> <span class=\"k\">false<\/span><span class=\"p\">,<\/span> <span class=\"k\">false<\/span><span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<p>\u5f53\u53d1\u51faSQL\u67e5\u8be2\u65f6\uff0c\u5c06\u786e\u8ba4Azure AD\u4e2d\u662f\u5426\u5b58\u5728\u76f8\u5e94\u7684\u7528\u6237\uff08\u670d\u52a1\u4e3b\u4f53\uff09\uff0c\u5e76\u83b7\u53d6\u79df\u6237ID\u7b49\u4fe1\u606f\u5e76\u5b58\u50a8\u5728\u5185\u90e8\u3002<\/p>\n<p>\u7b49\u5f85\u67e5\u8be2\u6b63\u5e38\u5b8c\u6210\u540e\uff0c\u8bf7\u786e\u8ba4\u5b83\u5df2\u6b63\u786e\u521b\u5efa\u3002\u7136\u540e\u6267\u884c\u4e0b\u4e00\u4e2a\u67e5\u8be2\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">pgaadauth_list_principals<\/span><span class=\"p\">(<\/span><span class=\"k\">false<\/span><span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/139-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u518d\u4e4b\u540e,\u4e5f\u8bf7\u60a8\u4f5c\u4e3a\u7528\u6237\u91cd\u65b0\u52a0\u8f7d\u7528\u6237\/\u7ec4\u89d2\u8272\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/141-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u5982\u679c\u4e0d\u518d\u9700\u8981Azure AD\u8ba4\u8bc1\uff0c\u53ea\u9700\u5220\u9664\u5728\u6b64PostgreSQL\u5185\u90e8\u521b\u5efa\u7684\u7528\u6237\u5373\u53ef\u3002<\/p>\n<p>\u5982\u679c\u4e0d\u518d\u9700\u8981Azure AD\u8ba4\u8bc1\uff0c\u53ea\u8981\u5220\u9664\u5728\u8fd9\u4e2aPostgreSQL\u5185\u90e8\u521b\u5efa\u7684\u7528\u6237\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n<p>\u987a\u4fbf\u8bf4\u4e00\u53e5\uff0c\u4e3a\u4ec0\u4e48\u8981\u4f7f\u7528SELECT\u8bed\u53e5\u6765\u521b\u5efa\u7528\u6237\u5462\uff1f\u6211\u8ba4\u4e3a\u5982\u679c\u4ed4\u7ec6\u770bFROM\u5b50\u53e5\uff0c\u4f1a\u53d1\u73b0\u5b57\u7b26\u4e32pgaadauth_create_principal\u548ccreate\u3002\u770b\u8d77\u6765\u8fd9\u662f\u4e00\u4e2a\u7528\u6237\u5b9a\u4e49\u51fd\u6570\uff0c\u5e76\u4e14\u4f7f\u7528SELECT\u8bed\u53e5\u8c03\u7528\u8be5\u51fd\u6570\u3002\u6240\u4ee5\uff0c\u5c3d\u7ba1\u662fSELECT\u8bed\u53e5\uff0c\u5b83\u5374\u53d8\u6210\u4e86\u4e00\u4e2a\uff08\u5fae\u5999\u7684\uff09\u5947\u602a\u7684SQL\u8bed\u53e5\uff0c\u7528\u4e8e\u521b\u5efa\u7528\u6237\u3002<\/p>\n<h3>\u786e\u8ba4<\/h3>\n<p>\u786e\u8ba4\u5df2\u521b\u5efa\u7684\u670d\u52a1\u4e3b\u4f53\u6216\u73b0\u6709\u7684 Azure AD \u7528\u6237\u662f\u5426\u53ef\u4ee5\u4f7f\u7528 Azure AD \u8eab\u4efd\u9a8c\u8bc1\u767b\u5f55\u5230 pgAdmin\u3002<\/p>\n<p>\u670d\u52a1\u4e3b\u4f53\u767b\u5f55\u65f6\uff0c\u4e0eAzure AD\u7ba1\u7406\u5458\u767b\u5f55\u65f6\u4e00\u6837\uff0c\u9700\u8981\u83b7\u53d6\u4ee4\u724c\u3002\u5bf9\u4e8e\u670d\u52a1\u4e3b\u4f53\uff0c\u53ef\u4ee5\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u83b7\u53d6\u4ee4\u724c\u3002<\/p>\n<pre class=\"post-pre\"><code>az <span class=\"nb\">logout\r\n<\/span>az login <span class=\"nt\">--service-principal<\/span> <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">-u<\/span> <span class=\"s2\">\"&lt;appId\/ClientId\/ObjectId&gt;\"<\/span> <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">-p<\/span> <span class=\"s2\">\"&lt;password&gt;\"<\/span> <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">-t<\/span> <span class=\"s2\">\"&lt;tenantId&gt;\"<\/span>\r\n<\/code><\/pre>\n<p>\u5982\u679c\u6307\u5b9a-u\u9009\u9879\uff0c\u5219\u5e94\u8be5\u8fd4\u56de\u521b\u4f5c\u65f6\u8fd4\u56de\u7684\u670d\u52a1\u4e3b\u4f53\u7684appId\uff08\u4e5f\u79f0\u4e3aClientID\uff09\uff0c\u5982\u679c\u662fAzure AD\u7528\u6237\uff0c\u5219\u4e3aObject ID\u3002\u8fd9\u6709\u70b9\u590d\u6742\u3002\u8bf7\u5c06Azure AD\u7684\u79df\u6237ID\u8bbe\u7f6e\u4e3atenantId\u3002<\/p>\n<p>\u5982\u679c\u670d\u52a1\u4e3b\u4f53\u65e0\u6cd5\u767b\u5f55\uff0c\u5219\u53ef\u80fd\u662f\u56e0\u4e3a\u672a\u6388\u4e88\u6743\u9650\u3002\u8bf7\u624b\u52a8\u6388\u4e88\u6743\u9650\u3002<\/p>\n<p>\u5f53\u6210\u529f\u767b\u5f55\u540e\uff0c\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u83b7\u53d6\u4ee4\u724c\u3002<\/p>\n<pre class=\"post-pre\"><code>az account get-access-token <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--resource-type<\/span> oss-rdbms <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--output<\/span> tsv <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--query<\/span> accessToken\r\n<\/code><\/pre>\n<p>\u53ea\u8981\u83b7\u53d6\u4e86\u4ee4\u724c\uff0c\u5176\u4f59\u90fd\u5f88\u7b80\u5355\u3002\u5728\u521b\u5efapgAdmin\u65b0\u7684\u670d\u52a1\u5668\u8fde\u63a5\u65f6\uff0c\u5c06&#8221;\u7acb\u5373\u8fde\u63a5&#8221;\u9009\u9879\u5173\u95ed\uff0c\u5e76\u8bbe\u7f6e\u7528\u6237\u540d\u4e3a\u7528\u6237\u4e3b\u4f53\u540d\u79f0\u6216\u670d\u52a1\u4e3b\u4f53\u540d\u79f0\uff0c\u4fdd\u5b58\u5e76\u8fde\u63a5\u540e\uff0c\u5c06\u5f39\u51fa\u5bc6\u7801\u5bf9\u8bdd\u6846\uff0c\u7136\u540e\u7c98\u8d34\u4ee4\u724c\u5373\u53ef\u767b\u5f55\u3002<\/p>\n<h1>\u9644\u52a0\u4fe1\u606f\uff1a\u4f7f\u7528psql\u901a\u8fc7Azure AD\u8ba4\u8bc1\u767b\u5f55\u3002<\/h1>\n<p>\u6211\u6ca1\u6709\u5728Windows\u4e0a\u5c1d\u8bd5\u8fc7\uff0c\u4f46\u5728Mac\u4e0a\uff0c\u6309\u7167Microsoft\u5b98\u65b9\u63d0\u4f9b\u7684\u65b9\u6cd5\u65e0\u6cd5\u767b\u5f55\u3002<\/p>\n<p>\u5982\u679c\u5df2\u7ecf\u8bbe\u7f6e\u4e86\u7531az login\u767b\u5f55\u7684\u7528\u6237\u53ef\u4ee5\u6210\u4e3aAzure AD\u8ba4\u8bc1\u7528\u6237\uff0c\u5219\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u767b\u5f55\uff1a<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">PGPASSWORD<\/span><span class=\"o\">=<\/span><span class=\"sb\">`<\/span>az account get-access-token <span class=\"nt\">--resource-type<\/span> oss-rdbms <span class=\"nt\">--output<\/span> tsv <span class=\"nt\">--query<\/span> accessToken<span class=\"sb\">`<\/span> <span class=\"se\">\\<\/span>\r\npsql <span class=\"nt\">--host<\/span><span class=\"o\">=<\/span>&lt;your_postgresql_servername&gt;.postgres.database.azure.com <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--user<\/span><span class=\"o\">=<\/span>&lt;your_user_principal_name&gt; <span class=\"nv\">dbname<\/span><span class=\"o\">=<\/span>&lt;dbname&gt; <span class=\"se\">\\<\/span>\r\n<span class=\"nt\">--port<\/span><span class=\"o\">=<\/span>5432\r\n<\/code><\/pre>\n<p>\u770b\u8d77\u6765\u5f88\u590d\u6742\uff0c\u4f46\u662f\u4e0b\u4e00\u4e2a\u90e8\u5206\u4e5f\u53ef\u4ee5\u901a\u8fc7\u83b7\u53d6\u5230\u7684\u4ee4\u724c\u6765\u66ff\u6362\u5e76\u4e14\u80fd\u591f\u6b63\u5e38\u5de5\u4f5c\u3002<\/p>\n<blockquote><p>az \u8d26\u6237 \u83b7\u53d6\u8bbf\u95ee\u4ee4\u724c &#8211;\u8d44\u6e90\u7c7b\u578b oss-rdbms &#8211;\u8f93\u51fa tsv &#8211;\u67e5\u8be2\u8bbf\u95ee\u4ee4\u724c<\/p><\/blockquote>\n<p>\u603b\u4e4b\uff0c\u53ea\u9700\u8981\u5728 PGPASSWORD= \u540e\u9762\u5199\u4e0b Token\uff0c\u5e76\u8fde\u7eed\u5199\u4e0b psql \u7684\u767b\u5f55\u9009\u9879\u5373\u53ef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5f15\u53d1\u6211\u5199\u8fd9\u7bc7\u6587\u7ae0\u7684\u5951\u673a\u662f\u8fd9\u91cc\u7684\u5fae\u8f6f\u5b98\u65b9\u9875\u9762\u3002 \u5728 Azure \u7528\u4e8e PostgreSQL \u7684\u6570\u636e\u5e93\u4e2d\uff0c\u4f7f [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40293","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528spring-boot\u8fde\u63a5\u5230azure-database-for-postgresql\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5f15\u53d1\u6211\u5199\u8fd9\u7bc7\u6587\u7ae0\u7684\u5951\u673a\u662f\u8fd9\u91cc\u7684\u5fae\u8f6f\u5b98\u65b9\u9875\u9762\u3002 \u5728 Azure \u7528\u4e8e PostgreSQL \u7684\u6570\u636e\u5e93\u4e2d\uff0c\u4f7f [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528spring-boot\u8fde\u63a5\u5230azure-database-for-postgresql\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-26T02:30:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T11:55:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/18-0.png\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/\",\"name\":\"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-05-26T02:30:57+00:00\",\"dateModified\":\"2024-04-29T11:55:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528spring-boot\u8fde\u63a5\u5230azure-database-for-postgresql\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL","og_description":"\u9996\u5148 \u5f15\u53d1\u6211\u5199\u8fd9\u7bc7\u6587\u7ae0\u7684\u5951\u673a\u662f\u8fd9\u91cc\u7684\u5fae\u8f6f\u5b98\u65b9\u9875\u9762\u3002 \u5728 Azure \u7528\u4e8e PostgreSQL \u7684\u6570\u636e\u5e93\u4e2d\uff0c\u4f7f [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528spring-boot\u8fde\u63a5\u5230azure-database-for-postgresql\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-26T02:30:57+00:00","article_modified_time":"2024-04-29T11:55:23+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc137434c4406c8fe6c\/18-0.png"}],"author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/","name":"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-05-26T02:30:57+00:00","dateModified":"2024-04-29T11:55:23+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Spring Boot\u8fde\u63a5\u5230Azure Database for PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8spring-boot%e8%bf%9e%e6%8e%a5%e5%88%b0azure-database-for-postgresql%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=40293"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40293\/revisions"}],"predecessor-version":[{"id":87316,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40293\/revisions\/87316"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=40293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=40293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=40293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}