{"id":41738,"date":"2023-04-30T04:23:56","date_gmt":"2023-11-21T17:10:33","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/"},"modified":"2024-04-30T01:55:23","modified_gmt":"2024-04-29T17:55:23","slug":"%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/","title":{"rendered":"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86”out of shared memory”\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173"},"content":{"rendered":"

\u9996\u5148<\/h1>\n

\u6211\u5728\u5de5\u4f5c\u4e2d\u7ecf\u5e38\u4f7f\u7528pg_dump\u5b9a\u671f\u5907\u4efd\u6a21\u5f0f\uff0c\u4f46\u6709\u4e00\u5929\u7a81\u7136\u95f4\u2026\u2026<\/p>\n

\u9519\u8bef\uff1a\u5171\u4eab\u5185\u5b58\u4e0d\u8db3
\n\u63d0\u793a\uff1a\u60a8\u53ef\u80fd\u9700\u8981\u589e\u52a0 max_locks_per_transaction\u3002<\/p>\n

\u53d1\u751f\u4e86\u7c7b\u4f3c\u7684\u9519\u8bef\u3002<\/p>\n

\u6211\u53ef\u4ee5\u589e\u52a0 max_locks_per_transaction \u8fd9\u4e2a\u53c2\u6570\u7684\u503c\uff0c\u4f46\u5728\u8fd9\u4e4b\u524d\uff0c\u6211\u60f3\u77e5\u9053\u5982\u679c\u9501\u7684\u6570\u91cf\u6210\u4e3a\u95ee\u9898\uff0c\u662f\u5426\u53d6\u51b3\u4e8e\u8868\u7684\u6570\u91cf\u3002\u56e0\u6b64\uff0c\u6211\u60f3\u8fdb\u884c\u9a8c\u8bc1\u3002<\/p>\n

\u6709\u4e9b\u4e8b\u6211\u60f3\u8981\u8bb0\u5f55\u4e0b\u6765\uff0c\u6240\u4ee5\u73af\u5883\u8bbe\u7f6e\u53d8\u5f97\u5f88\u957f\u3002
\n\u53e6\u5916\uff0c\u4e3a\u4e86\u65b9\u4fbf\u8bd5\u9a8c\u7684\u7ed3\u679c\uff0c\u4f7f\u7528\u4e86\u4e00\u4e2a\u8001\u7248\u672c\u7684 PostgreSQL 9.2 \u8fdb\u884c\u9a8c\u8bc1\u3002
\n(\u5de5\u4f5c\u4e0a\u4f7f\u7528 9.x \u7cfb\u5217\u6240\u4ee5\u6ca1\u95ee\u9898)<\/p>\n

\u73af\u5883\u5efa\u8bbe<\/h1>\n

\u4f7f\u7528Docker\u51c6\u5907\u5bb9\u5668\u3002<\/h2>\n

\u53c2\u8003\u306b\u3057\u306a\u304c\u3089\u3001Docker\u3067CentOS7\u306e\u74b0\u5883\u3092\u4f5c\u3063\u3066\u307f\u308b\u3002<\/p>\n

PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> pull<\/span> centos:centos7<\/span>\r\ncentos7:<\/span> Pulling<\/span> from<\/span> library\/centos<\/span>\r\n2<\/span>d473b07cdd5:<\/span> Pull<\/span> complete<\/span>\r\nDigest:<\/span> sha256:be65f488b7764ad3638f236b7b515b3678369a5124c47b8d32916d6487418ea4<\/span>\r\nStatus:<\/span> Downloaded<\/span> newer<\/span> image<\/span> for<\/span> centos:centos7<\/span>\r\ndocker.io\/library\/centos:centos7<\/span>\r\nPS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> images<\/span>\r\nREPOSITORY<\/span>               TAG<\/span>       IMAGE<\/span> ID<\/span>       CREATED<\/span>         SIZE<\/span>\r\ngetting-started<\/span>          latest<\/span>    f543cfcab108<\/span>   6<\/span> days<\/span> ago<\/span>      265MB<\/span>\r\ndocker101tutorial<\/span>        latest<\/span>    dcd472fd6898<\/span>   6<\/span> days<\/span> ago<\/span>      47.2MB<\/span>\r\n<<\/span>none<\/span>><\/span>                   <<\/span>none<\/span>><\/span>    dea1eaa1499f<\/span>   6<\/span> days<\/span> ago<\/span>      47.2MB<\/span>\r\n<<\/span>none<\/span>><\/span>                   <<\/span>none<\/span>><\/span>    b7e6ba19ed04<\/span>   6<\/span> days<\/span> ago<\/span>      47.2MB<\/span>\r\n<<\/span>none<\/span>><\/span>                   <<\/span>none<\/span>><\/span>    866713c08ea6<\/span>   6<\/span> days<\/span> ago<\/span>      47.2MB<\/span>\r\n<<\/span>none<\/span>><\/span>                   <<\/span>none<\/span>><\/span>    b1c4ce75d6fa<\/span>   6<\/span> days<\/span> ago<\/span>      265MB<\/span>\r\n<<\/span>none<\/span>><\/span>                   <<\/span>none<\/span>><\/span>    a1729d3e2187<\/span>   6<\/span> days<\/span> ago<\/span>      265MB<\/span>\r\ndocker\/getting-started<\/span>   latest<\/span>    3e4394f6b72f<\/span>   4<\/span> months<\/span> ago<\/span>    47MB<\/span>\r\ncentos<\/span>                   centos7<\/span>   eeb6ee3f44bd<\/span>   19<\/span> months<\/span> ago<\/span>   204MB<\/span>\r\n<\/code><\/pre>\n
\u542f\u52a8CentOS\u5bb9\u5668<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> run<\/span> -it<\/span> -d<\/span> --name<\/span> centos7<\/span> centos:centos7<\/span>\r\n1<\/span>d5b192caaec79f2bba99200a797e032984f9798c2000341ad77688e2569665b<\/span>\r\n<\/code><\/pre>\n
\u5728\u4e2d\u6587\u4e2d\uff0c\u53ef\u4ee5\u6709\u4ee5\u4e0b\u4e00\u79cd\u8868\u8fbe\u65b9\u5f0f\uff1a
\n\u5f00\u542fBash<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> exec<\/span> -it<\/span> centos7<\/span> \/bin\/bash<\/span>\r\n<\/code><\/pre>\n
\u5b89\u88c5PostgreSQL\u3002<\/h2>\n
\u6211\u8bb0\u5f97\u6211\u5728\u5de5\u4f5c\u4e2d\u5b89\u88c5PostgreSQL\u65f6\u662f\u4ece\u6e90\u4ee3\u7801\u6784\u5efa\u7684\uff0c\u4f46\u6211\u6ca1\u6709\u8bb0\u4f4f\u901a\u8fc7yum\u5b89\u88c5\u7684\u7ecf\u5386\u3002
\n\u4e3a\u4e86\u65b9\u4fbf\u8d77\u89c1\uff0c\u6211\u60f3\u901a\u8fc7yum\u5b89\u88c5\u3002
\n\u6211\u5c06\u53c2\u8003\u8fd9\u91cc\u7684\u6b65\u9aa4\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n
 <\/p>\n
\u9996\u5148\u6dfb\u52a0PostgreSQL\u7684\u5b58\u50a8\u5e93\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># yum -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/span>\r\nLoaded<\/span> plugins<\/span>:<\/span> fastestmirror<\/span>,<\/span> ovl<\/span>\r\npgdg<\/span>-redhat-repo-latest<\/span>.<\/span>noarch<\/span>.<\/span>rpm<\/span>                                                               |<\/span> 8.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\nExamining<\/span> \/var\/tmp\/yum-root-cMmWZV\/pgdg-redhat-repo-latest.noarch.rpm:<\/span> pgdg-redhat-repo-42.0-32.noarch<\/span>\r\nMarking<\/span> \/var\/tmp\/yum-root-cMmWZV\/pgdg-redhat-repo-latest.noarch.rpm<\/span> to<\/span> be<\/span> installed<\/span>\r\nResolving<\/span> Dependencies<\/span>\r\n--<\/span>><\/span> Running<\/span> transaction<\/span> check<\/span>\r\n---<\/span>><\/span> Package<\/span> pgdg<\/span>-redhat-repo<\/span>.<\/span>noarch<\/span> 0<\/span>:<\/span>42.0<\/span>-32<\/span> will<\/span> be<\/span> installed<\/span>\r\n--<\/span>><\/span> Finished<\/span> Dependency<\/span> Resolution<\/span>\r\n\r\nDependencies<\/span> Resolved<\/span>\r\n\r\n========================================================================================================================<\/span>\r\n Package<\/span>                      Arch<\/span>               Version<\/span>              Repository<\/span>                                   Size<\/span>\r\n========================================================================================================================<\/span>\r\nInstalling<\/span>:<\/span>\r\n pgdg<\/span>-redhat-repo<\/span>             noarch<\/span>             42.0<\/span>-32<\/span>              \/pgdg-redhat-repo-latest.noarch<\/span>              13<\/span> k<\/span>\r\n\r\nTransaction<\/span> Summary<\/span>\r\n========================================================================================================================<\/span>\r\nInstall<\/span>  1<\/span> Package<\/span>\r\n\r\nTotal<\/span> size<\/span>:<\/span> 13<\/span> k<\/span>\r\nInstalled<\/span> size:<\/span> 13<\/span> k<\/span>\r\nDownloading<\/span> packages<\/span>:<\/span>\r\nRunning<\/span> transaction<\/span> check<\/span>\r\nRunning<\/span> transaction<\/span> test<\/span>\r\nTransaction<\/span> test<\/span> succeeded<\/span>\r\nRunning<\/span> transaction<\/span>\r\n  Installing<\/span> :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span>                                                                      1<\/span>\/1<\/span>\r\n  Verifying<\/span>  :<\/span> pgdg-redhat-repo-42.0-32.noarch<\/span>                                                                      1\/1<\/span>\r\n\r\nInstalled<\/span>:<\/span>\r\n  pgdg<\/span>-redhat-repo<\/span>.<\/span>noarch<\/span> 0<\/span>:<\/span>42.0<\/span>-32<\/span>\r\n\r\nComplete<\/span>!<\/span>\r\n[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># yum list postgres<\/span>\r\nLoaded<\/span> plugins<\/span>:<\/span> fastestmirror<\/span>,<\/span> ovl<\/span>\r\nLoading<\/span> mirror<\/span> speeds<\/span> from<\/span> cached<\/span> hostfile<\/span>\r\n *<\/span> base<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\n *<\/span> extras<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\n *<\/span> updates<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\npgdg<\/span>-common<\/span>\/7\/x86_64\/signature<\/span>                                                                   |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg-common\/7\/x86_64\/signature<\/span>                                                                   |<\/span> 2.9<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>06<\/span> !!!<\/span>\r\npgdg11\/7\/x86_64\/signature<\/span>                                                                        |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg11\/7\/x86_64\/signature<\/span>                                                                        |<\/span> 3.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>02<\/span> !!!<\/span>\r\npgdg12\/7\/x86_64\/signature<\/span>                                                                        |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg12\/7\/x86_64\/signature<\/span>                                                                        |<\/span> 3.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> !!!<\/span>\r\npgdg13\/7\/x86_64\/signature<\/span>                                                                        |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg13\/7\/x86_64\/signature<\/span>                                                                        |<\/span> 3.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> !!!<\/span>\r\npgdg14\/7\/x86_64\/signature<\/span>                                                                        |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg14\/7\/x86_64\/signature<\/span>                                                                        |<\/span> 3.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> !!!<\/span>\r\npgdg15\/7\/x86_64\/signature<\/span>                                                                        |<\/span>  198<\/span> B<\/span>  00:00:00<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0x442DF0F8:<\/span>\r\n Userid<\/span>     :<\/span> \"PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 68<\/span>c9<\/span> e2b9<\/span> 1<\/span>a37<\/span> d136<\/span> fe74<\/span> d176<\/span> 1<\/span>f16<\/span> d2e1<\/span> 442<\/span>d<\/span> f0f8<\/span>\r\n Package<\/span>    :<\/span> pgdg<\/span>-redhat-repo-42<\/span>.<\/span>0-32<\/span>.<\/span>noarch<\/span> (<\/span>@<\/span>\/pgdg-redhat-repo-latest.noarch<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG<\/span>\r\nIs<\/span> this<\/span> ok<\/span> [<\/span>y\/N<\/span>]:<\/span> y<\/span>\r\npgdg15\/7\/x86_64\/signature<\/span>                                                                        |<\/span> 3.6<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span> !!!<\/span>\r\n(<\/span>1<\/span>\/11<\/span>):<\/span> pgdg11\/7\/x86_64\/group_gz<\/span>                                                                 |<\/span>  245<\/span> B<\/span>  00:00:01<\/span>\r\n(<\/span>2<\/span>\/11<\/span>):<\/span> pgdg12\/7\/x86_64\/group_gz<\/span>                                                                 |<\/span>  245<\/span> B<\/span>  00:00:01<\/span>\r\n(<\/span>3<\/span>\/11<\/span>):<\/span> pgdg13\/7\/x86_64\/group_gz<\/span>                                                                 |<\/span>  246<\/span> B<\/span>  00:00:00<\/span>\r\n(<\/span>4<\/span>\/11<\/span>):<\/span> pgdg14\/7\/x86_64\/group_gz<\/span>                                                                 |<\/span>  244<\/span> B<\/span>  00:00:00<\/span>\r\n(<\/span>5<\/span>\/11<\/span>):<\/span> pgdg12\/7\/x86_64\/primary_db<\/span>                                                               |<\/span> 366<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>02<\/span>\r\n(<\/span>6<\/span>\/11<\/span>):<\/span> pgdg13\/7\/x86_64\/primary_db<\/span>                                                               |<\/span> 280<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span>\r\n(<\/span>7<\/span>\/11<\/span>):<\/span> pgdg11\/7\/x86_64\/primary_db<\/span>                                                               |<\/span> 481<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>02<\/span>\r\n(<\/span>8<\/span>\/11<\/span>):<\/span> pgdg14\/7\/x86_64\/primary_db<\/span>                                                               |<\/span> 185<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span>\r\n(<\/span>9<\/span>\/11<\/span>):<\/span> pgdg15\/7\/x86_64\/group_gz<\/span>                                                                 |<\/span>  246<\/span> B<\/span>  00:00:00<\/span>\r\n(<\/span>10<\/span>\/11<\/span>):<\/span> pgdg15\/7\/x86_64\/primary_db<\/span>                                                              |<\/span>  97<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\n(<\/span>11<\/span>\/11<\/span>):<\/span> pgdg-common\/7\/x86_64\/primary_db<\/span>                                                         |<\/span> 173<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>03<\/span>\r\n<\/code><\/pre>\n
\u5b89\u88c5PostgreSQL<\/p>\n
[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># yum -y install postgresql-server<\/span>\r\nLoaded<\/span> plugins<\/span>:<\/span> fastestmirror<\/span>,<\/span> ovl<\/span>\r\nLoading<\/span> mirror<\/span> speeds<\/span> from<\/span> cached<\/span> hostfile<\/span>\r\n *<\/span> base<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\n *<\/span> extras<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\n *<\/span> updates<\/span>:<\/span> mirror.aktkn.sg<\/span>\r\nResolving<\/span> Dependencies<\/span>\r\n--<\/span>><\/span> Running<\/span> transaction<\/span> check<\/span>\r\n---<\/span>><\/span> Package<\/span> postgresql<\/span>-server<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span> will<\/span> be<\/span> installed<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> postgresql<\/span>-libs<\/span>(<\/span>x86<\/span>-64<\/span>)<\/span> =<\/span> 9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span> for<\/span> package<\/span>:<\/span> postgresql<\/span>-server-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> postgresql<\/span>(<\/span>x86<\/span>-64<\/span>)<\/span> =<\/span> 9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span> for<\/span> package<\/span>:<\/span> postgresql<\/span>-server-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> systemd<\/span>-sysv<\/span> for<\/span> package<\/span>:<\/span> postgresql<\/span>-server-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> libpq.so.<\/span>5<\/span>()(<\/span>64<\/span>bit<\/span>)<\/span> for<\/span> package<\/span>:<\/span> postgresql<\/span>-server-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Running<\/span> transaction<\/span> check<\/span>\r\n---<\/span>><\/span> Package<\/span> postgresql.x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span> will<\/span> be<\/span> installed<\/span>\r\n---<\/span>><\/span> Package<\/span> postgresql<\/span>-libs<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span> will<\/span> be<\/span> installed<\/span>\r\n---<\/span>><\/span> Package<\/span> systemd<\/span>-sysv<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span> will<\/span> be<\/span> installed<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> systemd<\/span> =<\/span> 219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span> for<\/span> package<\/span>:<\/span> systemd<\/span>-sysv-219-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Running<\/span> transaction<\/span> check<\/span>\r\n---<\/span>><\/span> Package<\/span> systemd.x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7<\/span> will<\/span> be<\/span> updated<\/span>\r\n---<\/span>><\/span> Package<\/span> systemd.x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span> will<\/span> be<\/span> an<\/span> update<\/span>\r\n--<\/span>><\/span> Processing<\/span> Dependency<\/span>:<\/span> systemd<\/span>-libs<\/span> =<\/span> 219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span> for<\/span> package<\/span>:<\/span> systemd<\/span>-219-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>.<\/span>x86_64<\/span>\r\n--<\/span>><\/span> Running<\/span> transaction<\/span> check<\/span>\r\n---<\/span>><\/span> Package<\/span> systemd<\/span>-libs<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7<\/span> will<\/span> be<\/span> updated<\/span>\r\n---<\/span>><\/span> Package<\/span> systemd<\/span>-libs<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span> will<\/span> be<\/span> an<\/span> update<\/span>\r\n--<\/span>><\/span> Finished<\/span> Dependency<\/span> Resolution<\/span>\r\n\r\nDependencies<\/span> Resolved<\/span>\r\n\r\n========================================================================================================================<\/span>\r\n Package<\/span>                           Arch<\/span>                   Version<\/span>                         Repository<\/span>               Size<\/span>\r\n========================================================================================================================<\/span>\r\nInstalling<\/span>:<\/span>\r\n postgresql<\/span>-server<\/span>                 x86_64<\/span>                 9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>                  updates<\/span>                 3.8<\/span> M<\/span>\r\nInstalling<\/span> for<\/span> dependencies:<\/span>\r\n postgresql<\/span>                        x86_64<\/span>                 9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>                  updates<\/span>                 3.0<\/span> M<\/span>\r\n postgresql-libs<\/span>                   x86_64<\/span>                 9.2.24-8.el7_9<\/span>                  updates<\/span>                 235<\/span> k<\/span>\r\n systemd<\/span>-sysv<\/span>                      x86_64<\/span>                 219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>                  updates<\/span>                  97<\/span> k<\/span>\r\nUpdating<\/span> for<\/span> dependencies:<\/span>\r\n systemd<\/span>                           x86_64<\/span>                 219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>                  updates<\/span>                 5.1<\/span> M<\/span>\r\n systemd-libs<\/span>                      x86_64<\/span>                 219-78.el7_9.7<\/span>                  updates<\/span>                 419<\/span> k<\/span>\r\n\r\nTransaction<\/span> Summary<\/span>\r\n========================================================================================================================<\/span>\r\nInstall<\/span>  1<\/span> Package<\/span>  (<\/span>+<\/span>3<\/span> Dependent<\/span> packages<\/span>)<\/span>\r\nUpgrade<\/span>             (<\/span> 2<\/span> Dependent<\/span> packages<\/span>)<\/span>\r\n\r\nTotal<\/span> download<\/span> size<\/span>:<\/span> 13<\/span> M<\/span>\r\nDownloading<\/span> packages:<\/span>\r\nDelta<\/span> RPMs<\/span> disabled<\/span> because<\/span> \/usr\/bin\/applydeltarpm<\/span> not<\/span> installed.<\/span>\r\nwarning<\/span>:<\/span> \/var\/cache\/yum\/x86_64\/7\/updates\/packages\/postgresql-libs-9.2.24-8.el7_9.x86_64.rpm:<\/span> Header<\/span> V3<\/span> RSA\/SHA256<\/span> Signature<\/span>,<\/span> key<\/span> ID<\/span> f4a80eb5:<\/span> NOKEY<\/span>\r\nPublic<\/span> key<\/span> for<\/span> postgresql<\/span>-libs-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>.<\/span>rpm<\/span> is<\/span> not<\/span> installed<\/span>\r\n(<\/span>1<\/span>\/6<\/span>):<\/span> postgresql-libs-9.2.24-8.el7_9.x86_64.rpm<\/span>                                                 |<\/span> 235<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\n(<\/span>2<\/span>\/6<\/span>):<\/span> postgresql-9.2.24-8.el7_9.x86_64.rpm<\/span>                                                      |<\/span> 3.0<\/span> MB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\n(<\/span>3<\/span>\/6<\/span>):<\/span> postgresql-server-9.2.24-8.el7_9.x86_64.rpm<\/span>                                               |<\/span> 3.8<\/span> MB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>01<\/span>\r\n(<\/span>4<\/span>\/6<\/span>):<\/span> systemd-libs-219-78.el7_9.7.x86_64.rpm<\/span>                                                    |<\/span> 419<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\n(<\/span>5<\/span>\/6<\/span>):<\/span> systemd-sysv-219-78.el7_9.7.x86_64.rpm<\/span>                                                    |<\/span>  97<\/span> kB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>00<\/span>\r\n(<\/span>6<\/span>\/6<\/span>):<\/span> systemd-219-78.el7_9.7.x86_64.rpm<\/span>                                                         |<\/span> 5.1<\/span> MB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>02<\/span>\r\n------------------------------------------------------------------------------------------------------------------------<\/span>\r\nTotal<\/span>                                                                                   4.4<\/span> MB\/s<\/span> |<\/span>  13<\/span> MB<\/span>  00<\/span>:<\/span>00<\/span>:<\/span>02<\/span>\r\nRetrieving<\/span> key<\/span> from<\/span> file<\/span>:<\/span>\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-CentOS-7<\/span>\r\nImporting<\/span> GPG<\/span> key<\/span> 0xF4A80EB5:<\/span>\r\n Userid<\/span>     :<\/span> \"CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>\"<\/span>\r\n Fingerprint<\/span>:<\/span> 6341<\/span> ab27<\/span> 53<\/span>d7<\/span> 8<\/span>a78<\/span> a7c2<\/span> 7<\/span>bb1<\/span> 24<\/span>c6<\/span> a8a7<\/span> f4a8<\/span> 0<\/span>eb5<\/span>\r\n Package<\/span>    :<\/span> centos<\/span>-release-7-9<\/span>.<\/span>2009<\/span>.<\/span>0<\/span>.<\/span>el7<\/span>.<\/span>centos<\/span>.<\/span>x86_64<\/span> (<\/span>@<\/span>CentOS<\/span>)<\/span>\r\n From<\/span>       :<\/span> \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-CentOS-7<\/span>\r\nRunning<\/span> transaction<\/span> check<\/span>\r\nRunning<\/span> transaction<\/span> test<\/span>\r\nTransaction<\/span> test<\/span> succeeded<\/span>\r\nRunning<\/span> transaction<\/span>\r\n  Installing<\/span> :<\/span> postgresql<\/span>-libs-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>                                                                1<\/span>\/8<\/span>\r\n  Installing<\/span> :<\/span> postgresql-9.2.24-8.el7_9.x86_64<\/span>                                                                     2\/8<\/span>\r\n  Updating<\/span>   :<\/span> systemd<\/span>-libs-219-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>.<\/span>x86_64<\/span>                                                                   3<\/span>\/8<\/span>\r\n  Updating<\/span>   :<\/span> systemd-219-78.el7_9.7.x86_64<\/span>                                                                        4\/8<\/span>\r\nFailed<\/span> to<\/span> get<\/span> D-Bus<\/span> connection:<\/span> Operation<\/span> not<\/span> permitted<\/span>\r\n  Installing<\/span> :<\/span> systemd<\/span>-sysv-219-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>.<\/span>x86_64<\/span>                                                                   5<\/span>\/8<\/span>\r\n  Installing<\/span> :<\/span> postgresql-server-9.2.24-8.el7_9.x86_64<\/span>                                                              6\/8<\/span>\r\n  Cleanup<\/span>    :<\/span> systemd<\/span>-219-78<\/span>.<\/span>el7<\/span>.<\/span>x86_64<\/span>                                                                            7<\/span>\/8<\/span>\r\n  Cleanup<\/span>    :<\/span> systemd-libs-219-78.el7.x86_64<\/span>                                                                       8\/8<\/span>\r\n  Verifying<\/span>  :<\/span> postgresql<\/span>-libs-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>                                                                1<\/span>\/8<\/span>\r\n  Verifying<\/span>  :<\/span> systemd-libs-219-78.el7_9.7.x86_64<\/span>                                                                   2\/8<\/span>\r\n  Verifying<\/span>  :<\/span> postgresql<\/span>-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>                                                                     3<\/span>\/8<\/span>\r\n  Verifying<\/span>  :<\/span> systemd-219-78.el7_9.7.x86_64<\/span>                                                                        4\/8<\/span>\r\n  Verifying<\/span>  :<\/span> postgresql<\/span>-server-9<\/span>.<\/span>2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>.<\/span>x86_64<\/span>                                                              5<\/span>\/8<\/span>\r\n  Verifying<\/span>  :<\/span> systemd-sysv-219-78.el7_9.7.x86_64<\/span>                                                                   6\/8<\/span>\r\n  Verifying<\/span>  :<\/span> systemd<\/span>-libs-219-78<\/span>.<\/span>el7<\/span>.<\/span>x86_64<\/span>                                                                       7<\/span>\/8<\/span>\r\n  Verifying<\/span>  :<\/span> systemd-219-78.el7.x86_64<\/span>                                                                            8\/8<\/span>\r\n\r\nInstalled<\/span>:<\/span>\r\n  postgresql<\/span>-server<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>\r\n\r\nDependency<\/span> Installed<\/span>:<\/span>\r\n  postgresql.x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>   postgresql<\/span>-libs<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>9.2<\/span>.<\/span>24-8<\/span>.<\/span>el7_9<\/span>   systemd<\/span>-sysv<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>\r\n\r\nDependency<\/span> Updated<\/span>:<\/span>\r\n  systemd.x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>                          systemd<\/span>-libs<\/span>.<\/span>x86_64<\/span> 0<\/span>:<\/span>219<\/span>-78<\/span>.<\/span>el7_9<\/span>.<\/span>7<\/span>\r\n\r\nComplete<\/span>!<\/span>\r\n<\/code><\/pre>\n
\u786e\u8ba4\u7248\u672c<\/p>\n
[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># pg_ctl --version<\/span>\r\npg_ctl<\/span> (<\/span>PostgreSQL<\/span>)<\/span> 9.2<\/span>.<\/span>24<\/span>\r\n<\/code><\/pre>\n
\u8001\u4e86\uff0c\u4f46\u603b\u4f53\u6765\u8bf4\uff0c\u6682\u4e14\u8fd9\u6837\u5427\u3002<\/p>\n
\u521d\u59cb\u5316\u548c\u542f\u52a8PostgreSQL<\/h2>\n
\u6211\u8981\u8fdb\u884cPostgreSQL\u7684\u521d\u59cb\u5316\u4e86\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># su - postgres<\/span>\r\n-bash-4<\/span>.<\/span>2<\/span>$<\/span> initdb<\/span>\r\nThe<\/span> files<\/span> belonging<\/span> to<\/span> this<\/span> database<\/span> system<\/span> will<\/span> be<\/span> owned<\/span> by<\/span> user<\/span> \"postgres\"<\/span>.<\/span>\r\nThis<\/span> user<\/span> must<\/span> also<\/span> own<\/span> the<\/span> server<\/span> process.<\/span>\r\n\r\nThe<\/span> database<\/span> cluster<\/span> will<\/span> be<\/span> initialized<\/span> with<\/span> locale<\/span> \"C\"<\/span>.<\/span>\r\nThe<\/span> default<\/span> database<\/span> encoding<\/span> has<\/span> accordingly<\/span> been<\/span> set<\/span> to<\/span> \"SQL_ASCII\"<\/span>.<\/span>\r\nThe<\/span> default<\/span> text<\/span> search<\/span> configuration<\/span> will<\/span> be<\/span> set<\/span> to<\/span> \"english\"<\/span>.<\/span>\r\n\r\nfixing<\/span> permissions<\/span> on<\/span> existing<\/span> directory<\/span> \/var\/lib\/pgsql\/data<\/span> ...<\/span> ok<\/span>\r\ncreating<\/span> subdirectories<\/span> ...<\/span> ok<\/span>\r\nselecting<\/span> default<\/span> max_connections<\/span> ...<\/span> 100<\/span>\r\nselecting<\/span> default<\/span> shared_buffers<\/span> ...<\/span> 32<\/span>MB<\/span>\r\ncreating<\/span> configuration<\/span> files<\/span> ...<\/span> ok<\/span>\r\ncreating<\/span> template1<\/span> database<\/span> in<\/span> \/var\/lib\/pgsql\/data\/base\/1<\/span> ...<\/span> ok<\/span>\r\ninitializing<\/span> pg_authid<\/span> ...<\/span> ok<\/span>\r\ninitializing<\/span> dependencies<\/span> ...<\/span> ok<\/span>\r\ncreating<\/span> system<\/span> views<\/span> ...<\/span> ok<\/span>\r\nloading<\/span> system<\/span> objects<\/span>' descriptions ... ok\r\ncreating collations ... ok\r\ncreating conversions ... ok\r\ncreating dictionaries ... ok\r\nsetting privileges on built-in objects ... ok\r\ncreating information schema ... ok\r\nloading PL\/pgSQL server-side language ... ok\r\nvacuuming database template1 ... ok\r\ncopying template1 to template0 ... ok\r\ncopying template1 to postgres ... ok\r\n\r\nWARNING: enabling \"trust\" authentication for local connections\r\nYou can change this by editing pg_hba.conf or using the option -A, or\r\n--auth-local and --auth-host, the next time you run initdb.\r\n\r\nSuccess. You can now start the database server using:\r\n\r\n    postgres -D \/var\/lib\/pgsql\/data\r\nor\r\n    pg_ctl -D \/var\/lib\/pgsql\/data -l logfile start\r\n<\/span><\/code><\/pre>\n
\u542f\u52a8PostgreSQL\u670d\u52a1\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>1<\/span>d5b192caaec<\/span> \/<\/span>]<\/span># systemctl status postgresql<\/span>\r\nFailed<\/span> to<\/span> get<\/span> D-Bus<\/span> connection:<\/span> Operation<\/span> not<\/span> permitted<\/span>\r\n<\/code><\/pre>\n
\u4ece\u672a\u89c1\u8fc7\u7684\u9519\u8bef\uff01\u5f53\u6211\u67e5\u8be2\u4e86\u4e00\u4e0b\uff0c\u4f3c\u4e4e\u53d1\u73b0systemctl\u88ab\u7981\u7528\u4e86\u3002<\/p>\n
\u505c\u6b62\u5bb9\u5668\u3002<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> stop<\/span> centos7<\/span>\r\ncentos7<\/span>\r\n<\/code><\/pre>\n
–\u542c\u8bf4\u8981\u52a0\u4e0aprivileged\u9009\u9879\u6765\u542f\u52a8\u3002<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> run<\/span> -it<\/span> -d<\/span> --privileged<\/span> --name<\/span> centos7<\/span> centos:centos7<\/span>\r\ndocker:<\/span> Error<\/span> response<\/span> from<\/span> daemon:<\/span> Conflict.<\/span> The<\/span> container<\/span> name<\/span> \"\/centos7\"<\/span> is<\/span> already<\/span> in<\/span> use<\/span> by<\/span> container<\/span> \"1d5b192caaec79f2bba99200a797e032984f9798c2000341ad77688e2569665b\"<\/span>.<\/span> You<\/span> have<\/span> to<\/span> remove<\/span> (<\/span>or<\/span> rename<\/span>)<\/span> that<\/span> container<\/span> to<\/span> be<\/span> able<\/span> to<\/span> reuse<\/span> that<\/span> name.<\/span>\r\nSee<\/span> 'docker run --help'<\/span>.<\/span>\r\n<\/code><\/pre>\n
\u56e0\u4e3a\u9047\u5230\u4e86\u9519\u8bef\uff0c\u6240\u4ee5\u6211\u8981\u91cd\u65b0\u521d\u59cb\u5316PostgreSQL\u3002<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> rm<\/span> centos7<\/span>\r\ncentos7<\/span>\r\n<\/code><\/pre>\n
\u56e0\u4e3a\u542c\u8bf4\u8981\u52a0\u4e0a –privileged \u9009\u9879\u6765\u542f\u52a8\uff0c\u6240\u4ee5\u8fdb\u884c\u542f\u52a8\u3002\u4e5f\u7a0d\u5fae\u4fee\u6539\u4e00\u4e0b\u9009\u9879\u3002<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> run<\/span> --privileged<\/span> -d<\/span> --name<\/span> centos7<\/span> centos:centos7<\/span> \/sbin\/init<\/span>\r\n54<\/span>ab4f90d9e74d1b7d08aee6189e5b97fa35c44997d304ce32bb694c95fd75bb<\/span>\r\n<\/code><\/pre>\n
\u542f\u52a8Bash<\/p>\n
PS<\/span> C:\\data\\dev\\docker\\centos7<\/span>><\/span> docker<\/span> exec<\/span> -it<\/span> centos7<\/span> \/bin\/bash<\/span>\r\n<\/code><\/pre>\n
\u4f7f\u7528systemctl\u6765\u786e\u8ba4<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># systemctl status postgresql<\/span>\r\n\u25cf<\/span> postgresql.service<\/span> -<\/span> PostgreSQL<\/span> database<\/span> server<\/span>\r\n   Loaded<\/span>:<\/span> loaded<\/span> (<\/span>\/usr\/lib\/systemd\/system\/postgresql.service<\/span>;<\/span> disabled<\/span>;<\/span> vendor<\/span> preset<\/span>:<\/span> disabled<\/span>)<\/span>\r\n   Active<\/span>:<\/span> inactive<\/span> (<\/span>dead<\/span>)<\/span>\r\n\r\nApr<\/span> 22<\/span> 01<\/span>:<\/span>43<\/span>:<\/span>05<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Collecting<\/span> postgresql.service<\/span>\r\n<\/code><\/pre>\n
\u7531\u4e8e\u786e\u8ba4\u53ef\u4ee5\u4f7f\u7528systemctl\uff0c\u56e0\u6b64\u542f\u52a8\u4e86PostgreSQL\u3002<\/p>\n
[root@54ab4f90d9e7 \/]# systemctl start postgresql\r\n[root@54ab4f90d9e7 \/]# systemctl status postgresql\r\n\u25cf postgresql.service - PostgreSQL database server\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; disabled; vendor preset: disabled)\r\n   Active: active (running) since Sat 2023-04-22 01:44:24 UTC; 1s ago\r\n  Process: 372 ExecStart=\/usr\/bin\/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0\/SUCCESS)\r\n  Process: 367 ExecStartPre=\/usr\/bin\/postgresql-check-db-dir ${PGDATA} (code=exited, status=0\/SUCCESS)\r\n Main PID: 374 (postgres)\r\n   CGroup: \/docker\/54ab4f90d9e74d1b7d08aee6189e5b97fa35c44997d304ce32bb694c95fd75bb\/docker\/54ab4f90d9e74d1b7d08aee6189e5b97fa35c44997d304ce32bb694c95fd75bb\/system.slice\/postgresql.service\r\n           \u251c\u2500374 \/usr\/bin\/postgres -D \/var\/lib\/pgsql\/data -p 5432\r\n           \u251c\u2500375 postgres: logger process\r\n           \u251c\u2500377 postgres: checkpointer process\r\n           \u251c\u2500378 postgres: writer process\r\n           \u251c\u2500379 postgres: wal writer process\r\n           \u251c\u2500380 postgres: autovacuum launcher process\r\n           \u2514\u2500381 postgres: stats collector process\r\n           \u2023 374 \/usr\/bin\/postgres -D \/var\/lib\/pgsql\/data -p 5432\r\n\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching non detached 377.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching 377 through watch_pids1.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching non detached 378.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching 378 through watch_pids1.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching non detached 379.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching 379 through watch_pids1.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching non detached 380.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching 380 through watch_pids1.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching non detached 381.\r\nApr 22 01:44:24 54ab4f90d9e7 systemd[1]: Watching 381 through watch_pids1.\r\n<\/code><\/pre>\n
\u5728PostgreSQL\u4e2d\u521b\u5efa\u6570\u636e\u5e93\u3002<\/h2>\n
\u65e2\u7136\u8fd9\u6b21\u53ea\u662f\u8fdb\u884c\u9a8c\u8bc1\uff0c\u6211\u4eec\u5c31\u4e0d\u9700\u8981\u521b\u5efa\u4e13\u5c5e\u7528\u6237\uff0c\u76f4\u63a5\u521b\u5efa\u6570\u636e\u5e93\u5373\u53ef\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># su - postgres<\/span>\r\nLast<\/span> login<\/span>:<\/span> Sat<\/span> Apr<\/span> 22<\/span> 01<\/span>:<\/span>43<\/span>:<\/span>18<\/span> UTC<\/span> 2023<\/span> on<\/span> pts\/0<\/span>\r\n-bash-4<\/span>.<\/span>2<\/span>$<\/span> createdatabase<\/span> test<\/span>\r\n-bash<\/span>:<\/span> createdatabase<\/span>:<\/span> command<\/span> not<\/span> found<\/span>\r\n-bash-4<\/span>.<\/span>2<\/span>$<\/span> createdb<\/span> test<\/span>\r\n-bash-4<\/span>.<\/span>2<\/span>$<\/span> \r\n<\/code><\/pre>\n
\u8fde\u63a5\u5230\u6570\u636e\u5e93<\/p>\n
-bash-4<\/span>.<\/span>2<\/span>$<\/span> psql<\/span> test<\/span>\r\npsql<\/span> (<\/span>9.2<\/span>.<\/span>24<\/span>)<\/span>\r\nType<\/span> \"help\"<\/span> for<\/span> help.<\/span>\r\ntest<\/span>=<\/span># create table test(name text, age numeric);<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\ntest<\/span>=<\/span># select * from pg_tables where tablename='test';<\/span>\r\n schemaname<\/span> |<\/span> tablename<\/span> |<\/span> tableowner<\/span> |<\/span> tablespace<\/span> |<\/span> hasindexes<\/span> |<\/span> hasrules<\/span> |<\/span> hastriggers<\/span>\r\n------------+-----------+------------+------------+------------+----------+-------------<\/span>\r\n public<\/span>     |<\/span> test<\/span>      |<\/span> postgres<\/span>   |<\/span>            |<\/span> f<\/span>          |<\/span> f<\/span>        |<\/span> f<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u786e\u8ba4\u53ef\u7528\u6027<\/p>\n
\u9a8c\u8bc1<\/h1>\n
\u7531\u4e8e\u6700\u5927\u4e8b\u52a1\u9501\u6570\uff08max_locks_per_transaction\uff09\u7684\u5f71\u54cd\uff0c\u9996\u5148\u5c06\u5176\u8bbe\u7f6e\u4e3a\u6700\u5c0f\u503c\uff0c\u7136\u540e\u521b\u5efa\u5927\u91cf\u7684\u8868\u5e76\u786e\u8ba4\u662f\u5426\u4f1a\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n
\u5bf9\u4e8ePostgreSQL\u7684\u914d\u7f6e\u66f4\u6539<\/h2>\n
\u786e\u8ba4 postgresql.conf \u6587\u4ef6\u7684\u5b58\u5728<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># ls \/var\/lib\/pgsql\/data\/<\/span>\r\nPG_VERSION<\/span>  pg_clog<\/span>        pg_log<\/span>        pg_serial<\/span>     pg_subtrans<\/span>  pg_xlog<\/span>          postmaster.pid<\/span>\r\nbase<\/span>        pg_hba.conf<\/span>    pg_multixact<\/span>  pg_snapshots<\/span>  pg_tblspc<\/span>    postgresql.conf<\/span>\r\nglobal<\/span>      pg_ident.conf<\/span>  pg_notify<\/span>     pg_stat_tmp<\/span>   pg_twophase<\/span>  postmaster.opts<\/span>\r\n<\/code><\/pre>\n
\u7f16\u8f91postgresql.conf\u6587\u4ef6
\n\u6dfb\u52a0max_locks_per_transaction = 10<\/p>\n
[root@54ab4f90d9e7 \/]# vi \/var\/lib\/pgsql\/data\/postgresql.conf\r\n#max_locks_per_transaction = 64         # min 10\r\n                                        # (change requires restart)\r\nmax_locks_per_transaction = 10\r\n<\/code><\/pre>\n
\u91cd\u65b0\u542f\u52a8PostgreSQL<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># systemctl restart postgresql<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># systemctl status postgresql<\/span>\r\n\u25cf<\/span> postgresql.service<\/span> -<\/span> PostgreSQL<\/span> database<\/span> server<\/span>\r\n   Loaded<\/span>:<\/span> loaded<\/span> (<\/span>\/usr\/lib\/systemd\/system\/postgresql.service<\/span>;<\/span> disabled<\/span>;<\/span> vendor<\/span> preset<\/span>:<\/span> disabled<\/span>)<\/span>\r\n   Active<\/span>:<\/span> active<\/span> (<\/span>running<\/span>)<\/span> since<\/span> Sat<\/span> 2023<\/span>-04-22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> UTC<\/span>;<\/span> 8<\/span>s<\/span> ago<\/span>\r\n  Process<\/span>:<\/span> 465<\/span> ExecStop<\/span>=<\/span>\/usr\/bin\/pg_ctl<\/span> stop<\/span> -D<\/span> ${PGDATA}<\/span> -s<\/span> -m<\/span> fast<\/span> (<\/span>code<\/span>=<\/span>exited<\/span>,<\/span> status<\/span>=<\/span>0<\/span>\/SUCCESS<\/span>)<\/span>\r\n  Process<\/span>:<\/span> 471<\/span> ExecStart<\/span>=<\/span>\/usr\/bin\/pg_ctl<\/span> start<\/span> -D<\/span> ${PGDATA}<\/span> -s<\/span> -o<\/span> -p<\/span> ${PGPORT}<\/span> -w<\/span> -t<\/span> 300<\/span> (<\/span>code<\/span>=<\/span>exited<\/span>,<\/span> status<\/span>=<\/span>0<\/span>\/SUCCESS<\/span>)<\/span>\r\n  Process<\/span>:<\/span> 466<\/span> ExecStartPre<\/span>=<\/span>\/usr\/bin\/postgresql-check-db-dir<\/span> ${PGDATA}<\/span> (<\/span>code<\/span>=<\/span>exited<\/span>,<\/span> status<\/span>=<\/span>0<\/span>\/SUCCESS<\/span>)<\/span>\r\n Main<\/span> PID<\/span>:<\/span> 473<\/span> (<\/span>postgres<\/span>)<\/span>\r\n   CGroup<\/span>:<\/span> \/docker\/54ab4f90d9e74d1b7d08aee6189e5b97fa35c44997d304ce32bb694c95fd75bb\/docker\/54ab4f90d9e74d1b7d08aee6189e5b97fa35c44997d304ce32bb694c95fd75bb\/system.slice\/postgresql.service<\/span>\r\n           \u251c\u2500<\/span>473<\/span> \/usr\/bin\/postgres<\/span> -D<\/span> \/var\/lib\/pgsql\/data<\/span> -p<\/span> 5432<\/span>\r\n           \u251c\u2500<\/span>474<\/span> postgres<\/span>:<\/span> logger<\/span> process<\/span>\r\n           \u251c\u2500<\/span>476<\/span> postgres<\/span>:<\/span> checkpointer<\/span> process<\/span>\r\n           \u251c\u2500<\/span>477<\/span> postgres<\/span>:<\/span> writer<\/span> process<\/span>\r\n           \u251c\u2500<\/span>478<\/span> postgres<\/span>:<\/span> wal<\/span> writer<\/span> process<\/span>\r\n           \u251c\u2500<\/span>479<\/span> postgres<\/span>:<\/span> autovacuum<\/span> launcher<\/span> process<\/span>\r\n           \u2514\u2500<\/span>480<\/span> postgres<\/span>:<\/span> stats<\/span> collector<\/span> process<\/span>\r\n           \u2023<\/span> 473<\/span> \/usr\/bin\/postgres<\/span> -D<\/span> \/var\/lib\/pgsql\/data<\/span> -p<\/span> 5432<\/span>\r\n\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> non<\/span> detached<\/span> 476<\/span>.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> 476<\/span> through<\/span> watch_pids1.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> non<\/span> detached<\/span> 477<\/span>.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> 477<\/span> through<\/span> watch_pids1.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> non<\/span> detached<\/span> 478<\/span>.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> 478<\/span> through<\/span> watch_pids1.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> non<\/span> detached<\/span> 479<\/span>.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> 479<\/span> through<\/span> watch_pids1.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> non<\/span> detached<\/span> 480<\/span>.<\/span>\r\nApr<\/span> 22<\/span> 02<\/span>:<\/span>01<\/span>:<\/span>33<\/span> 54<\/span>ab4f90d9e7<\/span> systemd<\/span>[<\/span>1<\/span>]:<\/span> Watching<\/span> 480<\/span> through<\/span> watch_pids1.<\/span>\r\n<\/code><\/pre>\n
\u6bcf\u4e2a\u4e8b\u52a1\u7684\u6700\u5927\u9501\u5b9a\u6570\u4e3a10\u3002<\/h2>\n
\u786e\u8ba4\u8bbe\u7f6e\u7684\u53cd\u6620<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># psql test -U postgres<\/span>\r\npsql<\/span> (<\/span>9.2<\/span>.<\/span>24<\/span>)<\/span>\r\nType<\/span> \"help\"<\/span> for<\/span> help.<\/span>\r\n\r\ntest<\/span>=<\/span># select name, setting from pg_settings where name='max_locks_per_transaction';<\/span>\r\n           name<\/span>            |<\/span> setting<\/span>\r\n---------------------------+---------<\/span>\r\n max_locks_per_transaction<\/span> |<\/span> 10<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>``<\/span>`<\/span>\r\n\r\n### 100\u30c6\u30fc\u30d6\u30eb\u751f\u6210\u3057\u3066pg_dump\u78ba\u8a8d<\/span>\r\n\r\n\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308b\u30b7\u30a7\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/span>\r\n\r\n```<\/span>powershell<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> \/<\/span>]<\/span># cd \/tmp<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># vi maketable.sh<\/span>\r\n#!\/bin\/bash<\/span>\r\nfor<\/span> i<\/span> in<\/span> `s<\/span>eq<\/span> 1<\/span> 100<\/span>`\r\n<\/span>do<\/span>\r\n  psql<\/span> -U<\/span> postgres<\/span> -c<\/span> \"CREATE TABLE test_<\/span>$i<\/span>(name text, age numeric, address text)\"<\/span> -d<\/span> test<\/span>\r\ndone<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># bash .\/maketable.sh<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\n\u30fb\u30fb\u30fb\u4e2d\u7565\u30fb\u30fb\u30fb<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\n<\/code><\/pre>\n
\u6211\u8bd5\u7740\u8fdb\u884cpg_dump<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># pg_dump -s -U postgres -f test01.sql test<\/span>\r\n<\/code><\/pre>\n
\u6ca1\u6709\u9519\u8bef\u3002<\/p>\n
\u751f\u62103000\u4e2a\u9644\u52a0\u8868\uff0c\u5e76\u901a\u8fc7pg_dump\u8fdb\u884c\u786e\u8ba4\u3002<\/h3>\n
\u6bc5\u7136\u51b3\u7136\u5730\uff0c\u901a\u8fc7\u6dfb\u52a03000\u4e2a\u8868\u683c\u6765\u751f\u6210\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># vi maketable.sh<\/span>\r\n#!\/bin\/bash<\/span>\r\nfor<\/span> i<\/span> in<\/span> `s<\/span>eq<\/span> 1<\/span> 3000<\/span>`\r\n<\/span>do<\/span>\r\n  psql<\/span> -U<\/span> postgres<\/span> -c<\/span> \"CREATE TABLE test2_<\/span>$i<\/span>(name text, age numeric, address text)\"<\/span> -d<\/span> test<\/span>\r\ndone<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># bash .\/maketable.sh<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\n\u30fb\u30fb\u30fb<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\nCREATE<\/span> TABLE<\/span>\r\n<\/code><\/pre>\n
\u5907\u4efd\u6570\u636e\u5e93<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># pg_dump -s -U postgres -f test01.sql test<\/span>\r\npg_dump:<\/span> WARNING:<\/span>  out<\/span> of<\/span> shared<\/span> memory<\/span>\r\npg_dump:<\/span> [<\/span>archiver<\/span> (<\/span>db<\/span>)]<\/span> query<\/span> failed:<\/span> ERROR:<\/span>  out<\/span> of<\/span> shared<\/span> memory<\/span>\r\nHINT:<\/span>  You<\/span> might<\/span> need<\/span> to<\/span> increase<\/span> max_locks_per_transaction.<\/span>\r\npg_dump:<\/span> [<\/span>archiver<\/span> (<\/span>db<\/span>)]<\/span> query<\/span> was:<\/span> LOCK<\/span> TABLE<\/span> public.test2_2575<\/span> IN<\/span> ACCESS<\/span> SHARE<\/span> MODE<\/span>\r\n<\/code><\/pre>\n
\u53d1\u751f\u4e86\uff01<\/p>\n
\u5728\u751f\u62103000\u4e2a\u8868\u7684\u60c5\u51b5\u4e0b\uff0c\u5c06max_locks_per_transaction\u8bbe\u7f6e\u4e3a64\uff0c\u5e76\u8fdb\u884cpg_dump\u786e\u8ba4\u3002<\/h3>\n
\u4fee\u6539 max_locks_per_transaction<\/p>\n
[root@54ab4f90d9e7 tmp]# vi \/var\/lib\/pgsql\/data\/postgresql.conf\r\nmax_locks_per_transaction = 64          # min 10\r\n#max_locks_per_transaction = 10         # min 10\r\n                                        # (change requires restart)\r\n<\/code><\/pre>\n
\u91cd\u65b0\u542f\u52a8PostgreSQL<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># systemctl restart postgresql<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span>#<\/span>\r\n<\/code><\/pre>\n
\u5c1d\u8bd5\u4f7f\u7528pg_dump<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># pg_dump -s -U postgres -f test01.sql test<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span>#<\/span>\r\n<\/code><\/pre>\n
\u53d6\u5f97\u76ee\u6807<\/p>\n
\u5220\u96641000\u4e2a\u8868\u5e76\u5c06max_locks_per_transaction\u8bbe\u7f6e\u4e3a10\uff0c\u7136\u540e\u8fdb\u884cpg_dump\u786e\u8ba4\u3002<\/h3>\n
\u4fee\u6539 max_locks_per_transaction<\/p>\n
[root@54ab4f90d9e7 tmp]# vi \/var\/lib\/pgsql\/data\/postgresql.conf\r\n#max_locks_per_transaction = 64          # min 10\r\nmax_locks_per_transaction = 10         # min 10\r\n                                        # (change requires restart)\r\n<\/code><\/pre>\n
\u91cd\u65b0\u542f\u52a8PostgreSQL\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># systemctl restart postgresql<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span>#<\/span>\r\n<\/code><\/pre>\n
\u6211\u8bd5\u7740\u8fdb\u884cpg_dump\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># pg_dump -s -U postgres -f test01.sql test<\/span>\r\npg_dump:<\/span> WARNING:<\/span>  out<\/span> of<\/span> shared<\/span> memory<\/span>\r\npg_dump:<\/span> [<\/span>archiver<\/span> (<\/span>db<\/span>)]<\/span> query<\/span> failed:<\/span> ERROR:<\/span>  out<\/span> of<\/span> shared<\/span> memory<\/span>\r\nHINT:<\/span>  You<\/span> might<\/span> need<\/span> to<\/span> increase<\/span> max_locks_per_transaction.<\/span>\r\npg_dump:<\/span> [<\/span>archiver<\/span> (<\/span>db<\/span>)]<\/span> query<\/span> was:<\/span> LOCK<\/span> TABLE<\/span> public.test2_2575<\/span> IN<\/span> ACCESS<\/span> SHARE<\/span> MODE<\/span>\r\n<\/code><\/pre>\n
\u9519\u8bef\u3002\u521b\u5efa\u51cf\u5c11\u8868\u683c\u7684Shell\u811a\u672c\u3002<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># vi droptable.sh<\/span>\r\n#!\/bin\/bash<\/span>\r\nfor<\/span> i<\/span> in<\/span> `s<\/span>eq<\/span> 1<\/span> 1000<\/span>`\r\n<\/span>do<\/span>\r\n  psql<\/span> -U<\/span> postgres<\/span> -c<\/span> \"DROP TABLE IF EXISTS test2_<\/span>$i<\/span>;\"<\/span> -d<\/span> test<\/span>\r\ndone<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># bash .\/droptable.sh<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\n\u30fb\u30fb\u30fb\u4e2d\u7565\u30fb\u30fb\u30fb<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\nDROP<\/span> TABLE<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span>#<\/span>\r\n<\/code><\/pre>\n
\u5c1d\u8bd5\u8fdb\u884cpg_dump<\/p>\n
[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span># pg_dump -s -U postgres -f test01.sql test<\/span>\r\n[<\/span>root<\/span>@<\/span>54<\/span>ab4f90d9e7<\/span> tmp<\/span>]<\/span>#<\/span>\r\n<\/code><\/pre>\n
\u53d6\u5f97\u4e86\u76ee\u6807\u3002<\/p>\n
\u603b\u7ed3\u4e00\u4e0b<\/h1>\n
\u5982\u679c\u5728\u6267\u884cpg_dump\u65f6\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\uff0c\u53ef\u4ee5\u8003\u8651\u4e24\u79cd\u89e3\u51b3\u65b9\u6cd5\u3002<\/p>\n
pg_dump: WARNING:  out of shared memory\r\npg_dump: [archiver (db)] query failed: ERROR:  out of shared memory\r\n<\/code><\/pre>\n
    \n
  1. \n
      \u589e\u52a0 max_locks_per_transaction \u7684\u8bbe\u5b9a\u503c<\/ol>\n<\/li>\n<\/ol>\n
       <\/p>\n
        \u51cf\u5c11\u8868\u7684\u6570\u91cf<\/ol>\n
        \u5982\u679c\u684c\u5b50\u592a\u591a\uff0c\u9996\u5148\u5e94\u4f18\u5148\u8003\u8651\u51cf\u5c11\u684c\u5b50\u7684\u6570\u91cf\u3002
        \n\u5982\u679c\u6709\u65e0\u7528\u7684\u684c\u5b50\uff0c\u6216\u8005\u5b58\u5728\u5305\u542b\u8fc7\u53bb\u6570\u636e\u4e14\u518d\u4e5f\u4e0d\u4f1a\u4f7f\u7528\u7684\u5b50\u8868\uff0c\u5e94\u8be5\u5c06\u5176\u5220\u9664\uff01
        \n\uff08\u6709\u592a\u591a\u65e0\u7528\u7684\u684c\u5b50\u672c\u8eab\u5c31\u662f\u4e2a\u95ee\u9898\uff09<\/p>\n
        \u5982\u679c\u65e0\u6cd5\u51cf\u5c11\u8868\u7684\u6570\u91cf\uff0c\u53ea\u80fd\u589e\u52a0max_locks_per_transaction\u7684\u8bbe\u7f6e\u503c\u3002
        \n\u7136\u800c\uff0c\u5982\u679c\u66f4\u6539max_locks_per_transaction\uff0c\u8fd8\u4f1a\u589e\u52a0\u5171\u4eab\u5185\u5b58\u7684\u6d88\u8017\u3002<\/p>\n
        \u8bf7\u53c2\u8003<\/h1>\n
          \n
        • \n
            Docker\u3067CentOS 7\u306e\u30a4\u30e1\u30fc\u30b8\u3092\u5229\u7528\u3057\u3066\u307f\u3088\u3046<\/ul>\n<\/li>\n<\/ul>\n
             <\/p>\n
              \n
            • \n
                PostgreSQL \u3092 CentOS \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306b\u306f<\/ul>\n<\/li>\n<\/ul>\n
                 <\/p>\n
                  CentOS7\u4e0a\u306b\u3001Docker CentOS7\u3001PostgreSQL 10.5\u30b3\u30f3\u30c6\u30ca\u3092\u7acb\u3066\u308b<\/ul>\n","protected":false},"excerpt":{"rendered":"
                  \u9996\u5148 \u6211\u5728\u5de5\u4f5c\u4e2d\u7ecf\u5e38\u4f7f\u7528pg_dump\u5b9a\u671f\u5907\u4efd\u6a21\u5f0f\uff0c\u4f46\u6709\u4e00\u5929\u7a81\u7136\u95f4\u2026\u2026 \u9519\u8bef\uff1a\u5171\u4eab\u5185\u5b58\u4e0d\u8db3 \u63d0\u793a\uff1a\u60a8\u53ef\u80fd\u9700\u8981\u589e […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41738","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u7531\u4e8epg_dump\u51fa\u73b0\u4e86"out of shared memory"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173 - 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\/\u7531\u4e8epg_dump\u51fa\u73b0\u4e86out-of-shared-memory\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86"out of shared memory"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u6211\u5728\u5de5\u4f5c\u4e2d\u7ecf\u5e38\u4f7f\u7528pg_dump\u5b9a\u671f\u5907\u4efd\u6a21\u5f0f\uff0c\u4f46\u6709\u4e00\u5929\u7a81\u7136\u95f4\u2026\u2026 \u9519\u8bef\uff1a\u5171\u4eab\u5185\u5b58\u4e0d\u8db3 \u63d0\u793a\uff1a\u60a8\u53ef\u80fd\u9700\u8981\u589e […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u7531\u4e8epg_dump\u51fa\u73b0\u4e86out-of-shared-memory\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T17:10:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T17:55:23+00:00\" \/>\n<meta name=\"author\" content=\"\u9038, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u9038, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 \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\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/\",\"name\":\"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86\\\"out of shared memory\\\"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-11-21T17:10:33+00:00\",\"dateModified\":\"2024-04-29T17:55:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86”out of shared memory”\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173\"}]},{\"@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\/85c1dae56e6ea1e695c73d33c684d487\",\"name\":\"\u9038, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g\",\"caption\":\"\u9038, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keyi\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86\"out of shared memory\"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173 - 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\/\u7531\u4e8epg_dump\u51fa\u73b0\u4e86out-of-shared-memory\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\/","og_locale":"zh_CN","og_type":"article","og_title":"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86\"out of shared memory\"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173","og_description":"\u9996\u5148 \u6211\u5728\u5de5\u4f5c\u4e2d\u7ecf\u5e38\u4f7f\u7528pg_dump\u5b9a\u671f\u5907\u4efd\u6a21\u5f0f\uff0c\u4f46\u6709\u4e00\u5929\u7a81\u7136\u95f4\u2026\u2026 \u9519\u8bef\uff1a\u5171\u4eab\u5185\u5b58\u4e0d\u8db3 \u63d0\u793a\uff1a\u60a8\u53ef\u80fd\u9700\u8981\u589e […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u7531\u4e8epg_dump\u51fa\u73b0\u4e86out-of-shared-memory\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-11-21T17:10:33+00:00","article_modified_time":"2024-04-29T17:55:23+00:00","author":"\u9038, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u9038, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"15 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/","name":"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86\"out of shared memory\"\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-11-21T17:10:33+00:00","dateModified":"2024-04-29T17:55:23+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u7531\u4e8epg_dump\u51fa\u73b0\u4e86”out of shared memory”\u9519\u8bef\uff0c\u6211\u60f3\u8981\u9a8c\u8bc1\u4e00\u4e0b\u662f\u5426\u4e0e\u8868\u7684\u6570\u91cf\u6709\u5173"}]},{"@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\/85c1dae56e6ea1e695c73d33c684d487","name":"\u9038, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g","caption":"\u9038, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keyi\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%b1%e4%ba%8epg_dump%e5%87%ba%e7%8e%b0%e4%ba%86out-of-shared-memory%e9%94%99%e8%af%af%ef%bc%8c%e6%88%91%e6%83%b3%e8%a6%81%e9%aa%8c%e8%af%81%e4%b8%80%e4%b8%8b%e6%98%af%e5%90%a6%e4%b8%8e\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41738","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41738"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41738\/revisions"}],"predecessor-version":[{"id":88976,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41738\/revisions\/88976"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}