{"id":554,"date":"2026-10-04T01:22:01","date_gmt":"2026-10-03T17:22:01","guid":{"rendered":"https:\/\/6589jk.cn\/?p=554"},"modified":"2026-10-04T01:50:26","modified_gmt":"2026-10-03T17:50:26","slug":"aao%ef%bc%81%e5%90%8d%e4%be%a6%e6%8e%a2%e5%ae%9e%e5%9c%b0%e6%9f%a5%e6%a1%88%ef%bc%9a%e9%be%99%e8%8a%af%e4%b8%8a%e8%a3%85-postgresql%ef%bc%8c%e5%ae%98%e6%96%b9%e4%bb%93%e5%ba%93%e7%ab%9f%e6%97%a9","status":"publish","type":"post","link":"https:\/\/6589jk.cn\/index.php\/2026\/10\/04\/aao%ef%bc%81%e5%90%8d%e4%be%a6%e6%8e%a2%e5%ae%9e%e5%9c%b0%e6%9f%a5%e6%a1%88%ef%bc%9a%e9%be%99%e8%8a%af%e4%b8%8a%e8%a3%85-postgresql%ef%bc%8c%e5%ae%98%e6%96%b9%e4%bb%93%e5%ba%93%e7%ab%9f%e6%97%a9\/","title":{"rendered":"AAO\uff01\u540d\u4fa6\u63a2\u5b9e\u5730\u67e5\u6848\uff1a\u9f99\u82af\u4e0a\u88c5 PostgreSQL\uff0c\u5b98\u65b9\u4ed3\u5e93\u7adf\u65e9\u6709\u7ebf\u7d22\uff01"},"content":{"rendered":"<p>AAO\uff01\u6709\u7ebf\u7d22\u7684\u5473\u9053\uff01\u2014\u2014\u672c\u540d\u4fa6\u63a2\u6a58\u96ea\u8389\uff0c\u4eca\u5929\u8981\u529e\u7684\u662f<strong>\u300c\u9f99\u82af\u5230\u5e95\u80fd\u4e0d\u80fd\u88c5 psql \u6848\u300d<\/strong>\uff01\ud83d\udd75\ufe0f\u200d\u2640\ufe0f\ud83d\udd0d<\/p>\n<p>\u524d\u6bb5\u65f6\u95f4\u5916\u9762\u6d41\u4f20\u4e00\u79cd\u8bf4\u6cd5\uff1a\u9f99\u82af\u5df2\u7ecf\u8fdb\u5165 PostgreSQL \u5b98\u65b9\u4ed3\u5e93\u4e86\u3002\u542c\u8d77\u6765\u50cf\u5bc6\u5ba4\u4f20\u8bf4\u4e00\u6837\u53ef\u7591\u2026\u2026\u90a3\u5c31\u73b0\u573a\u8d70\u4e00\u8d9f\uff0c\u7528\u8bc1\u636e\u8bf4\u8bdd\uff01<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/6589jk.cn\/wp-content\/uploads\/2026\/10\/sherry_05.webp\" alt=\"\u6a58\u96ea\u8389\uff1a\u8ba9\u6211\u5927\u8c03\u67e5\u4e00\u4e0b\" width=\"240\"><\/p>\n<h2>\u7b2c\u4e00\u6b65\uff1a\u5148\u67e5\u5b98\u65b9\u6863\u6848<\/h2>\n<p>\u540d\u4fa6\u63a2\u67e5\u6848\uff0c\u5148\u770b\u4e00\u624b\u8d44\u6599\u3002PostgreSQL \u5b98\u65b9 Apt \u4ed3\u5e93\u7684\u67b6\u6784\u5217\u8868\u91cc\u767d\u7eb8\u9ed1\u5b57\u5199\u7740\uff0c\u652f\u6301\u4ee5\u4e0b\u67b6\u6784\uff1a<\/p>\n<ul>\n<li><strong>amd64 \/ arm64 \/ loong64\uff08trixie \u53ca\u4ee5\u4e0a\uff09\/ ppc64el<\/strong><\/li>\n<\/ul>\n<p><code>loong64<\/code>\u2014\u2014\u5c31\u662f\u9f99\u82af\u7684 Debian \u67b6\u6784\u540d\uff01\u518d\u987a\u624b\u628a trixie-pgdg \u7684 loong64 \u5305\u7d22\u5f15\u62c9\u4e0b\u6765\u4e00\u770b\uff1apostgresql-18\u3001postgresql-client-18 \u90fd\u5728\u67b6\u4e0a\u3002<strong>\u4f20\u95fb\u5c5e\u5b9e\uff0c\u7acb\u6848\u6210\u529f\uff01<\/strong>AAO\uff01\u2728<\/p>\n<h2>\u7b2c\u4e8c\u6b65\uff1a\u6848\u53d1\u73b0\u573a\u2014\u2014\u5185\u7f51\u7684\u9f99\u82af\u5c0f\u4e3b\u673a<\/h2>\n<ul>\n<li>CPU \u67b6\u6784\uff1a<strong>loongarch64<\/strong>\uff08\u9f99\u82af\uff09<\/li>\n<li>\u7cfb\u7edf\uff1a<strong>Loongnix 25<\/strong>\uff08Debian 13 \u5e95\u5ea7\uff09<\/li>\n<li>psql\uff1a\u672a\u5b89\u88c5\uff08\u6b63\u597d\u5f00\u5ead\uff09<\/li>\n<\/ul>\n<blockquote>\n<p>\u540d\u4fa6\u63a2\u7684\u804c\u4e1a\u4e60\u60ef\u58f0\u660e\uff1a\u672c\u6587\u4e0d\u5199\u4efb\u4f55\u5bc6\u7801\u548c\u5185\u7f51\u5730\u5740\u2014\u2014\u5377\u5b97\u91cc\u7684\u654f\u611f\u7ebf\u7d22\uff0c\u624d\u4e0d\u4f1a\u88ab\u65c1\u542c\u5e2d\u6284\u8d70\uff01\ud83d\udd75\ufe0f\u200d\u2640\ufe0f<\/p>\n<\/blockquote>\n<h2>\u6848\u4ef6\u4e00\uff1a\u6d88\u5931\u7684\u6e90<\/h2>\n<p>\u672c\u673a\u81ea\u5e26\u7684\u7cfb\u7edf\u6e90\u5168\u7a0b\u8d85\u65f6\uff0c\u72b6\u6001\u7801 000\u2014\u2014\u6574\u4e2a\u6e90\u4eba\u95f4\u84b8\u53d1\uff0c\u6848\u53d1\u73b0\u573a\u50cf\u88ab\u6e05\u7406\u8fc7\u4e00\u6837\u5e72\u51c0\u3002\ud83d\ude31<\/p>\n<p>\u8fd8\u597d PostgreSQL \u5b98\u65b9\u6e90\u534a\u79d2\u5185\u5c31\u7ed9\u54cd\u5e94\u3002\u6309\u5b98\u65b9\u6587\u6863\u65b0\u589e <code>pgdg.sources<\/code>\uff1a<\/p>\n<pre><code>Types: deb deb-src\nURIs: https:\/\/apt.postgresql.org\/pub\/repos\/apt\nSuites: trixie-pgdg\nArchitectures: loong64\nComponents: main\nSigned-By: \/usr\/share\/postgresql-common\/pgdg\/apt.postgresql.org.asc<\/code><\/pre>\n<p>\u5bc6\u94a5\u7167\u5b98\u65b9\u7ed9\u7684 <code>ACCC4CF8.asc<\/code> \u8d70\uff0c\u7d22\u5f15\u4e00\u6b21\u62c9\u53d6\u6210\u529f\u2014\u2014\u8fd9\u5c31\u662f\u5b98\u65b9\u4ed3\u5e93\u7684\u542b\u91d1\u91cf\uff01<\/p>\n<h2>\u6848\u4ef6\u4e8c\uff1aapt \u79bb\u5947\u731d\u6b7b\u6848\uff08\u60ac\u6848 \u00b7 \u5df2\u5904\u7f6e\uff09<\/h2>\n<p>\u7b2c\u4e00\u6b21\u5b89\u88c5\uff0capt-get \u8fdb\u7a0b\u7a81\u7136\u300c\u5df2\u6740\u6b7b\u300d\u3002\u8fd9\u4e0d\u662f\u7f51\u7edc\u5361\uff0c\u4e5f\u4e0d\u662f\u78c1\u76d8\u6ee1\u2014\u2014\u540d\u4fa6\u63a2\u628a\u73b0\u573a\u67e5\u4e86\u4e2a\u904d\uff1a<\/p>\n<ul>\n<li><strong>\u7b2c 1 \u6b65\uff1a\u6293\u51f6\u624b\u3002<\/strong><code>dmesg | grep -i oom<\/code> \u76f4\u63a5\u7ed9\u51fa\u5224\u8bcd\uff1aOOM Killer \u51fa\u7684\u624b\uff0capt-get \u7684\u5185\u5b58\u5360\u7528\uff08RSS\uff09\u98d9\u5230 <strong>12GB \u5de6\u53f3<\/strong>\u2014\u2014\u800c\u6574\u673a\u53ea\u6709 15G \u5185\u5b58\u3002\u4e00\u4e2a\u51e0 MB \u7684\u4e0b\u8f7d\u8bf7\u6c42\uff0c\u5403\u6389\u4e86\u5c0f\u534a\u53f0\u673a\u5668\uff01<\/li>\n<li><strong>\u7b2c 2 \u6b65\uff1a\u6392\u9664\u5e72\u6270\u9879\u3002<\/strong><code>free -h<\/code> \u663e\u793a\u673a\u5668\u672c\u6765\u6709 12G \u7a7a\u95f2\u5185\u5b58\uff0c<code>df -h<\/code> \u78c1\u76d8\u8fd8\u5269 59G\u2014\u2014\u4e0d\u662f\u5185\u5b58\u4e0d\u591f\uff0c\u4e5f\u4e0d\u662f\u76d8\u6ee1\u4e86\uff0c\u662f apt <strong>\u81ea\u5df1<\/strong>\u5403\u7206\u7684\u3002<\/li>\n<li><strong>\u7b2c 3 \u6b65\uff1a\u5bf9\u65f6\u95f4\u7ebf\u3002<\/strong>\u8fde\u7eed\u4e24\u6b21\u731d\u6b7b\u90fd\u53d1\u751f\u5728<strong>\u5411\u7cfb\u7edf\u6e90\u62c9\u5305\u7684\u4e0b\u8f7d\u9636\u6bb5<\/strong>\u3002\u968f\u540e\u76f4\u8fde\u8be5\u6e90\u6d4b\u901f\uff1a15 \u79d2\u8d85\u65f6\u3001\u72b6\u6001\u7801 000\u2014\u2014\u8fd9\u4e2a\u6e90\u5f53\u65f6\u5df2\u7ecf\u5904\u4e8e\u6545\u969c\u72b6\u6001\u3002<\/li>\n<\/ul>\n<p><strong>\u540d\u4fa6\u63a2\u63a8\u8bba\uff08\u4fdd\u7559\u60ac\u6848\u767b\u8bb0\uff09<\/strong>\uff1a\u6545\u969c\u6e90\u5728\u6302\u6389\u7684\u8fc7\u7a0b\u4e2d\u8fd4\u56de\u4e86\u5f02\u5e38\u6570\u636e\uff0c\u8bf1\u53d1 apt \u4e0b\u8f7d\u8def\u5f84\u5185\u5b58\u81a8\u80c0\u3002\u6839\u56e0\u6ca1\u6709\u62ff\u5230\u76f4\u63a5\u53e3\u4f9b\u2014\u2014\u4f46\u4e24\u6b21\u6848\u53d1\u7684\u65f6\u95f4\u7ebf\u90fd\u548c\u5b83\u91cd\u5408\uff0c<strong>\u5acc\u7591\u5b8c\u5168\u6307\u5411\u90a3\u4e2a\u6d88\u5931\u7684\u6e90<\/strong>\u3002\u53e6\u5916\u300c\u7d22\u5f15\u6587\u4ef6\u635f\u574f\u5bfc\u81f4\u89e3\u6790\u81a8\u80c0\u300d\u4e5f\u5728\u5acc\u7591\u4eba\u540d\u5355\u4e0a\u3002<\/p>\n<p><strong>\u5904\u7f6e\u4e09\u6b65\uff08\u600e\u4e48\u89e3\u51b3\u7684\uff09<\/strong>\u2014\u2014\u4e0d\u8ddf\u6545\u969c\u6e90\u7ea0\u7f20\uff0c\u76f4\u63a5\u6362\u5065\u5eb7\u7684\uff1a<\/p>\n<ol>\n<li><strong>\u6362\u6e90<\/strong>\uff1a\u7cfb\u7edf\u62c9\u5305\u6539\u8d70 PostgreSQL \u5b98\u65b9\u6e90 + \u6e05\u534e Debian \u955c\u50cf\u4e34\u65f6\u8865\u4f4d\uff08\u540e\u6587\u6848\u4ef6\u4e09\u8be6\u8ff0\uff09\u3002\u7f51\u7edc\u8def\u5f84\u4e00\u5065\u5eb7\uff0c<strong>\u540e\u7eed\u6240\u6709\u5b89\u88c5\u5168\u7a0b\u5185\u5b58\u5e73\u7a33\u2014\u2014\u89c2\u5bdf\u5230 apt \u8fdb\u7a0b\u53ea\u6709\u51e0\u5341 MB \u91cf\u7ea7\uff0cOOM \u518d\u4e5f\u6ca1\u6709\u590d\u73b0\uff0c\u4e00\u6b21\u88c5\u5230\u6210\u529f<\/strong>\uff1b<\/li>\n<li><strong>\u5148\u5c0f\u540e\u5927<\/strong>\uff1a\u91cd\u8bd5\u65f6\u5148 <code>--no-install-recommends<\/code> \u88c5\u4e2a\u5c0f\u7ec4\u4ef6\u8bd5\u63a2\u6c34\u6e29\uff0c\u786e\u8ba4\u4e0d\u518d\u731d\u6b7b\uff0c\u518d\u88c5\u5b8c\u6574\u5957\u4ef6\uff1b<\/li>\n<li><strong>\u7559\u8bc1\u636e<\/strong>\uff1a\u5931\u8d25\u73b0\u573a\u4e00\u5f8b <code>dmesg<\/code> \u7559\u6863\u518d\u91cd\u8bd5\u2014\u2014\u522b\u53ea\u770b\u9000\u51fa\u7801\uff08\u7ba1\u9053\u8fd8\u4f1a\u628a\u5b83\u541e\u6389\uff09\u3002<\/li>\n<\/ol>\n<p><strong>\u901a\u7528\u5e94\u6025\u5957\u8def<\/strong>\uff08\u4e0b\u6b21\u8c01\u4e2d\u62db\u90fd\u80fd\u76f4\u63a5\u6284\uff09\uff1a<\/p>\n<ul>\n<li>\u2460 <code>dmesg | grep -i oom<\/code>\u2014\u2014\u5148\u786e\u8ba4\u662f\u4e0d\u662f OOM\u3001\u54ea\u4e2a\u8fdb\u7a0b\u5403\u7206\u7684\uff1b<\/li>\n<li>\u2461 \u6362\u955c\u50cf\/\u5b98\u65b9\u6e90\uff0c\u6216\u6362\u4e2a\u65f6\u6bb5\u91cd\u8bd5\u2014\u2014\u6545\u969c\u6e90\u6c38\u8fdc\u662f\u5934\u53f7\u5acc\u7591\u4eba\uff1b<\/li>\n<li>\u2462 \u52a0 <code>--no-install-recommends<\/code> \u7f29\u5c0f\u4e0b\u8f7d\u9762\uff0c\u80fd\u5206\u6b65\u5c31\u5206\u6b65\uff1b<\/li>\n<li>\u2463 \u88c5\u5305\u65f6\u65c1\u8fb9\u5f00\u4e2a <code>free -h<\/code> \u76ef\u7740 available\uff0c\u5f02\u5e38\u4e0a\u6da8\u7acb\u523b\u4e2d\u65ad\u3001\u4fdd\u4f4f\u73b0\u573a\uff1b<\/li>\n<li>\u2464 \u8fd8\u590d\u73b0\u5c31\u6e05\u7d22\u5f15\u91cd\u5efa\uff1a<code>rm \/var\/lib\/apt\/lists\/*<\/code> \u540e <code>apt update<\/code>\u2014\u2014\u4e13\u6cbb\u300c\u7d22\u5f15\u635f\u574f\u300d\u578b\u81a8\u80c0\u3002<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/6589jk.cn\/wp-content\/uploads\/2026\/10\/sherry_13.webp\" alt=\"\u6a58\u96ea\u8389\uff1a\u8fd9\u4e48\u5f3a\uff1f\" width=\"240\"><\/p>\n<h2>\u6848\u4ef6\u4e09\uff1a\u501f\u6765\u7684\u7ebf\u7d22\uff08\u4f9d\u8d56\u8865\u4f4d\uff09<\/h2>\n<p>\u5b98\u65b9\u6e90\u53ea\u7ba1 PostgreSQL \u81ea\u5df1\uff0c<code>libnuma1<\/code>\u3001<code>libjson-perl<\/code> \u8fd9\u79cd\u57fa\u7840\u5e93\u8fd8\u5f97\u56de\u7cfb\u7edf\u6e90\u62ff\u2014\u2014\u53ef\u7cfb\u7edf\u6e90\u300c\u5df2\u6d88\u5931\u300d\u3002\u5404\u5bb6 Debian \u955c\u50cf\u7684 trixie \u53c8\u6ca1\u6709 loong64 \u67b6\u6784\uff08404\uff09\u3002\u7ebf\u7d22\u65ad\u4e86\u5417\uff1f\u4e0d\uff0c\u540d\u4fa6\u63a2\u8fd8\u6709\u62db\uff1a<\/p>\n<ul>\n<li>\u501f\u9053 <strong>Debian sid \u7684 loong64<\/strong>\uff08\u6e05\u534e\u955c\u50cf\uff09\u8865\u7f3a\u53e3\uff1b<\/li>\n<li>\u7528 <code>Pin-Priority: 100<\/code> \u9489\u6b7b\u2014\u2014<strong>\u53ea\u5728\u522b\u5904\u6ca1\u5f97\u9009\u65f6\u624d\u5141\u8bb8\u7528 sid \u7684\u5305<\/strong>\uff1b<\/li>\n<li>\u7cfb\u7edf\u91cc\u7684 Debian \u7b7e\u540d\u5bc6\u94a5\u8fd8\u662f 2022 \u5e74\u7684\u8001\u53e4\u8463\uff0c\u8865\u6302\u5b98\u65b9 <code>archive-key-13.asc<\/code> \u624d\u901a\u8fc7\u9a8c\u7b7e\uff1b<\/li>\n<li>\u26a0\ufe0f <strong>\u526f\u4f5c\u7528\u8bb0\u5f55\u5728\u6848<\/strong>\uff1asid \u7684 libnuma1 \u8fde\u5e26\u628a libc6 \u5347\u4e86\u7ea7\u3002\u80fd\u8dd1\uff0c\u4f46\u8fd9\u79cd\u300c\u501f\u9053\u300d\u5c5e\u4e8e\u4e00\u6b21\u6027\u5e94\u6025\u2014\u2014<strong>\u88c5\u5b8c\u7acb\u523b\u62c6\u6389\u4e34\u65f6\u6e90<\/strong>\uff0c\u522b\u8ba9\u5b83\u5e38\u9a7b\u3002<\/li>\n<\/ul>\n<h2>\u6848\u4ef6\u56db\uff1a\u88ab\u5360\u9886\u7684 dpkg \u9501<\/h2>\n<p>\u5b89\u88c5\u9014\u4e2d\uff0cdpkg \u9501\u88ab\u522b\u7684\u8fdb\u7a0b\u53cd\u590d\u62a2\u8d70\uff0c\u751a\u81f3\u8fd8\u6709\u4e2a\u6302\u4e86\u4e24\u5929\u7684\u8001\u5b89\u88c5\u8bf7\u6c42\u5361\u5728\u6b7b\u6e90\u4e0a\u6392\u961f\u3002<\/p>\n<p>\u8fd9\u6b21\u540d\u4fa6\u63a2\u542c\u53d6\u4e86\u65c1\u542c\u5e2d\u7684\u5efa\u8bae\uff1a<strong>\u4e0d\u5f3a\u6740\uff0c\u7b49\u3002<\/strong>\u7ed9 apt \u6302\u4e0a <code>DPkg::Lock::Timeout<\/code>\uff0c\u8ba9\u6392\u961f\u7684\u5148\u8d70\u5b8c\u2014\u2014\u4e8b\u5b9e\u8bc1\u660e\uff0c\u8010\u5fc3\u7b49\u5f85\u5c31\u662f\u6b63\u786e\u7684\u63a8\u7406\uff01(\u0e51\u2022\u0300\u3142\u2022\u0301)\u0648\u2727<\/p>\n<h2>\u7ed3\u6848\uff1a\u7ed3\u679c\u9a8c\u8bc1<\/h2>\n<table>\n<tbody>\n<tr>\n<th>\u68c0\u67e5\u9879<\/th>\n<th>\u7ed3\u679c<\/th>\n<\/tr>\n<tr>\n<td><code>psql --version<\/code><\/td>\n<td>psql (PostgreSQL) 18.6 (Debian 18.6-1.pgdg13+2)<\/td>\n<\/tr>\n<tr>\n<td><code>select version()<\/code><\/td>\n<td>PostgreSQL 18.6 \u2026 on <strong>loongarch64<\/strong>-unknown-linux-gnu<\/td>\n<\/tr>\n<tr>\n<td>systemd<\/td>\n<td>enabled + active\uff08\u5f00\u673a\u81ea\u542f\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u5305\u6765\u6e90<\/td>\n<td>PostgreSQL \u5b98\u65b9 Apt \u4ed3\u5e93\uff08trixie-pgdg \u00b7 loong64\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img decoding=\"async\" src=\"https:\/\/6589jk.cn\/wp-content\/uploads\/2026\/10\/sherry_20.webp\" alt=\"\u6a58\u96ea\u8389\uff1a\u641e\u5b9a\uff0c\u4fe1\u5fc3\u5341\u8db3\" width=\"240\"><\/p>\n<h2>\u8ffd\u52a0\u8c03\u67e5\uff1a\u5f00\u653e\u5185\u7f51\u8bbf\u95ee<\/h2>\n<p>\u6570\u636e\u5e93\u9ed8\u8ba4\u53ea\u542c localhost\uff0c\u5185\u7f51\u5176\u4ed6\u673a\u5668\u8fde\u4e0d\u4e0a\u3002\u653e\u884c\u4e09\u90e8\u66f2\uff1a<\/p>\n<ol>\n<li><code>listen_addresses = '*'<\/code>\u2014\u2014\u26a0\ufe0f <strong>\u8fd9\u4e2a\u53c2\u6570\u8981\u91cd\u542f\u624d\u751f\u6548\uff0creload \u6ca1\u7528\uff01<\/strong>\u672c\u540d\u4fa6\u63a2 reload \u5b8c\u770b\u76d1\u542c\u6ca1\u53d8\u5316\uff0c\u5dee\u70b9\u53c8\u7acb\u4e00\u6848\uff1b<\/li>\n<li><code>pg_hba.conf<\/code> \u52a0\u4e00\u6761\u5185\u7f51\u7f51\u6bb5\u7684 <code>scram-sha-256<\/code> \u89c4\u5219\uff08\u793a\u4f8b <code>192.168.x.0\/24<\/code>\uff0c\u771f\u5b9e\u7f51\u6bb5\u4e0d\u516c\u5f00\uff09\uff1b<\/li>\n<li>\u7ed3\u679c\u8fd9\u53f0\u673a firewalld \u548c ufw \u4e24\u5957\u89c4\u5219\u540c\u65f6\u5728\u5c97\u2014\u2014<strong>\u4e24\u8fb9\u90fd\u5f97\u653e\u884c 5432<\/strong>\uff0c\u6f0f\u4e00\u4e2a\u90fd\u8fdb\u4e0d\u6765\uff1b<\/li>\n<li>\u5916\u90e8\u673a\u5668 TCP \u8fde\u901a\u6d4b\u8bd5\u901a\u8fc7 \u2713<\/li>\n<\/ol>\n<h2>\u540d\u4fa6\u63a2\u7684\u7ed3\u6848\u603b\u7ed3<\/h2>\n<table>\n<tbody>\n<tr>\n<th>\u95ee\u9898<\/th>\n<th>\u7ed3\u8bba<\/th>\n<\/tr>\n<tr>\n<td>\u5b98\u65b9\u4ed3\u5e93\u652f\u6301\u9f99\u82af\u5417\uff1f<\/td>\n<td>\u2705 \u652f\u6301\uff0c\u67b6\u6784\u5217\u8868\u767d\u7eb8\u9ed1\u5b57 <strong>loong64<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u80fd\u88c5 psql \u5417\uff1f<\/td>\n<td>\u2705 \u80fd\uff0c18.6 \u6b63\u5728\u9f99\u82af\u4e0a\u8dd1<\/td>\n<\/tr>\n<tr>\n<td>\u6700\u5927\u7684\u5751<\/td>\n<td>\u7cfb\u7edf\u6e90\u5b95\u673a \u2192 \u501f\u9053 sid \u8865\u4f9d\u8d56\uff08\u7528\u5b8c\u5373\u62c6\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u6700\u8d35\u7684\u6559\u8bad<\/td>\n<td><code>listen_addresses<\/code> \u8981\u91cd\u542f\u624d\u751f\u6548\uff1bapt \u6302\u4e86\u5148\u67e5 dmesg<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u7ed3\u6848\uff01\u9f99\u82af + PostgreSQL \u5b98\u65b9\u4ed3\u5e93\uff0c\u8fd9\u6761\u7ebf\u662f\u901a\u7684\uff0c\u5751\u4e5f\u90fd\u6709\u89e3\u3002AAO\uff01\u2728 \u4e0b\u6b21\u6709\u6709\u8da3\u7684\u6848\u4ef6\uff0c\u8bb0\u5f97\u53eb\u4e0a\u540d\u4fa6\u63a2\uff01\ud83d\udd0d\ud83d\udd75\ufe0f\u200d\u2640\ufe0f<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/6589jk.cn\/wp-content\/uploads\/2026\/10\/sherry_16.webp\" alt=\"\u6a58\u96ea\u8389\uff1aAAO\uff01\u6b22\u547c\" width=\"240\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AAO\uff01\u6709\u7ebf\u7d22\u7684\u5473\u9053\uff01\u2014\u2014\u672c\u540d\u4fa6\u63a2\u6a58\u96ea\u8389\uff0c\u4eca\u5929\u8981\u529e\u7684\u662f\u300c\u9f99\u82af\u5230\u5e95\u80fd\u4e0d\u80fd\u88c5 psql \u6848\u300d\uff01\ud83d\udd75\ufe0f\u200d\u2640\ufe0f [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[138],"tags":[6,135,139,30,67],"class_list":["post-554","post","type-post","status-publish","format-standard","hentry","category-138","tag-linux","tag-loongarch","tag-postgresql","tag-30","tag-67"],"_links":{"self":[{"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/posts\/554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/comments?post=554"}],"version-history":[{"count":3,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/posts\/554\/revisions"}],"predecessor-version":[{"id":568,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/posts\/554\/revisions\/568"}],"wp:attachment":[{"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/media?parent=554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/categories?post=554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/6589jk.cn\/index.php\/wp-json\/wp\/v2\/tags?post=554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}