\u56e0\u4e3a\u60f3\u8981\u83b7\u5f97OSS-DB\u7684\u8d44\u683c\uff0c\u6240\u4ee5\u6211\u5f00\u59cb\u5b66\u4e60\u6570\u636e\u5e93\u3002
\n\u65e2\u7136\u8981\u5b66\u4e60\uff0c\u4e3a\u4e86\u5907\u5fd8\u8d77\u89c1\uff0c\u6211\u60f3\u5728Qiita\u4e0a\u53d1\u5e03\u4e00\u7bc7\u6587\u7ae0\u3002<\/p>\n
\u8fd9\u6b21\u6211\u4eec\u4f7f\u7528\u4e86VMWare Workstation 17 Player\u6765\u6784\u5efa\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002
\n\u5173\u4e8e\u670d\u52a1\u5668\u7684\u6784\u5efa\u6b65\u9aa4\uff0c\u6211\u4eec\u5c06\u7565\u8fc7\u3002<\/p>\n
\u64cd\u4f5c\u7cfb\u7edf\u4e3aCentOS\uff0c\u7248\u672c\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
[root@localhost ~]# cat \/etc\/redhat-release\r\nCentOS Linux release 7.9.2009 (Core)\r\n<\/code><\/pre>\n\u4ece\u5b89\u88c5\u5230\u542f\u52a8Postgresql-14<\/h1>\nPostgreSQL \u5b89\u88c5<\/h2>\n
\u4ee5\u4e0b\u662f\u5b89\u88c5\u5230\u542f\u52a8\u7684\u4e00\u7cfb\u5217\u6b65\u9aa4\u7684\u8bf4\u660e\u3002\u672c\u6b21\u5c06\u4ecb\u7ecd PostgreSQL-14 \u7684\u64cd\u4f5c\u6b65\u9aa4\u3002<\/p>\n
\u5b89\u88c5\u4ed3\u5e93\u5305\u3002<\/h3>\n
\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u4ee5\u5b89\u88c5\u5b58\u50a8\u5e93\u8f6f\u4ef6\u5305\u3002
\n\u5982\u679c\u8f93\u51fa\u663e\u793a”\u5b8c\u6210\uff01”\u8868\u793aOK\u3002<\/p>\n
[root@localhost ~]# yum -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\r\n<\/code><\/pre>\n\u66f4\u65b0 yum<\/h3>\n
\u6211\u8981\u8fdb\u884cyum\u7684\u66f4\u65b0\u3002<\/p>\n
[root@localhost ~]# yum -y update\r\n<\/code><\/pre>\n\u786e\u8ba4\u53ef\u7528\u7684\u8f6f\u4ef6\u5305<\/h3>\n
\u83b7\u53d6\u5f53\u524d\u53ef\u7528\u7684\u8f6f\u4ef6\u5305\u5217\u8868\u3002
\n\u4ece\u4e2d\u9009\u62e9\u559c\u6b22\u7684\u7248\u672c\u3002
\n\u8fd9\u6b21\u6211\u9009\u62e9postgresql14-server\u3002<\/p>\n
[root@localhost ~]# yum list available | grep postgresql | grep server\r\npostgresql-server.x86_64 9.2.24-8.el7_9 updates\r\npostgresql11-server.x86_64 11.20-1PGDG.rhel7 pgdg11\r\npostgresql12-server.x86_64 12.15-1PGDG.rhel7 pgdg12\r\npostgresql13-server.x86_64 13.11-1PGDG.rhel7 pgdg13\r\npostgresql14-server.x86_64 14.8-1PGDG.rhel7 pgdg14\r\npostgresql15-server.x86_64 15.3-1PGDG.rhel7 pgdg15\r\n<\/code><\/pre>\n\u5b89\u88c5<\/h3>\n
\u4ece\u4e4b\u524d\u786e\u8ba4\u8fc7\u7684\u5305\u4e2d\u5b89\u88c5\u6240\u9700\u7684\u7248\u672c\u3002<\/p>\n
[root@localhost ~]# yum install -y postgresql14-server\r\n<\/code><\/pre>\n\u7248\u672c\u786e\u8ba4<\/h3>\n
\u6211\u4f1a\u786e\u8ba4\u662f\u5426\u5df2\u5b89\u88c5\u3002<\/p>\n
[root@localhost ~]# psql --version\r\npsql (PostgreSQL) 14.8\r\n<\/code><\/pre>\n\u5176\u4ed6\u786e\u8ba4<\/h3>\n
\u9996\u5148\u786e\u8ba4\u662f\u5426\u5b58\u5728 postgres \u7528\u6237\u3002<\/p>\n
[root@localhost ~]# cat \/etc\/passwd | grep postgres\r\npostgres:x:26:26:PostgreSQL Server:\/var\/lib\/pgsql:\/bin\/bash\r\n<\/code><\/pre>\n\u7531\u4e8e\u4e3b\u76ee\u5f55\u5df2\u8bbe\u4e3a\/var\/lib\/pgsql\uff0c\u56e0\u6b64\u9700\u8981\u786e\u8ba4\u8be5\u4f4d\u7f6e\u3002\u6240\u6709\u8005\u548c\u7fa4\u7ec4\u90fd\u662fpostgres\u3002<\/p>\n
[root@localhost ~]# ls -ld \/var\/lib\/pgsql\r\ndrwx------. 3 postgres postgres 37 Jul 17 16:30 \/var\/lib\/pgsql\r\n<\/code><\/pre>\n\u542f\u52a8\u6570\u636e\u5e93<\/h2>\n
\u56e0\u4e3a\u987a\u5229\u5b89\u88c5\u5b8c\u6210\uff0c\u6211\u6253\u7b97\u542f\u52a8\u6570\u636e\u5e93\u3002<\/p>\n
\u8fd9\u6b21\u6211\u4eec\u4e0d\u6253\u7b97\u5728\/var\/lib\/pgsql\u4e0b\u521b\u5efa\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u800c\u662f\u60f3\u5c1d\u8bd5\u5728\/database\u4e0b\u521b\u5efa\u3002<\/p>\n
\u521b\u5efa\u76ee\u5f55<\/h3>\n
\u521b\u5efa\u6570\u636e\u5e93\u76ee\u5f55\u533a\u57df\u3002<\/p>\n
[root@localhost ~]# mkdir \/database\r\n<\/code><\/pre>\n\u6302\u8f7d\u78c1\u76d8<\/h3>\n
\u6839\u636e\u9700\u8981\uff0c\u53c2\u8003\u6b64\u5904\u7684\u6307\u5357\uff0c\u5728\/database\u4e0a\u6302\u8f7d\u78c1\u76d8\u3002<\/p>\n
\u521b\u5efa\u76ee\u5f55<\/h3>\n
\u521b\u5efa \/database\/data \u548c \/database\/backup \u6587\u4ef6\u5939\u3002
\n\u524d\u8005\u5c06\u7528\u4f5c\u6570\u636e\u5e93\u96c6\u7fa4\u3002
\n\u540e\u8005\u5c06\u7528\u4f5c\u6570\u636e\u5e93\u5907\u4efd\u3002<\/p>\n
[root@localhost ~]# mkdir \/database\/{data,backup}\r\n<\/code><\/pre>\n\u53d8\u66f4\u6240\u6709\u8005\u3001\u56e2\u4f53<\/h3>\n
\u7531\u4e8e\u4f7f\u7528root\u8fdb\u884c\u521b\u5efa\uff0c\u6240\u4ee5\u6211\u4eec\u4f1a\u6539\u6210\u4f7f\u7528postgres\u3002<\/p>\n
[root@localhost ~]# chown -R postgres:postgres \/database\/\r\n<\/code><\/pre>\n\u53ea\u8981\u6ee1\u8db3\u4ee5\u4e0b\u6761\u4ef6\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n
[root@localhost ~]# ls -ld \/database\/\r\ndrwxr-xr-x. 4 postgres postgres 32 Jul 17 16:39 \/database\/\r\n[root@localhost ~]#\r\n[root@localhost ~]# ls -la \/database\/\r\ntotal 0\r\ndrwxr-xr-x. 4 postgres postgres 32 Jul 17 16:39 .\r\ndr-xr-xr-x. 18 root root 240 Jul 17 16:39 ..\r\ndrwxr-xr-x. 2 postgres postgres 6 Jul 17 16:39 backup\r\ndrwxr-xr-x. 2 postgres postgres 6 Jul 17 16:39 data\r\n<\/code><\/pre>\n\u521b\u5efa\u6570\u636e\u5e93\u96c6\u7fa4<\/h3>\n
\u9996\u5148\uff0c\u5207\u6362\u5230postgres\u7528\u6237\u3002<\/p>\n
[root@localhost ~]# su - postgres\r\n<\/code><\/pre>\n\u6210\u529f\u3002\u60a8\u73b0\u5728\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u542f\u52a8\u6570\u636e\u5e93\u670d\u52a1\u5668\uff1a\u5982\u679c\u51fa\u73b0\u201cOK\u201d\u7684\u6d88\u606f\uff0c\u8868\u793a\u6210\u529f\u3002\u5982\u679c\u51fa\u73b0\u201cbash: initdb: command not found\u201d\u7684\u9519\u8bef\u63d0\u793a\uff0c\u8bf7\u53c2\u8003\u201ccommand not found\u201d\u7684\u89e3\u51b3\u65b9\u6cd5\u3002<\/p>\n
[postgres@localhost ~]# initdb -D \/database\/data\r\n<\/code><\/pre>\n\u786e\u8ba4\u521b\u5efa\u6570\u636e\u5e93\u96c6\u7fa4\u3002<\/h3>\n
\u6211\u4f1a\u786e\u8ba4\u662f\u5426\u6309\u7167\u6b63\u786e\u7684\u6b65\u9aa4\u8fdb\u884c\u4e86\u5236\u4f5c\u3002<\/p>\n
[postgres@localhost ~]$ ls -al \/database\/data\/\r\ntotal 60\r\ndrwx------. 19 postgres root 4096 Jul 17 16:50 .\r\ndrwxr-xr-x. 4 postgres root 32 Jul 17 16:39 ..\r\ndrwx------. 5 postgres postgres 41 Jul 17 16:50 base\r\ndrwx------. 2 postgres postgres 4096 Jul 17 16:50 global\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_commit_ts\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_dynshmem\r\n-rw-------. 1 postgres postgres 4789 Jul 17 16:50 pg_hba.conf\r\n-rw-------. 1 postgres postgres 1636 Jul 17 16:50 pg_ident.conf\r\ndrwx------. 4 postgres postgres 68 Jul 17 16:50 pg_logical\r\ndrwx------. 4 postgres postgres 36 Jul 17 16:50 pg_multixact\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_notify\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_replslot\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_serial\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_snapshots\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_stat\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_stat_tmp\r\ndrwx------. 2 postgres postgres 18 Jul 17 16:50 pg_subtrans\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_tblspc\r\ndrwx------. 2 postgres postgres 6 Jul 17 16:50 pg_twophase\r\n-rw-------. 1 postgres postgres 3 Jul 17 16:50 PG_VERSION\r\ndrwx------. 3 postgres postgres 60 Jul 17 16:50 pg_wal\r\ndrwx------. 2 postgres postgres 18 Jul 17 16:50 pg_xact\r\n-rw-------. 1 postgres postgres 88 Jul 17 16:50 postgresql.auto.conf\r\n-rw-------. 1 postgres postgres 28782 Jul 17 16:50 postgresql.conf\r\n<\/code><\/pre>\n\u4fee\u6539\u5355\u5143\u6587\u4ef6<\/h3>\n
\u9996\u5148\uff0c\u9700\u8981\u66f4\u6539\u7528\u4e8e\u542f\u52a8postgresql-14\u7684\u5355\u4f4d\u6587\u4ef6\u7684\u8bbe\u7f6e\u3002
\n\u9996\u5148\uff0c\u8fd4\u56de\u5230root\u7528\u6237\u3002<\/p>\n
[postgres@localhost ~]# exit\r\n<\/code><\/pre>\n\u63a5\u4e0b\u6765\u662f\u5355\u4f4d\u6587\u4ef6\u7684\u4fee\u6539\u3002<\/p>\n
[root@localhost ~]# vi \/usr\/lib\/systemd\/system\/postgresql-14.service\r\n<\/code><\/pre>\n\u4fee\u8ba2\u90e8\u5206\u5982\u4e0b\u6240\u793a\u3002
\n\u6211\u6240\u6539\u53d8\u7684\u662f\u73af\u5883\u53d8\u91cfPGDATA\u7684\u503c\u3002
\nPGDATA\u7684\u503c\u5b9a\u4e49\u4e86\u6570\u636e\u5e93\u7fa4\u96c6\u7684\u8def\u5f84\u3002<\/p>\n
\u8fd9\u6b21\u6211\u4eec\u5728initdb\u65f6\u6307\u5b9a\u4e86\/database\/data\/\u8def\u5f84\uff0c\u6240\u4ee5\u9700\u8981\u66f4\u6539\u4e3a\u8be5\u8def\u5f84\u3002<\/p>\n
Environment=PGDATA=\/var\/lib\/pgsql\/14\/data\/\t\t\t\u2605 \u4fee\u6b63\u524d\r\nEnvironment=PGDATA=\/database\/data\/\t\t\t\t\t\u2605 \u4fee\u6b63\u5f8c\r\n<\/code><\/pre>\n\u6539\u53d8\u540e\uff0c\u5c06\u5448\u73b0\u5982\u4e0b\u6240\u793a\u7684\u72b6\u6001\u3002<\/p>\n
[root@localhost ~]# cat \/usr\/lib\/systemd\/system\/postgresql-14.service\r\n# It's not recommended to modify this file in-place, because it will be\r\n# overwritten during package upgrades. It is recommended to use systemd\r\n# \"dropin\" feature; i.e. create file with suffix .conf under\r\n# \/etc\/systemd\/system\/postgresql-14.service.d directory overriding the\r\n# unit's defaults. You can also use \"systemctl edit postgresql-14\"\r\n# Look at systemd.unit(5) manual page for more info.\r\n\r\n# Note: changing PGDATA will typically require adjusting SELinux\r\n# configuration as well.\r\n\r\n# Note: do not use a PGDATA pathname containing spaces, or you will\r\n# break postgresql-14-setup.\r\n[Unit]\r\nDescription=PostgreSQL 14 database server\r\nDocumentation=https:\/\/www.postgresql.org\/docs\/14\/static\/\r\nAfter=syslog.target\r\nAfter=network-online.target\r\n\r\n[Service]\r\nType=notify\r\n\r\nUser=postgres\r\nGroup=postgres\r\n\r\n# Note: avoid inserting whitespace in these Environment= lines, or you may\r\n# break postgresql-setup.\r\n\r\n# Location of database directory\r\n#Environment=PGDATA=\/var\/lib\/pgsql\/14\/data\/\t\t\t\u2605 \u4fee\u6b63\u524d\r\nEnvironment=PGDATA=\/database\/data\/\t\t\t\t\t\u2605 \u4fee\u6b63\u5f8c\r\n\r\n# Where to send early-startup messages from the server (before the logging\r\n# options of postgresql.conf take effect)\r\n# This is normally controlled by the global default set by systemd\r\n# StandardOutput=syslog\r\n\r\n# Disable OOM kill on the postmaster\r\nOOMScoreAdjust=-1000\r\nEnvironment=PG_OOM_ADJUST_FILE=\/proc\/self\/oom_score_adj\r\nEnvironment=PG_OOM_ADJUST_VALUE=0\r\n\r\nExecStartPre=\/usr\/pgsql-14\/bin\/postgresql-14-check-db-dir ${PGDATA}\r\nExecStart=\/usr\/pgsql-14\/bin\/postmaster -D ${PGDATA}\r\nExecReload=\/bin\/kill -HUP $MAINPID\r\nKillMode=mixed\r\nKillSignal=SIGINT\r\n\r\n# Do not set any timeout value, so that systemd will not kill postmaster\r\n# during crash recovery.\r\nTimeoutSec=0\r\n\r\n# 0 is the same as infinity, but \"infinity\" needs systemd 229\r\nTimeoutStartSec=0\r\n\r\nTimeoutStopSec=1h\r\n\r\n[Install]\r\nWantedBy=multi-user.target\r\n<\/code><\/pre>\n\u91cd\u65b0\u52a0\u8f7d\u5b88\u62a4\u8fdb\u7a0b<\/h3>\n
\u5728\u66f4\u6539\u5355\u5143\u6587\u4ef6\u540e\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u3002
\n\u53ef\u80fd\u5728\u9996\u6b21\u542f\u52a8\u65f6\u4e0d\u6267\u884c\u4e5f\u6ca1\u5173\u7cfb\u5427\uff1f<\/p>\n
[root@localhost ~]# systemctl daemon-reload\r\n<\/code><\/pre>\n\u670d\u52a1\u542f\u52a8<\/h3>\n
\u542f\u52a8PostgreSQL\u3002<\/p>\n
[root@localhost ~]# systemctl start postgresql-14\r\n<\/code><\/pre>\n\u786e\u8ba4\u542f\u52a8\u72b6\u6001<\/h3>\n
\u786e\u8ba4\u662f\u5426\u6b63\u5e38\u542f\u52a8\u3002
\n\u5982\u679c\u8f93\u51fa\u4e3a\u201cactive: active (running)\u201d\uff0c\u5219\u8868\u793a\u6b63\u5e38\u3002<\/p>\n
[root@localhost ~]# systemctl status postgresql-14\r\n<\/code><\/pre>\n\u8fde\u63a5\u6570\u636e\u5e93<\/h3>\n
\u6211\u4f1a\u5c1d\u8bd5\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002\u9996\u5148\uff0c\u6211\u4f1a\u66f4\u6539\u7528\u6237\u3002<\/p>\n
[root@localhost ~]# su - postgres\r\n<\/code><\/pre>\n\u6570\u636e\u5e93\u8fde\u63a5 (DB\u8fde\u63a5)<\/p>\n
[postgres@localhost ~]$ psql\r\npsql (14.8)\r\nType \"help\" for help.\r\n\r\npostgres=#\r\n<\/code><\/pre>\n\u9000\u51fa\u53ea\u9700\u70b9\u51fb\\q\u3002<\/p>\n
\u6dfb\u52a0\u5907\u6ce8<\/h1>\n2023\u5e747\u670817\u65e5 \u66f4\u65b0<\/h2>\npostgresql-14 \u7684\u81ea\u52d5\u542f\u52a8\u8bbe\u7f6e<\/h3>\n
\u5982\u679c\u6309\u7167\u4e0a\u8ff0\u6b65\u9aa4\u8fdb\u884c\u64cd\u4f5c\uff0c\u670d\u52a1\u5668\u5728\u91cd\u65b0\u542f\u52a8\u65f6\u4f1a\u5bfc\u81f4\u6570\u636e\u5e93\u505c\u6b62\u3002
\n\u5982\u679c\u8981\u5c06postgresql-14\u8bbe\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8\uff0c\u8bf7\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u3002<\/p>\n
[root@localhost ~]# systemctl enable postgresql-14\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-14.service to \/usr\/lib\/systemd\/system\/postgresql-14.service.\r\n<\/code><\/pre>\n\u4e3a\u4e86\u786e\u4fdd\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u8fdb\u884c\u786e\u8ba4\u3002\u5982\u679c\u8f93\u51fa\u4e3a enabled\uff0c\u5219\u8868\u793a\u6b63\u5e38\u3002<\/p>\n
[root@localhost ~]# systemctl is-enabled postgresql-14\r\n<\/code><\/pre>\n\u4fee\u6539 .bash_profile \u6587\u4ef6<\/h3>\n
\u6211\u5c06\u4fee\u6539.bash_profile\u6587\u4ef6\u7684\u4e00\u90e8\u5206\u5185\u5bb9\u3002
\n\u5373\u4f7f\u4e0d\u8fdb\u884c\u4fee\u6539\uff0c\u542f\u52a8\u7b49\u64cd\u4f5c\u4e5f\u53ef\u4ee5\u6b63\u5e38\u8fdb\u884c\u3002<\/p>\n
\u9996\u5148\uff0c\u5c06\u7528\u6237\u66f4\u6539\u4e3apostgres\u3002<\/p>\n
[root@localhost ~]# su - postgres\r\n<\/code><\/pre>\n\u7f16\u8f91 .bash_profile<\/p>\n
\u8fd9\u662f\u7c7b\u4f3c\u4e8e\u7f16\u8f91\u5355\u5143\u6587\u4ef6\u7684\u4fee\u6b63\u3002
\n\u4fee\u6539\u524d\uff1aPGDATA=\/var\/lib\/pgsql\/14\/data
\n\u4fee\u6539\u540e\uff1aPGDATA=\/database\/data<\/p>\n
[postgres@localhost ~]# vi ~\/.bash_profile\r\n<\/code><\/pre>\n\u4fee\u6b63\u540e\u7684\u611f\u89c9\u5982\u4e0b\u6240\u793a<\/p>\n
[postgres@localhost ~]$ cat ~\/.bash_profile\r\n[ -f \/etc\/profile ] && source \/etc\/profile\r\n# PGDATA=\/var\/lib\/pgsql\/14\/data \u2605 \u4fee\u6b63\u524d\r\nPGDATA=\/database\/data \u2605 \u4fee\u6b63\u5f8c\r\nexport PGDATA\r\nexport PATH=\/usr\/pgsql-14\/bin:$PATH\r\n# If you want to customize your settings,\r\n# Use the file below. This is not overridden\r\n# by the RPMS.\r\n[ -f \/var\/lib\/pgsql\/.pgsql_profile ] && source \/var\/lib\/pgsql\/.pgsql_profile\r\nPS1='[\\u@\\h \\W]\\$'\r\n<\/code><\/pre>\n\u4ee5\u4e0a<\/p>\n
2023\/07\/18 \u8865\u5145<\/h2>\n
\u7531\u4e8e\u5728VMWare\u4e0a\u53ef\u4ee5\u6dfb\u52a0\u78c1\u76d8\uff0c\u56e0\u6b64\u6211\u4eec\u5c06\u6dfb\u52a0\u7684\u78c1\u76d8\u7528\u4f5c\u6570\u636e\u5e93\u533a\u57df\u3002<\/p>\n
\u8bf7\u786e\u8ba4\u78c1\u76d8<\/h3>\n
\u9996\u5148\uff0c\u68c0\u67e5\u64cd\u4f5c\u7cfb\u7edf\u662f\u5426\u80fd\u591f\u8bc6\u522b\u5230\u5df2\u7ecf\u6dfb\u52a0\u7684\u78c1\u76d8\u3002sdb \u662f\u6dfb\u52a0\u7684\u78c1\u76d8\uff0c\u76ee\u524d\u5c1a\u672a\u6302\u8f7d\u3002<\/p>\n
[root@localhost ~]# lsblk\r\nNAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT\r\nsda 8:0 0 20G 0 disk\r\ntqsda1 8:1 0 300M 0 part \/boot\r\ntqsda2 8:2 0 2G 0 part [SWAP]\r\nmqsda3 8:3 0 17.7G 0 part \/\r\nsdb 8:16 0 20G 0 disk\r\nsr0 11:0 1 1024M 0 rom\r\n<\/code><\/pre>\n\u68c0\u67e5\u78c1\u76d8\u662f\u5426\u5b58\u5728\u6587\u4ef6\u7cfb\u7edf\u3002
\n\u5982\u679c\u8f93\u51fa\u53ea\u663e\u793a\u6570\u636e\uff0c\u5219\u8868\u793a\u8bbe\u5907\u4e0a\u4e0d\u5b58\u5728\u6587\u4ef6\u7cfb\u7edf\u3002<\/p>\n
[root@localhost ~]# file -s \/dev\/sdb\r\n\/dev\/sdb: data\r\n<\/code><\/pre>\n\u521b\u5efa\u6587\u4ef6\u7cfb\u7edf\u3002<\/p>\n
[root@localhost ~]# mkfs -t xfs \/dev\/sdb\r\nmeta-data=\/dev\/sdb isize=512 agcount=4, agsize=1310720 blks\r\n = sectsz=512 attr=2, projid32bit=1\r\n = crc=1 finobt=0, sparse=0\r\ndata = bsize=4096 blocks=5242880, imaxpct=25\r\n = sunit=0 swidth=0 blks\r\nnaming =version 2 bsize=4096 ascii-ci=0 ftype=1\r\nlog =internal log bsize=4096 blocks=2560, version=2\r\n = sectsz=512 sunit=0 blks, lazy-count=1\r\nrealtime =none extsz=4096 blocks=0, rtextents=0\r\n<\/code><\/pre>\n\u518d\u6b21\u68c0\u67e5\u78c1\u76d8\u7684\u6587\u4ef6\u7cfb\u7edf\u3002
\n\u8fd9\u6b21\u53ef\u4ee5\u786e\u8ba4\u6587\u4ef6\u7cfb\u7edf\u4e3aXFS\u3002<\/p>\n
[root@localhost ~]# file -s \/dev\/sdb\r\n\/dev\/sdb: SGI XFS filesystem data (blksz 4096, inosz 512, v2 dirs)\r\n<\/code><\/pre>\n\u6211\u50b2\u6162\u81ea\u5927\u3002<\/p>\n
[root@localhost ~]# mount \/dev\/sdb \/database\r\n<\/code><\/pre>\n\u786e\u8ba4\u662f\u5426\u5df2\u7ecf\u6302\u8f7d\u3002
\n\u7531\u4e8esdb\u7684\u6302\u8f7d\u70b9\u662f\/database\uff0c\u6240\u4ee5OK\u3002<\/p>\n
[root@localhost ~]# lsblk\r\nNAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT\r\nsda 8:0 0 20G 0 disk\r\ntqsda1 8:1 0 300M 0 part \/boot\r\ntqsda2 8:2 0 2G 0 part [SWAP]\r\nmqsda3 8:3 0 17.7G 0 part \/\r\nsdb 8:16 0 20G 0 disk \/database\r\nsr0 11:0 1 1024M 0 rom\r\n<\/code><\/pre>\n\u987a\u4fbf\u68c0\u67e5\u4e00\u4e0b\/database\u7684\u5bb9\u91cf\u3002
\n\u770b\u8d77\u6765\u53ef\u7528\u7a7a\u95f4\u670920GB\uff0c\u6240\u4ee5\u53ef\u4ee5\u3002<\/p>\n
[root@localhost ~]# df\r\nFilesystem 1K-blocks Used Available Use% Mounted on\r\ndevtmpfs 481864 0 481864 0% \/dev\r\ntmpfs 497732 0 497732 0% \/dev\/shm\r\ntmpfs 497732 8480 489252 2% \/run\r\ntmpfs 497732 0 497732 0% \/sys\/fs\/cgroup\r\n\/dev\/sda3 18555904 4929884 13626020 27% \/\r\n\/dev\/sda1 303780 195500 108280 65% \/boot\r\ntmpfs 99548 12 99536 1% \/run\/user\/42\r\ntmpfs 99548 0 99548 0% \/run\/user\/0\r\n\/dev\/sdb 20961280 32992 20928288 1% \/database\r\n<\/code><\/pre>\n\u7531\u4e8e\u5f53\u524d\u7684\u60c5\u51b5\u4e0b\uff0c\u5728\u670d\u52a1\u5668\u91cd\u65b0\u542f\u52a8\u65f6\uff0c\u4f1a\u5bfc\u81f4\u6302\u8f7d\u7684\u72b6\u6001\u4e22\u5931\uff0c\u56e0\u6b64\u6211\u4eec\u9700\u8981\u6dfb\u52a0\u4e00\u4e2a\u5728\u542f\u52a8\u65f6\u81ea\u52a8\u6302\u8f7d\u7684\u8bbe\u7f6e\u3002<\/p>\n
\u663e\u793a\u78c1\u76d8\u7684UUID
\n\u590d\u52361d26f0c5-92f9-4094-9940-db62a98732a2\u3002<\/p>\n
[root@localhost ~]# blkid\r\n\/dev\/sda1: UUID=\"c750867f-9e22-4d79-a2cf-79460c5f3372\" TYPE=\"xfs\"\r\n\/dev\/sda2: UUID=\"675936fb-5c98-47e6-adff-78b404129196\" TYPE=\"swap\"\r\n\/dev\/sda3: UUID=\"ad6eccd5-21b5-491b-af15-8d8a9b8dbe51\" TYPE=\"xfs\"\r\n\/dev\/sdb: UUID=\"1d26f0c5-92f9-4094-9940-db62a98732a2\" TYPE=\"xfs\"\r\n<\/code><\/pre>\n\u8bf7\u5c06\u4ee5\u4e0b\u5185\u5bb9\u6dfb\u52a0\u5230\/etc\/fstab\u7684\u672b\u5c3e\u3002
\n\u8bf7\u5c06UUID\u7684\u503c\u66f4\u6539\u4e3a\u60a8\u81ea\u5df1\u78c1\u76d8\u7684ID\u3002
\n\u5176\u4ed6\u5185\u5bb9\u4fdd\u6301\u4e0d\u53d8\uff0c\u6682\u65f6\u53ef\u4ee5\u4f7f\u7528OK\u3002<\/p>\n
[root@localhost ~]# vi \/etc\/fstab\r\n[root@localhost ~]# cat \/etc\/fstab\r\nUUID=ad6eccd5-21b5-491b-af15-8d8a9b8dbe51 \/ xfs defaults 0 0\r\nUUID=c750867f-9e22-4d79-a2cf-79460c5f3372 \/boot xfs defaults 0 0\r\nUUID=675936fb-5c98-47e6-adff-78b404129196 swap swap defaults 0 0\r\nUUID=1d26f0c5-92f9-4094-9940-db62a98732a2 \/database xfs defaults 0 0\r\n<\/code><\/pre>\n\u53ea\u8981\u91cd\u65b0\u542f\u52a8\u4e14\u5df2\u7ecf\u6302\u8f7d\uff0c\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n
\u9519\u8bef\u5904\u7406<\/h1>\n
\u5728\u6b65\u9aa4\u4e2d\uff0c\u5c06\u8bb0\u5f55\u51fa\u73b0\u9519\u8bef\u7684\u5730\u65b9\u7684\u89e3\u51b3\u65b9\u6cd5\u3002<\/p>\n
\u627e\u4e0d\u5230\u547d\u4ee4<\/h2>\n
\u5982\u679c\u5728\u521b\u5efa\u6570\u636e\u5e93\u96c6\u7fa4\u65f6\u53d1\u751f\u4ee5\u4e0b\u9519\u8bef\u3002<\/p>\n
[postgres@localhost ~]$ initdb -D \/database\/data\r\nbash: initdb: command not found...\r\n<\/code><\/pre>\n\u7528\u6237\u66f4\u6539 h\u00f9<\/h3>\n
\u5c06\u7528\u6237\u66f4\u6539\u4e3apostgres\u3002<\/p>\n
su - postgres\r\n<\/code><\/pre>\n\u4fee\u6539 .bash_profile<\/h3>\n
\u4fee\u6539 .bash_profile \u6587\u4ef6\u3002
\n.bash_profile \u662f\u5728\u767b\u5f55\u65f6\u52a0\u8f7d\u7684\u8bbe\u7f6e\u6587\u4ef6\u3002<\/p>\n
vi ~\/.bash_profile\r\n<\/code><\/pre>\n\u4e0d\u8bba\u54ea\u4e00\u884c\uff0c\u90fd\u8bf7\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n
export PATH=\/usr\/pgsql-14\/bin:$PATH\r\n<\/code><\/pre>\n\u8ffd\u52a0\u540e\u7684\u611f\u89c9\u5982\u4e0b\u3002<\/p>\n
[postgres@localhost ~]$ cat ~\/.bash_profile\r\n[ -f \/etc\/profile ] && source \/etc\/profile\r\nPGDATA=\/var\/lib\/pgsql\/14\/data\r\nexport PGDATA\r\nexport PATH=\/usr\/pgsql-14\/bin:$PATH\t\t\t\u2605\u8ffd\u52a0\r\n# If you want to customize your settings,\r\n# Use the file below. This is not overridden\r\n# by the RPMS.\r\n[ -f \/var\/lib\/pgsql\/.pgsql_profile ] && source \/var\/lib\/pgsql\/.pgsql_profile\r\nPS1='[\\u@\\h \\W]\\$ '\r\n<\/code><\/pre>\n.bash_profile \u7684\u751f\u6548<\/h3>\n
\u7531\u4e8e\u4ec5\u8fdb\u884c\u8bbe\u7f6e\u65e0\u6cd5\u751f\u6548\uff0c\u56e0\u6b64\u9700\u624b\u52a8\u8fdb\u884c\u53cd\u6620\u3002<\/p>\n
source ~\/.bash_profile\r\n<\/code><\/pre>\n\u7531\u4e8e\u524d\u9762\u7684\u5185\u5bb9\u5df2\u5b8c\u6210\uff0c\u56e0\u6b64\u9700\u8981\u91cd\u65b0\u4eceinitdb\u5f00\u59cb\u3002<\/p>\n
\u6700\u540e<\/h1>\n
\u975e\u5e38\u611f\u8c22\u60a8\u89c2\u770b\u5230\u6700\u540e\u3002<\/p>\n
\u6bcf\u6b21\u90fd\u5728\u610f\u7684\u662f\uff0c\u5728\u6784\u5efa\u6570\u636e\u5e93\u65b9\u9762\uff0c\u662f\u7531\u57fa\u7840\u8bbe\u65bd\u56e2\u961f\u8fd8\u662f\u5e94\u7528\u56e2\u961f\u8d1f\u8d23\u5462\uff1f
\n\u867d\u7136\u6211\u662f\u57fa\u7840\u8bbe\u65bd\u5de5\u7a0b\u5e08\uff0c\u4f46\u662f\u6211\u8fd8\u6ca1\u6709\u53c2\u4e0e\u6570\u636e\u5e93\u7684\u6784\u5efa\u8fc7\u5462\u3002\u3002<\/p>\n
\u65e0\u8bba\u54ea\u79cd\u60c5\u51b5\uff0c\u5982\u679c\u53ef\u80fd\u7684\u8bdd\uff0c\u6211\u60f3\u7ee7\u7eed\u5b66\u4e60\uff0c\u56e0\u4e3a\u6211\u53ef\u80fd\u4f1a\u5728\u672a\u6765\u505a\u8fd9\u4ef6\u4e8b\u60c5\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9996\u5148 \u56e0\u4e3a\u60f3\u8981\u83b7\u5f97OSS-DB\u7684\u8d44\u683c\uff0c\u6240\u4ee5\u6211\u5f00\u59cb\u5b66\u4e60\u6570\u636e\u5e93\u3002 \u65e2\u7136\u8981\u5b66\u4e60\uff0c\u4e3a\u4e86\u5907\u5fd8\u8d77\u89c1\uff0c\u6211\u60f3\u5728Qiita\u4e0a\u53d1\u5e03 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41662","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n
\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b - 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\/\u3010db\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8postgresql-14\u7684\u8fc7\u7a0b\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u56e0\u4e3a\u60f3\u8981\u83b7\u5f97OSS-DB\u7684\u8d44\u683c\uff0c\u6240\u4ee5\u6211\u5f00\u59cb\u5b66\u4e60\u6570\u636e\u5e93\u3002 \u65e2\u7136\u8981\u5b66\u4e60\uff0c\u4e3a\u4e86\u5907\u5fd8\u8d77\u89c1\uff0c\u6211\u60f3\u5728Qiita\u4e0a\u53d1\u5e03 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010db\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8postgresql-14\u7684\u8fc7\u7a0b\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T19:12:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T10:28:04+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \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=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \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\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/\",\"name\":\"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-07-25T19:12:17+00:00\",\"dateModified\":\"2024-05-04T10:28:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b\"}]},{\"@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\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b - 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\/\u3010db\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8postgresql-14\u7684\u8fc7\u7a0b\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b","og_description":"\u9996\u5148 \u56e0\u4e3a\u60f3\u8981\u83b7\u5f97OSS-DB\u7684\u8d44\u683c\uff0c\u6240\u4ee5\u6211\u5f00\u59cb\u5b66\u4e60\u6570\u636e\u5e93\u3002 \u65e2\u7136\u8981\u5b66\u4e60\uff0c\u4e3a\u4e86\u5907\u5fd8\u8d77\u89c1\uff0c\u6211\u60f3\u5728Qiita\u4e0a\u53d1\u5e03 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010db\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8postgresql-14\u7684\u8fc7\u7a0b\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-07-25T19:12:17+00:00","article_modified_time":"2024-05-04T10:28:04+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/","name":"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-07-25T19:12:17+00:00","dateModified":"2024-05-04T10:28:04+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010DB\u3011\u4ece\u5b89\u88c5\u5230\u542f\u52a8PostgreSQL-14\u7684\u8fc7\u7a0b"}]},{"@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\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90db%e3%80%91%e4%bb%8e%e5%ae%89%e8%a3%85%e5%88%b0%e5%90%af%e5%8a%a8postgresql-14%e7%9a%84%e8%bf%87%e7%a8%8b\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41662","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41662"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41662\/revisions"}],"predecessor-version":[{"id":99964,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41662\/revisions\/99964"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}