{"id":42089,"date":"2023-09-28T23:10:44","date_gmt":"2023-03-14T02:23:42","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/"},"modified":"2024-05-04T01:59:15","modified_gmt":"2024-05-03T17:59:15","slug":"%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/","title":{"rendered":"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236"},"content":{"rendered":"<p>\u56e0\u4e3a\u88ab\u544a\u77e5\u300c\u867d\u7136\u53ea\u6709\u4e00\u53f0\u5b9e\u9645\u670d\u52a1\u5668\u4f5c\u4e3a\u5f00\u53d1\u73af\u5883\uff0c\u4f46\u662f\u8bf7\u521b\u5efa\u4e00\u4e2a\u53ef\u4ee5\u5728\u4e24\u53f0\u751f\u4ea7\u73af\u5883\u4e2d\u826f\u597d\u540c\u6b65\u7684\u673a\u5236\u300d\uff0c\u6240\u4ee5\u5728\u5c1d\u8bd5\u4e86\u5404\u79cd\u65b9\u6cd5\u540e\uff0c\u9009\u62e9\u4e86\u5176\u4e2d\u4e00\u79cd\u65b9\u6848\u3002<br \/>\n\u7531\u4e8e\u6211\u662fPostgreSQL\u548cDocker\u7684\u65b0\u624b\uff0c\u4f46\u662f\u6211\u8bbe\u6cd5\u8ba9\u5b83\u4eec\u80fd\u591f\u6b63\u5e38\u5de5\u4f5c\uff0c\u6240\u4ee5\u5728\u90a3\u4e2a\u65f6\u5019\u8bb0\u5f55\u4e0b\u4e86\u7ed3\u679c\u3002<br \/>\n\u7531\u4e8e\u6211\u7684\u60c5\u51b5\u53ef\u80fd\u5b58\u5728\u9519\u8bef\uff0c\u8bf7\u8c05\u89e3\u3002<\/p>\n<h1>\u60f3\u8981\u505a\u7684\u4e8b\u60c5<\/h1>\n<p>\u56e0\u4e3a\u60f3\u8981\u5236\u9020\u4e00\u4e2a\u771f\u5b9e\u7684\u6c1b\u56f4\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">CentOS7<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">PostgreSQL10.3<\/ul>\n<p>\u6211\u60f3\u8981\u4ee5\u4e24\u53f0\u670d\u52a1\u5668\u7684\u5f62\u5f0f\u6765\u6784\u5efa\u5b83\uff08\u4e0d\u4ec5\u7528\u4f5cPostgreSQL\u670d\u52a1\u5668\uff0c\u800c\u4e14\u4f5c\u4e3a\u5f00\u53d1\u670d\u52a1\u5668\u4f7f\u7528\uff0c\u6240\u4ee5\u8fd9\u4e2a\u914d\u7f6e\uff09\u3002<\/p>\n<h1>\u9884\u5148\u7684\u72b6\u6001<\/h1>\n<p>\u7531\u4e8e\u4e0d\u518d\u9700\u8981\u51c6\u5907\u5b9e\u673a\u8fdb\u884c\u64cd\u4f5c\uff0c\u53ef\u4ee5\u4f7f\u7528\u81ea\u5df1\u7684IDCF\u4e91\uff08Ubuntu16.04\uff09\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<p>Docker\u7684\u5b89\u88c5\u65b9\u5f0f\u53ea\u662f\u76f4\u63a5\u6309\u7167\u5b98\u65b9\u6587\u6863\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<h1>\u521b\u5efaDocker\u5bb9\u5668<\/h1>\n<h3>\u4e3b\u63a7\u7aef<\/h3>\n<p>\u5c3d\u7ba1\u6211\u5df2\u7ecf\u591a\u6b21\u9047\u5230\u8fd9\u4e2a\u95ee\u9898\uff0c\u4f46\u662f\u5728Docker\u4e2d\u521b\u5efaCentOS7\u65f6\uff0c\u8fd8\u662f\u9700\u8981\u4f7f\u7528systemd\u547d\u4ee4\u548cservice\u547d\u4ee4\u3002<\/p>\n<pre class=\"post-pre\"><code>Failed to get D-Bus connection: Operation not permitted\r\n<\/code><\/pre>\n<p>\u7531\u65bc\u8a72\u7a0b\u5f0f\u7121\u6cd5\u555f\u52d5\uff0c\u8acb\u53c3\u8003\u4ee5\u4e0b\u9023\u7d50\u9032\u884c\u64cd\u4f5c\uff1a<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"Qa4QlRDXKo\"><p><a href=\"https:\/\/blog.adachin.me\/archives\/3588\">[Docker]\u30b3\u30f3\u30c6\u30caCentOS7\/Ubuntu\u306esystemctl\u3067service\u304c\u8d77\u52d5\u3057\u306a\u3044\u5834\u5408<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;[Docker]\u30b3\u30f3\u30c6\u30caCentOS7\/Ubuntu\u306esystemctl\u3067service\u304c\u8d77\u52d5\u3057\u306a\u3044\u5834\u5408&#8221; &#8212; ADACHIN SERVER LABO\" src=\"https:\/\/blog.adachin.me\/archives\/3588\/embed#?secret=b4vnxQBJ4e#?secret=Qa4QlRDXKo\" data-secret=\"Qa4QlRDXKo\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># \u3064\u306a\u304e\u3084\u3059\u3044\u3088\u3046\u306b\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u8a2d\u5b9a\u3092\u5165\u308c\u308b<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>docker network create <span class=\"nt\">--driver<\/span> bridge psql\r\n<span class=\"c\"># privileged\u3068\/sbin\/init\u304c\u30ad\u30e2\u3000\u4eca\u56de\u306e\u5185\u5bb9\u7684\u306b\u306f-p\u306e\u30dd\u30fc\u30c8\u30d5\u30a9\u30ef\u30fc\u30c9\u306f\u5fc5\u8981\u306a\u304b\u3063\u305f\u3063\u307d\u3044<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>docker run <span class=\"nt\">--privileged<\/span> <span class=\"nt\">--name<\/span><span class=\"o\">=<\/span>postgresql1 <span class=\"nt\">--net<\/span><span class=\"o\">=<\/span>psql <span class=\"nt\">-d<\/span> <span class=\"nt\">-p<\/span> 5431:5432 <span class=\"nt\">-p<\/span> 8000:80 centos \/sbin\/init\r\n<span class=\"c\"># bash\u3067\u5165\u3063\u3066\u307f\u308b<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>docker <span class=\"nb\">exec<\/span> <span class=\"nt\">-it<\/span> postgresql1 \/bin\/bash\r\n<\/code><\/pre>\n<h3>\u5974\u96b6\u65b9<\/h3>\n<p>\u786e\u4fdd\u540d\u79f0\u548c\u7aef\u53e3\u8f6c\u53d1\u7684\u8bbe\u7f6e\u4e0d\u91cd\u53e0\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>docker run <span class=\"nt\">--privileged<\/span> <span class=\"nt\">--name<\/span><span class=\"o\">=<\/span>postgresql2 <span class=\"nt\">--net<\/span><span class=\"o\">=<\/span>psql <span class=\"nt\">-d<\/span> <span class=\"nt\">-p<\/span> 5433:5432 <span class=\"nt\">-p<\/span> 8080:80 centos \/sbin\/init\r\n<\/code><\/pre>\n<h1>\u51c6\u5907 PostgreSQL \u670d\u52a1\u5668\uff08\u4e3b\u4ece\u5171\u7528\uff09<\/h1>\n<p>\u5728\u8865\u5145\u4e86\u7f3a\u5931\u7684\u547d\u4ee4\u540e\uff0c\u53c2\u8003\u4e0b\u9762\u7684\u94fe\u63a5\u8fdb\u884c\u64cd\u4f5c\uff0c\u51e0\u4e4e\u662f\u5b8c\u5168\u7167\u642c\u6267\u884c\u3002<br \/>\nhttps:\/\/weblabo.oscasierra.net\/postgresql10-centos7-install\/<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># service\u30b3\u30de\u30f3\u30c9\u7b49\u304c\u306a\u304f\u3066\u56f0\u308b\u306e\u3067<\/span>\r\nyum <span class=\"nt\">-y<\/span> <span class=\"nb\">install <\/span>initscripts <span class=\"o\">&amp;&amp;<\/span> yum clean all\r\n<span class=\"c\"># wget\u3092\u5165\u308c\u308b<\/span>\r\nyum <span class=\"nt\">-y<\/span> <span class=\"nb\">install <\/span>wget\r\n\r\nwget https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-centos10-10-2.noarch.rpm\r\nyum <span class=\"nt\">-y<\/span> localinstall pgdg-centos10-10-2.noarch.rpm\r\nyum <span class=\"nt\">-y<\/span> <span class=\"nb\">install <\/span>postgresql10-server\r\n\/usr\/pgsql-10\/bin\/postgresql-10-setup initdb\r\nsystemctl <span class=\"nb\">enable <\/span>postgresql-10\r\nsystemctl start postgresql-10\r\n<\/code><\/pre>\n<h1>\u4f7f\u5f97 PostgreSQL \u670d\u52a1\u5668\uff08\u4ec5\u9650\u4e3b\u670d\u52a1\u5668\uff09\u80fd\u591f\u4ece\u5916\u90e8\u8bbf\u95ee\u3002<\/h1>\n<p>\u5728\u5b9e\u9645\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u4e00\u76f4\u91cd\u590d\u7740&#8221;\u65e0\u6cd5\u8fde\u63a5&#8221;\u7684\u64cd\u4f5c\uff0c\u76f4\u5230\u6700\u540e\u9636\u6bb5\u624d\u5b8c\u6210\u4e86\u8fd9\u9879\u5de5\u4f5c\u3002<\/p>\n<p>\u53ea\u9700\u8981\u670d\u52a1\u5668\u7aef\u6210\u4e3a\u4e3b\u63a7\u5373\u53ef\u3002<\/p>\n<pre class=\"post-pre\"><code>vi \/var\/lib\/pgsql\/10\/data\/postgresql.conf\r\n<\/code><\/pre>\n<p>\u5927\u7ea6\u5728\u7b2c59\u884c\u3002\u53bb\u6389&#8221;#&#8221;\u5e76\u4e14\u6539\u5199\uff08\u56e0\u4e3a\u8fd9\u53ea\u662f\u8bd5\u9a8c\uff0c\u6240\u6709\u90fd\u53ef\u4ee5\u63a5\u53d7\uff09\u3002<\/p>\n<pre class=\"post-pre\"><code>listen_addresses <span class=\"p\">=<\/span> <span class=\"s1\">'*'<\/span>                  # what IP address<span class=\"p\">(<\/span>es<span class=\"p\">)<\/span> <span class=\"k\">to<\/span> listen <span class=\"k\">on<\/span>;\r\n                                        # comma<span class=\"p\">-<\/span>separated <span class=\"k\">list<\/span> of addresses;\r\n                                        # defaults <span class=\"k\">to<\/span> <span class=\"s1\">'localhost'<\/span>; use <span class=\"s1\">'*'<\/span> <span class=\"k\">for<\/span> <span class=\"k\">all<\/span>\r\nport <span class=\"p\">=<\/span> <span class=\"m\">5432<\/span>                             # <span class=\"p\">(<\/span><span class=\"k\">change<\/span> requires restart<span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<p>\u8bbe\u7f6e\u53ef\u4ee5\u8fdb\u4e00\u6b65\u8fde\u63a5\u7684\u5ba2\u6237\u7aef\u3002<\/p>\n<pre class=\"post-pre\"><code>vi \/var\/lib\/pgsql\/10\/data\/pg_hba.conf\r\n<\/code><\/pre>\n<p>\u5728\u6700\u540e\u4e00\u6bb5\u7c7b\u4f3c\u7684\u5185\u5bb9\u65c1\u8fb9\u968f\u610f\u5199\u4e0a\u4e00\u70b9\u3002<\/p>\n<pre class=\"post-pre\"><code>host    <span class=\"k\">all<\/span>             <span class=\"k\">all<\/span>             <span class=\"k\">all<\/span>                     trust\r\n<\/code><\/pre>\n<p>\u8fd9\u4e2a\u4e5f\u53ea\u662f\u5c1d\u8bd5\u6027\u7684\uff0c\u6240\u4ee5\u6211\u4eec\u90fd\u63a5\u53d7\u4e86\uff0c\u4f46\u5b9e\u9645\u4e0a\u6211\u89c9\u5f97\u6700\u597d\u8fd8\u662f\u9650\u5b9a\u5728\u7279\u5b9a\u5730\u5740\u7b49\u65b9\u9762\u3002<\/p>\n<p>\u91cd\u542f<\/p>\n<pre class=\"post-pre\"><code>service postgresql-10 restart\r\n<\/code><\/pre>\n<h1>PostgreSQL\u7684\u7528\u6237\u7b49\u914d\u7f6e\uff08\u4e3b\/\u4ece\u5171\u7528\uff09<\/h1>\n<p>\u6211\u5c06\u5728\u540d\u4e3amydb\u7684\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3atest_db\u7684\u8868\uff0c\u5e76\u8fdb\u884c\u590d\u5236\u3002\u5e76\u4e14\u8981\u4fdd\u8bc1test\u7528\u6237\u6709\u6743\u9650\u6267\u884c\u6b64\u64cd\u4f5c\u3002\u56e0\u4e3a\u8fd9\u53ea\u662f\u6d4b\u8bd5\uff0c\u6240\u4ee5\u6743\u9650\u53ef\u4ee5\u9002\u5f53\u8bbe\u7f6e\u3002<\/p>\n<pre class=\"post-pre\"><code># su postgres\r\n$ createdb mydb\r\n$ psql mydb\r\nmydb=# CREATE TABLE test_db (\r\n    id              SERIAL,\r\n    name            varchar(80)\r\n);\r\nmydb=# CREATE ROLE test WITH LOGIN REPLICATION PASSWORD 'hogehoge';\r\nmydb=# GRANT ALL ON test_db TO test;\r\n<\/code><\/pre>\n<h1>\u590d\u5236\u8bbe\u7f6e<\/h1>\n<h3>\u4e3b\u673a\u7aef<\/h3>\n<p>\u5728\u8fdb\u884c\u903b\u8f91\u590d\u5236\u65f6\uff0c\u53c2\u8003\u8fd9\u7bc7\u6587\u7ae0\uff1ahttp:\/\/tkrd.hatenablog.com\/entry\/2017\/04\/23\/223936<\/p>\n<pre class=\"post-pre\"><code>vi \/var\/lib\/pgsql\/10\/data\/postgresql.conf\r\n<\/code><\/pre>\n<p>\u5927\u7ea6\u5728\u7b2c180\u884c\u5de6\u53f3<\/p>\n<pre class=\"post-pre\"><code>wal_level <span class=\"p\">=<\/span> logical                     # minimal<span class=\"p\">,<\/span> replica<span class=\"p\">,<\/span> <span class=\"nb\">or<\/span> logical\r\n<\/code><\/pre>\n<p>\u662f\u5426\u9700\u8981\u8c03\u6574max_replication_slots\uff1f\uff08\u5c3d\u7ba1\u6ca1\u6709\u8c03\u6574\u4e5f\u80fd\u6682\u65f6\u8fd0\u884c\uff09<\/p>\n<pre class=\"post-pre\"><code>service postgresql-10 restart\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\r\n<span class=\"err\">$<\/span> <span class=\"n\">psql<\/span> <span class=\"n\">mydb<\/span>\r\n<span class=\"n\">mydb<\/span><span class=\"o\">=#<\/span> <span class=\"k\">CREATE<\/span> <span class=\"n\">PUBLICATION<\/span> <span class=\"n\">pub_srv1_test_db<\/span> <span class=\"k\">FOR<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">test_db<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<h3>\u5974\u96b7\u4e00\u65b9<\/h3>\n<p>\u7531\u4e8e\u53ef\u4ee5\u5c06\u5176\u89c6\u4e3a\u4e0d\u540c\u7684\u4e3b\u673a\uff0c\u6240\u4ee5\u7aef\u53e3\u53f7\u53ef\u4ee5\u8bbe\u7f6e\u4e3a5432\u3002<\/p>\n<pre class=\"post-pre\"><code>$ psql mydb\r\nmydb=# CREATE SUBSCRIPTION sub_srv2_test_db CONNECTION 'dbname=mydb host=postgresql1 port=5432 user=test' PUBLICATION pub_srv1_test_db;\r\nNOTICE:  created replication slot \"sub_srv2_test_db\" on publisher\r\nCREATE SUBSCRIPTION\r\n<\/code><\/pre>\n<p>\u5728\u8fd9\u4e2a\u9636\u6bb5\u5c1d\u8bd5\u8fde\u63a5\uff0c\u5982\u679c\u8fde\u63a5\u8bbe\u7f6e\u51fa\u4e86\u95ee\u9898\uff0c\u5c31\u4f1a\u5728\u8fd9\u91cc\u5931\u8d25\u3002<br \/>\n\u54ce\u5440\uff0c\u6ca1\u6709\u6307\u5b9a\u5bc6\u7801\u554a\u3002\u3002\u3002<br \/>\n\u76ee\u524d\u8fd8\u6709\u4e00\u4e9b\u4e0d\u592a\u660e\u767d\u7684\u5730\u65b9\uff0c\u4f46\u603b\u4e4b\u5b83\u80fd\u591f\u8fd0\u884c\uff0c\u6240\u4ee5\u5c31\u7b97\u4e86\u5427\u3002\u3002\u3002\uff08\uff1f\uff09<br \/>\n\u7531\u4e8e\u8fd9\u4e2a\u539f\u56e0\uff0c\u6211\u67e5\u4e86\u4e00\u4e0b\uff0c\u8c8c\u4f3c\u662fpg_hba.conf\u6587\u4ef6\u4e2d\u7684trust\u9009\u9879\u3002<br \/>\n\u53c2\u8003\u94fe\u63a5\uff1ahttps:\/\/www.postgresql.jp\/document\/10\/html\/auth-pg-hba-conf.html<\/p>\n<pre class=\"post-pre\"><code>host    mydb            test            samenet             password\r\n<\/code><\/pre>\n<p>\u8fd9\u6837\u505a\u4f1a\u9700\u8981\u5bc6\u7801\uff08\u7531\u4e8e\u5728\u540c\u4e00\u7f51\u7edc\u4e0b\uff0c\u4f7f\u7528\u660e\u6587\u5e94\u8be5\u53ef\u4ee5\uff09\u53e6\u5916\u987a\u5e26\u4e00\u63d0\uff0c\u6211\u4e5f\u6dfb\u52a0\u4e86\u5141\u8bb8\u7531test\u7528\u6237\u8fde\u63a5\u7684mydb\u6570\u636e\u5e93\u7684\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code>mydb=# CREATE SUBSCRIPTION sub_srv2_test_db CONNECTION 'dbname=mydb host=postgresql1 port=5432 user=test' PUBLICATION pub_srv1_test_db;\r\nERROR:  could not connect to the publisher: fe_sendauth: no password supplied\r\nmydb=# CREATE SUBSCRIPTION sub_srv2_test_db CONNECTION 'dbname=mydb host=postgresql1 port=5432 user=test password=hogehoge' PUBLICATION pub_srv1_test_db;\r\nNOTICE:  created replication slot \"sub_srv2_test_db\" on publisher\r\nCREATE SUBSCRIPTION\r\n<\/code><\/pre>\n<h3>\u5c1d\u8bd5\u4e00\u4e0b<\/h3>\n<p>\u4e3b\u63a7\u7aef<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">mydb<\/span><span class=\"o\">=#<\/span> <span class=\"k\">insert<\/span> <span class=\"k\">into<\/span> <span class=\"n\">test_db<\/span> <span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">)<\/span> <span class=\"k\">values<\/span><span class=\"p\">(<\/span><span class=\"s1\">'aaa'<\/span><span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<p>\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u9879\uff0c\u7528\u4e2d\u56fd\u6bcd\u8bed\u6539\u5199\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<p>&#8220;\u30b9\u30ec\u30fc\u30d6\u5074&#8221;\u610f\u4e3a&#8221;\u5974\u96b6\u4e00\u65b9&#8221;\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">mydb<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">test_db<\/span><span class=\"p\">;<\/span>\r\n <span class=\"n\">id<\/span> <span class=\"o\">|<\/span> <span class=\"n\">name<\/span>\r\n<span class=\"c1\">----+------<\/span>\r\n  <span class=\"mi\">1<\/span> <span class=\"o\">|<\/span> <span class=\"n\">aaa<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<p>\u6709\u4ec0\u4e48\u4e1c\u897f\u52a8\u4e86\u3002<\/p>\n<h3>\u5176\u4ed6<\/h3>\n<p>\u65e0\u8bba\u5728\u4e3b\u63a7\u7aef\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff0c\u4ece\u5c5e\u7aef\u90fd\u4e0d\u4f1a\u6539\u53d8<\/p>\n<pre class=\"post-pre\"><code>truncate test_db;\r\n<\/code><\/pre>\n<p>\u5f53\u5728\u4ece\u5c5e\u65b9\u9762\u8fdb\u884c\u63d2\u5165\u65f6\u3002<\/p>\n<pre class=\"post-pre\"><code>mydb=# insert into test_db (name) values('aaa');\r\nmydb=# select * from test_db;\r\n id | name\r\n----+------\r\n  1 | aaa\r\n  1 | aaa\r\n<\/code><\/pre>\n<p>\u55ef\uff0c\u55ef\u3002\u561b\uff0c\u5f9e\u5974\u96b8\u7aef\u4f86\u8aaa\uff0c\u57fa\u672c\u4e0a\u53ea\u9700\u8981\u8b80\u53d6\u5c31\u53ef\u4ee5\u4e86\uff0c\u6240\u4ee5\u9019\u6a23\u4e5f\u53ef\u4ee5\u3002\u4f46\u662f\uff0cid\u548cname\u7684\u503c\u6703\u88ab\u8907\u88fd\u3002<br \/>\n\u56e0\u70ba\u6211\u719f\u6089MySQL\uff0c\u6240\u4ee5\u5c0d\u65bcSERIAL\u548csequence\u8868\u7684\u5b58\u5728\u6709\u9ede\u96e3\u4ee5\u7406\u89e3\u3002<\/p>\n<h3>\u5fc3\u5f97\u6216\u611f\u89e6<\/h3>\n<p>\u7b2c\u4e00\u6b21\u63a5\u89e6PostgreSQL\uff0c\u53d1\u73b0\u51fa\u73b0\u4e86\u76f8\u5f53\u591a\u7684\u8fc7\u65f6\u4fe1\u606f\uff0c\u5f88\u96be\u67e5\u627e\u5230\u76f8\u5173\u7684\u8d44\u6599\u5462\u3002\u3002\u3002\u800c\u4e14\u600e\u4e48\u4e0d\u80fd\u76f4\u63a5\u8df3\u8f6c\u523010\u7248\u672c\u7684\u6587\u6863\u5462\uff1f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u56e0\u4e3a\u88ab\u544a\u77e5\u300c\u867d\u7136\u53ea\u6709\u4e00\u53f0\u5b9e\u9645\u670d\u52a1\u5668\u4f5c\u4e3a\u5f00\u53d1\u73af\u5883\uff0c\u4f46\u662f\u8bf7\u521b\u5efa\u4e00\u4e2a\u53ef\u4ee5\u5728\u4e24\u53f0\u751f\u4ea7\u73af\u5883\u4e2d\u826f\u597d\u540c\u6b65\u7684\u673a\u5236\u300d\uff0c\u6240\u4ee5\u5728\u5c1d\u8bd5 [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42089","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\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236 - 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\u7528docker\u5728centos7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0postgresql\u7684\u903b\u8f91\u590d\u5236\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236\" \/>\n<meta property=\"og:description\" content=\"\u56e0\u4e3a\u88ab\u544a\u77e5\u300c\u867d\u7136\u53ea\u6709\u4e00\u53f0\u5b9e\u9645\u670d\u52a1\u5668\u4f5c\u4e3a\u5f00\u53d1\u73af\u5883\uff0c\u4f46\u662f\u8bf7\u521b\u5efa\u4e00\u4e2a\u53ef\u4ee5\u5728\u4e24\u53f0\u751f\u4ea7\u73af\u5883\u4e2d\u826f\u597d\u540c\u6b65\u7684\u673a\u5236\u300d\uff0c\u6240\u4ee5\u5728\u5c1d\u8bd5 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\u5728centos7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0postgresql\u7684\u903b\u8f91\u590d\u5236\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-14T02:23:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T17:59:15+00:00\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \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%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/\",\"name\":\"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-03-14T02:23:42+00:00\",\"dateModified\":\"2024-05-03T17:59:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236\"}]},{\"@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\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236 - 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\u7528docker\u5728centos7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0postgresql\u7684\u903b\u8f91\u590d\u5236\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236","og_description":"\u56e0\u4e3a\u88ab\u544a\u77e5\u300c\u867d\u7136\u53ea\u6709\u4e00\u53f0\u5b9e\u9645\u670d\u52a1\u5668\u4f5c\u4e3a\u5f00\u53d1\u73af\u5883\uff0c\u4f46\u662f\u8bf7\u521b\u5efa\u4e00\u4e2a\u53ef\u4ee5\u5728\u4e24\u53f0\u751f\u4ea7\u73af\u5883\u4e2d\u826f\u597d\u540c\u6b65\u7684\u673a\u5236\u300d\uff0c\u6240\u4ee5\u5728\u5c1d\u8bd5 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\u5728centos7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0postgresql\u7684\u903b\u8f91\u590d\u5236\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-03-14T02:23:42+00:00","article_modified_time":"2024-05-03T17:59:15+00:00","author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/","name":"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-03-14T02:23:42+00:00","dateModified":"2024-05-03T17:59:15+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Docker\u5728CentOS7\u4e0a\u5c1d\u8bd5\u5b9e\u73b0PostgreSQL\u7684\u903b\u8f91\u590d\u5236"}]},{"@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\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%e5%9c%a8centos7%e4%b8%8a%e5%b0%9d%e8%af%95%e5%ae%9e%e7%8e%b0postgresql%e7%9a%84%e9%80%bb%e8%be%91%e5%a4%8d%e5%88%b6\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42089","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42089"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42089\/revisions"}],"predecessor-version":[{"id":95428,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42089\/revisions\/95428"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}