{"id":7277,"date":"2022-03-21T12:46:06","date_gmt":"2022-03-21T04:46:06","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=7277"},"modified":"2022-03-21T16:47:22","modified_gmt":"2022-03-21T08:47:22","slug":"amazon-linux-2-install-postgresql-13","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2022\/03\/amazon-linux-2-install-postgresql-13\/","title":{"rendered":"\u5728Amazon Linux 2\u4e0a\u5b89\u88c5PostgreSQL"},"content":{"rendered":"\n\n\n\n\n<h3 class=\"wp-block-heading\">\u6982\u8ff0<\/h3>\n\n\n\n<p>\u4f7f\u7528\u7684Amazon Linux 2\uff0c\u76f8\u5f53\u4e8e\u662fCentOS 7\uff0c\u4e8e\u662f\u4f7f\u7528\u4e86\u5b98\u65b9\u7684yum repo\u6765\u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n\n\n\n<p>\u5b98\u65b9\u6587\u6863\u7684\u53c2\u8003\uff1a<a href=\"https:\/\/www.postgresql.org\/download\/linux\/redhat\/#yum\">Linux downloads (Red Hat family)@postgresql.org<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6dfb\u52a0yum\u4ed3\u5e93<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">\/etc\/yum.repos.d\/pgdg.repo\n[pgdg13]\nname=PostgreSQL 13 for RHEL\/CentOS 7 - x86_64\nbaseurl=https:\/\/download.postgresql.org\/pub\/repos\/yum\/13\/redhat\/rhel-7-x86_64\nenabled=1\ngpgcheck=0<\/code><\/pre>\n\n\n\n<p>\u6ce8\u610f\uff0c\u4e0a\u8ff0\u6587\u4ef6\u4e2d\u7684url\u9700\u8981\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8c03\u6574\uff0c\u9700\u8981\u6839\u636e\u4e3b\u673a\u7684\u53d1\u884c\u7248\u672c\u548c\u9700\u8981\u5b89\u88c5\u7684PostgreSQL\u7248\u672c\uff0c\u5728\u4ed3\u5e93\u4e2d\u627e\u5230\u5bf9\u5e94\u7684\u76ee\u5f55\uff1a<a rel=\"noreferrer noopener\" href=\"https:\/\/download.postgresql.org\/pub\/repos\/yum\/\" target=\"_blank\">\u76ee\u5f55\u5217\u8868<\/a>\u3002<\/p>\n\n\n\n<p>\u66f4\u65b0yum\u4ed3\u5e93\u914d\u7f6e\u4fe1\u606f\uff0c\u5e76\u5b89\u88c5postgresql-server<\/p>\n\n\n\n<p>sudo yum update<\/p>\n\n\n\n<p>sudo yum install postgresql13-server<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6dfb\u52a0\u6267\u884c\u6587\u4ef6\u5230PATH\u8def\u5f84<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">export PATH=\"${PATH}:\/usr\/pgsql-13\/bin\"<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u51c6\u5907\u6570\u636e\u6587\u4ef6\uff08database cluster\uff09<\/h3>\n\n\n\n<p>\u53c2\u8003\uff1a<a href=\"https:\/\/www.postgresql.org\/docs\/13\/creating-cluster.html\">Creating a Database Cluster<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root# mkdir \/usr\/local\/pgsql\nroot# adduser postgres\nroot# chown postgres \/usr\/local\/pgsql\nroot# su postgres\n\n<meta charset=\"utf-8\">postgres$ <meta charset=\"utf-8\">export PATH=\"${PATH}:\/usr\/pgsql-13\/bin\"\n\npostgres$ pg_ctl -D \/usr\/local\/pgsql\/data initdb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u542f\u52a8\/\u5173\u95edpostgresql<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">pg_ctl start -l logfile -D\/usr\/local\/pgsql\/data\npg_ctl stop -D \/usr\/local\/pgsql\/data<\/code><\/pre>\n\n\n\n<p>\u4fee\u6539\u914d\u7f6e\u6587\u4ef6<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">vim \/usr\/local\/pgsql\/data\/postgresql.conf  # \u4f8b\u5982\u4fee\u6539 shared_buffers = 64MB<\/code><\/pre>\n\n\n\n<p>\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">psql<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8ff0 \u4f7f\u7528\u7684Amazon Linux 2\uff0c\u76f8\u5f53\u4e8e\u662fCentOS 7\uff0c\u4e8e\u662f\u4f7f\u7528\u4e86\u5b98\u65b9\u7684yum repo\u6765\u8fdb\u884c\u5b89\u88c5\u3002 \u5b98\u65b9\u6587\u6863\u7684\u53c2\u8003\uff1aLinux downloads (Red Hat family)@postgresql.org \u6dfb\u52a0yum\u4ed3\u5e93 \u6ce8\u610f\uff0c\u4e0a\u8ff0\u6587\u4ef6\u4e2d\u7684url\u9700\u8981\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8c03\u6574\uff0c\u9700\u8981\u6839\u636e\u4e3b\u673a\u7684\u53d1\u884c\u7248\u672c\u548c\u9700\u8981\u5b89\u88c5\u7684PostgreSQL\u7248\u672c\uff0c\u5728\u4ed3\u5e93\u4e2d\u627e\u5230\u5bf9\u5e94\u7684\u76ee\u5f55\uff1a\u76ee\u5f55\u5217\u8868\u3002 \u66f4\u65b0yum\u4ed3\u5e93\u914d\u7f6e\u4fe1\u606f\uff0c\u5e76\u5b89\u88c5postgresql-server sudo yum update sudo yum install postgresql13-server \u6dfb\u52a0\u6267\u884c\u6587\u4ef6\u5230PATH\u8def\u5f84 \u51c6\u5907\u6570\u636e\u6587\u4ef6\uff08database cluster\uff09 \u53c2\u8003\uff1aCreating a Database Cluster \u542f\u52a8\/\u5173\u95edpostgresql \u4fee\u6539\u914d\u7f6e\u6587\u4ef6 \u8fde\u63a5\u6570\u636e\u5e93<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[126,117],"tags":[],"class_list":["post-7277","post","type-post","status-publish","format-standard","hentry","category-database","category-postgresql-2"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/7277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=7277"}],"version-history":[{"count":5,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/7277\/revisions"}],"predecessor-version":[{"id":7282,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/7277\/revisions\/7282"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=7277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=7277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=7277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}