{"id":1505,"date":"2023-02-22T11:15:28","date_gmt":"2023-02-22T03:15:28","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1505"},"modified":"2023-02-22T11:15:28","modified_gmt":"2023-02-22T03:15:28","slug":"%e8%ae%be%e7%bd%aepostgres%e6%9c%80%e5%a4%a7%e8%bf%9e%e6%8e%a5%e6%95%b0-%e8%a7%a3%e5%86%b3odoo%e5%b9%b6%e5%8f%91%e6%8a%a5%e9%94%99","status":"publish","type":"post","link":"\/?p=1505","title":{"rendered":"\u8bbe\u7f6epostgres\u6700\u5927\u8fde\u63a5\u6570-\u89e3\u51b3odoo\u5e76\u53d1\u62a5\u9519"},"content":{"rendered":"<p>\u6b64\u6559\u7a0b\u6848\u4f8bpostgres\u7248\u672c\u4e3a12<\/p>\n<p>\u95ee\u9898\u63cf\u8ff0:<\/p>\n<pre><code>psycopg2.OperationalError: FATAL: sorry, too many clients already on<\/code><\/pre>\n<p>\u65e9\u4e0a\u53d1\u73b0\u6211\u7ef4\u62a4\u7684python\u540e\u7aef\u670d\u52a1\u62a5\u9519\u51fa\u73b0\u4e86\u8fd9\u4e2a\uff0c\u767e\u5ea6 \u4e00\u4e0b\u53d1\u73b0\u662fpostgres\u9ed8\u8ba4\u7684\u6700\u5927\u5e76\u53d1\u53ea\u6709100\uff0c\u5bfc\u81f4\u4e86\u8fd9\u4e2a\u95ee\u9898<\/p>\n<p>\u4fee\u6539\u6559\u7a0b:<\/p>\n<pre><code class=\"language-shell\">cd \/var\/lib\/postgresql\/12\/main\nvi postgresql.auto.conf\n\n# \u5728\u6587\u4ef6\u4e2d\u589e\u52a0\u4e0b\u9762\u4e00\u884c\u4ee3\u7801,\u8bbe\u7f6e\u6700\u5927\u8fde\u63a5\u6570\u4e3a800,\u9ed8\u8ba4\u4e3a100\nmax_connections = 800\n\n# \u91cd\u542f\u670d\u52a1\nservice postgresql restart<\/code><\/pre>\n<p>\u4e0b\u9762\u662fsql\u547d\u4ee4\u8fdb\u884c\u68c0\u6d4b\u662f\u5426\u4fee\u6539\u6210\u529f:<\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/image-20230222105325947.png\" alt=\"image-20230222105325947\" \/><\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5pma6aOO5ouC5p-z6aKc,size_20,color_FFFFFF,t_70,g_se,x_16.png\" alt=\"img\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6b64\u6559\u7a0b\u6848\u4f8bpostgres\u7248\u672c\u4e3a12 \u95ee\u9898\u63cf\u8ff0: psycopg2.OperationalError: FATAL: sorry, to   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[36],"tags":[],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1505"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1505"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1505\/revisions"}],"predecessor-version":[{"id":1506,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1505\/revisions\/1506"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1505"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}