{"id":41666,"date":"2023-05-11T12:24:12","date_gmt":"2022-11-12T10:34:17","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/"},"modified":"2024-04-30T03:37:33","modified_gmt":"2024-04-29T19:37:33","slug":"%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/","title":{"rendered":"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database"},"content":{"rendered":"<p>\u5728\u4f7f\u7528 Homebrew \u5b89\u88c5 PostgreSQL \u65f6\uff0c\u5982\u679c\u6267\u884c brew update &amp;&amp; brew upgrade \u8fdb\u884c\u66f4\u65b0\u65f6\uff0c\u53ef\u80fd\u4f1a\u5bfc\u81f4 PostgreSQL \u4e5f\u88ab\u66f4\u65b0\uff0c\u5e76\u56e0\u7248\u672c\u4e0d\u5339\u914d\u800c\u65e0\u6cd5\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n<h2>\u9519\u8bef\u793a\u4f8b\uff1aPG::ConnectionBad\uff08\u9002\u7528\u4e8eRails\uff09<\/h2>\n<div><img decoding=\"async\" class=\"post-images\" title=\"Kobito.zFAY7M.png\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488737434c4406cabf9b\/2-0.png\" alt=\"Rails - PG::ConnectionBad\" \/><\/div>\n<p>\u901a\u8fc7\u67e5\u770b\u4ee5\u4e0a\u9519\u8bef\u6d88\u606f\uff0c\u53ef\u4ee5\u63a8\u6d4b\u53ef\u80fd\u662f\u4e0ePG\uff08PostgreSQL\uff09\u76f8\u5173\u7684\u5f71\u54cd\u3002\u56e0\u6b64\uff0c\u5982\u679c\u5b9e\u9645\u6267\u884cPostgreSQL\u547d\u4ee4\uff0c\u5c31\u4f1a\u53d1\u73b0\u9700\u8981\u5355\u72ec\u5bf9PostgreSQL\u8fdb\u884c\u66f4\u65b0\u7684\u5fc5\u8981\u6027\u3002<\/p>\n<pre class=\"post-pre\"><code>\u256d\u2500\u25cb yasulab \u20392.6.5\u203a ~\/coderdojo.jp\r\n\u2570\u2500\u25cb pg_ctl <span class=\"nt\">-D<\/span> \/usr\/local\/var\/postgres start \r\n\r\nwaiting <span class=\"k\">for <\/span>server to start....2020-02-29 10:35:46.814 JST <span class=\"o\">[<\/span>42482] FATAL:  database files are incompatible with server\r\n\r\n2020-02-29 10:35:46.814 JST <span class=\"o\">[<\/span>42482] DETAIL:  The data directory was initialized by PostgreSQL version 11, which is not compatible with this version 12.2.\r\n\r\n stopped waiting\r\n\r\npg_ctl: could not start server\r\nExamine the log output.\r\n<\/code><\/pre>\n<h2>\u7b80\u5355\u7684\u89e3\u51b3\u65b9\u6cd5 de<\/h2>\n<p>\u89e3\u51b3PostgreSQL\u6570\u636e\u5e93\u7684\u65b9\u6cd5\u662f\u53c2\u8003PostgreSQL\u6587\u6863\uff0c\u9010\u6b65\u6267\u884c\u6bcf\u4e2a\u547d\u4ee4\uff08\u4f8b\u5982\uff1a\u8fc1\u79fbHomebrew Postgres\u5230\u65b0\u7248\u672c\uff09\u3002<\/p>\n<p>\u7136\u800c&#8230;!! \u73b0\u5728\u53ef\u4ee5\u4f7f\u7528\u81ea2018\u5e74\u5f15\u5165\u7684brew postgresql-upgrade-database\u547d\u4ee4\uff0cHomebrew\u4f1a\u4e00\u6b21\u6027\u63d0\u4f9b\u65b9\u4fbf\u7684\u652f\u6301\u3002<\/p>\n<pre class=\"post-pre\"><code>\u256d\u2500\u25cb yasulab \u20392.6.5\u203a ~\/coderdojo.jp\r\n\u2570\u2500\u25cb brew postgresql-upgrade-database\r\n\r\n<span class=\"o\">==&gt;<\/span> brew <span class=\"nb\">install <\/span>postgresql@11\r\n<span class=\"o\">==&gt;<\/span> Downloading https:\/\/homebrew.bintray.com\/bottles\/postgresql@11-11.7.catalina.bottle.tar.gz\r\n<span class=\"o\">==&gt;<\/span> Downloading from https:\/\/akamai.bintray.com\/d9\/d9c41a81b4314a10ba40636a2eddf2c48f15c2563754a6fcfd75a20914\r\n<span class=\"c\">######################################################################## 100.0%<\/span>\r\n<span class=\"o\">==&gt;<\/span> Pouring postgresql@11-11.7.catalina.bottle.tar.gz\r\n<span class=\"o\">==&gt;<\/span> \/usr\/local\/Cellar\/postgresql@11\/11.7\/bin\/initdb <span class=\"nt\">--locale<\/span><span class=\"o\">=<\/span>C <span class=\"nt\">-E<\/span> UTF-8 \/usr\/local\/var\/postgresql@11\r\n<span class=\"o\">==&gt;<\/span> Caveats\r\nTo migrate existing data from a previous major version of PostgreSQL run:\r\n  brew postgresql-upgrade-database\r\n\r\npostgresql@11 is keg-only, which means it was not symlinked into \/usr\/local,\r\nbecause this is an alternate version of another formula.\r\n\r\nIf you need to have postgresql@11 first <span class=\"k\">in <\/span>your PATH run:\r\n  <span class=\"nb\">echo<\/span> <span class=\"s1\">'export PATH=\"\/usr\/local\/opt\/postgresql@11\/bin:$PATH\"'<\/span> <span class=\"o\">&gt;&gt;<\/span> ~\/.zshrc\r\n\r\nFor compilers to find postgresql@11 you may need to <span class=\"nb\">set<\/span>:\r\n  <span class=\"nb\">export <\/span><span class=\"nv\">LDFLAGS<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"-L\/usr\/local\/opt\/postgresql@11\/lib\"<\/span>\r\n  <span class=\"nb\">export <\/span><span class=\"nv\">CPPFLAGS<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"-I\/usr\/local\/opt\/postgresql@11\/include\"<\/span>\r\n\r\nFor pkg-config to find postgresql@11 you may need to <span class=\"nb\">set<\/span>:\r\n  <span class=\"nb\">export <\/span><span class=\"nv\">PKG_CONFIG_PATH<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"\/usr\/local\/opt\/postgresql@11\/lib\/pkgconfig\"<\/span>\r\n\r\n\r\nTo have launchd start postgresql@11 now and restart at login:\r\n  brew services start postgresql@11\r\nOr, <span class=\"k\">if <\/span>you don<span class=\"s1\">'t want\/need a background service you can just run:\r\n  pg_ctl -D \/usr\/local\/var\/postgresql@11 start\r\n==&gt; Summary\r\n?  \/usr\/local\/Cellar\/postgresql@11\/11.7: 3,192 files, 36.5MB\r\n==&gt; Upgrading postgresql data from 11 to 12...\r\nwaiting for server to start....2020-02-29 10:40:09.308 JST [44314] LOG:  listening on IPv6 address \"::1\", port 5432\r\n2020-02-29 10:40:09.308 JST [44314] LOG:  listening on IPv4 address \"127.0.0.1\", port 5432\r\n2020-02-29 10:40:09.309 JST [44314] LOG:  listening on Unix socket \"\/tmp\/.s.PGSQL.5432\"\r\n2020-02-29 10:40:09.344 JST [44315] LOG:  database system was interrupted; last known up at 2020-02-28 11:30:09 JST\r\n2020-02-29 10:40:09.662 JST [44315] LOG:  database system was not properly shut down; automatic recovery in progress\r\n2020-02-29 10:40:09.667 JST [44315] LOG:  redo starts at 0\/39B8650\r\n2020-02-29 10:40:09.667 JST [44315] LOG:  invalid record length at 0\/39B8730: wanted 24, got 0\r\n2020-02-29 10:40:09.667 JST [44315] LOG:  redo done at 0\/39B86F8\r\n2020-02-29 10:40:09.683 JST [44314] LOG:  database system is ready to accept connections\r\n done\r\nserver started\r\nwaiting for server to shut down....2020-02-29 10:40:10.039 JST [44314] LOG:  received fast shutdown request\r\n2020-02-29 10:40:10.041 JST [44314] LOG:  aborting any active transactions\r\n2020-02-29 10:40:10.041 JST [44314] LOG:  background worker \"logical replication launcher\" (PID 44321) exited with exit code 1\r\n2020-02-29 10:40:10.042 JST [44316] LOG:  shutting down\r\n2020-02-29 10:40:10.048 JST [44314] LOG:  database system is shut down\r\n done\r\nserver stopped\r\n==&gt; Moving postgresql data from \/usr\/local\/var\/postgres to \/usr\/local\/var\/postgres.old...\r\n==&gt; Creating database...\r\nThe files belonging to this database system will be owned by user \"yasulab\".\r\nThis user must also own the server process.\r\n\r\nThe database cluster will be initialized with locale \"ja_JP.UTF-8\".\r\ninitdb: could not find suitable text search configuration for locale \"ja_JP.UTF-8\"\r\nThe default text search configuration will be set to \"simple\".\r\n\r\nData page checksums are disabled.\r\n\r\nfixing permissions on existing directory \/usr\/local\/var\/postgres ... ok\r\ncreating subdirectories ... ok\r\nselecting dynamic shared memory implementation ... posix\r\nselecting default max_connections ... 100\r\nselecting default shared_buffers ... 128MB\r\nselecting default time zone ... Asia\/Tokyo\r\ncreating configuration files ... ok\r\nrunning bootstrap script ... ok\r\nperforming post-bootstrap initialization ... ok\r\nsyncing data to disk ... ok\r\n\r\ninitdb: warning: 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    \/usr\/local\/opt\/postgresql\/bin\/pg_ctl -D \/usr\/local\/var\/postgres -l logfile start\r\n\r\n==&gt; Migrating and upgrading data...\r\nPerforming Consistency Checks\r\n-----------------------------\r\nChecking cluster versions                                   ok\r\nChecking database user is the install user                  ok\r\nChecking database connection settings                       ok\r\nChecking for prepared transactions                          ok\r\nChecking for reg* data types in user tables                 ok\r\nChecking for contrib\/isn with bigint-passing mismatch       ok\r\nChecking for tables WITH OIDS                               ok\r\nChecking for invalid \"sql_identifier\" user columns          ok\r\nCreating dump of global objects                             ok\r\nCreating dump of database schemas\r\n                                                            ok\r\nChecking for presence of required libraries                 ok\r\nChecking database user is the install user                  ok\r\nChecking for prepared transactions                          ok\r\n\r\nIf pg_upgrade fails after this point, you must re-initdb the\r\nnew cluster before continuing.\r\n\r\nPerforming Upgrade\r\n------------------\r\nAnalyzing all rows in the new cluster                       ok\r\nFreezing all rows in the new cluster                        ok\r\nDeleting files from new pg_xact                             ok\r\nCopying old pg_xact to new server                           ok\r\nSetting next transaction ID and epoch for new cluster       ok\r\nDeleting files from new pg_multixact\/offsets                ok\r\nCopying old pg_multixact\/offsets to new server              ok\r\nDeleting files from new pg_multixact\/members                ok\r\nCopying old pg_multixact\/members to new server              ok\r\nSetting next multixact ID and offset for new cluster        ok\r\nResetting WAL archives                                      ok\r\nSetting frozenxid and minmxid counters in new cluster       ok\r\nRestoring global objects in the new cluster                 ok\r\nRestoring database schemas in the new cluster\r\n                                                            ok\r\nCopying user relation files\r\n                                                            ok\r\nSetting next OID for new cluster                            ok\r\nSync data directory to disk                                 ok\r\nCreating script to analyze new cluster                      ok\r\nCreating script to delete old cluster                       ok\r\n\r\nUpgrade Complete\r\n----------------\r\nOptimizer statistics are not transferred by pg_upgrade so,\r\nonce you start the new server, consider running:\r\n    .\/analyze_new_cluster.sh\r\n\r\nRunning this script will delete the old cluster'<\/span>s data files:\r\n    .\/delete_old_cluster.sh\r\n<span class=\"o\">==&gt;<\/span> Upgraded postgresql data from 11 to 12!\r\n<span class=\"o\">==&gt;<\/span> Your postgresql 11 data remains at \/usr\/local\/var\/postgres.old\r\n<\/code><\/pre>\n<h2>\u987a\u4fbf\u8bf4\u4e00\u4e0b&#8230; shu\u014d y\u012b xi\u00e0&#8230;)<\/h2>\n<p>\u5982\u679c\u66fe\u7ecf\u7528\u76f8\u540c\u7684\u547d\u4ee4\u8fdb\u884c\u8fc7\u5347\u7ea7\uff0c\u90a3\u4e48\u7531\u4e8e postgres.old \u76ee\u5f55\u7684\u5b58\u5728\uff0c\u6267\u884c\u53ef\u80fd\u4f1a\u5728\u4e2d\u9014\u505c\u6b62\u3002<\/p>\n<pre class=\"post-pre\"><code>\u256d\u2500\u25cb yasulab \u20392.6.5\u203a ~\/coderdojo.jp\r\n\u2570\u2500\u25cb brew postgresql-upgrade-database\r\n\r\nError: \/usr\/local\/var\/postgres.old already exists!\r\nRemove it <span class=\"k\">if <\/span>you want to upgrade data automatically.\r\n<\/code><\/pre>\n<p>\u6839\u636e\u4e0a\u8ff0\u4fe1\u606f\uff0c\u5982\u679c\u4e0d\u60f3\u5220\u9664\uff0c\u53ef\u4ee5\u5c06\u5176\u91cd\u65b0\u547d\u540d\u4e3a\u5408\u9002\u7684\u540d\u79f0\u4ee5\u89e3\u51b3\u95ee\u9898\uff0c\u8fd9\u6837\u66f4\u52a0\u653e\u5fc3\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"CoderDojo Japan Top.png\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488737434c4406cabf9b\/13-0.png\" alt=\"CoderDojo Japan Top.png\" \/><\/div>\n<h2>\u76f8\u5173\u6587\u7ae0<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Rails \u3067 DB \u306b\u63a5\u7d9a\u3067\u304d\u306a\u304f\u306a\u3063\u305f\u3068\u304d\u306e\u8003\u3048\u65b9 &#8211; Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>brew-postgresql-upgrade-database: add new command. #21244 &#8211; GitHub<br \/>\nMigrating Homebrew Postgres to a New Version &#8211; Olivier Lacan<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u4f7f\u7528 Homebrew \u5b89\u88c5 PostgreSQL \u65f6\uff0c\u5982\u679c\u6267\u884c brew update &amp;&#038;amp [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41666","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database - 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\/\u5347\u7ea7postgresql\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew-postgresql-upgrade-database\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database\" \/>\n<meta property=\"og:description\" content=\"\u5728\u4f7f\u7528 Homebrew \u5b89\u88c5 PostgreSQL \u65f6\uff0c\u5982\u679c\u6267\u884c brew update &amp;&amp;amp [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5347\u7ea7postgresql\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew-postgresql-upgrade-database\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-12T10:34:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T19:37:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488737434c4406cabf9b\/2-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \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\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/\",\"name\":\"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2022-11-12T10:34:17+00:00\",\"dateModified\":\"2024-04-29T19:37:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database\"}]},{\"@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\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database - 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\/\u5347\u7ea7postgresql\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew-postgresql-upgrade-database\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database","og_description":"\u5728\u4f7f\u7528 Homebrew \u5b89\u88c5 PostgreSQL \u65f6\uff0c\u5982\u679c\u6267\u884c brew update &amp;&amp [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5347\u7ea7postgresql\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew-postgresql-upgrade-database\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2022-11-12T10:34:17+00:00","article_modified_time":"2024-04-29T19:37:33+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488737434c4406cabf9b\/2-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/","name":"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2022-11-12T10:34:17+00:00","dateModified":"2024-04-29T19:37:33+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5347\u7ea7PostgreSQL\u6570\u636e\u5e93\u5f88\u65b9\u4fbf\uff0c\u53ef\u4ee5\u4f7f\u7528brew postgresql-upgrade-database"}]},{"@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\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8d%87%e7%ba%a7postgresql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%88%e6%96%b9%e4%be%bf%ef%bc%8c%e5%8f%af%e4%bb%a5%e4%bd%bf%e7%94%a8brew-postgresql-upgrade-database%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41666","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41666"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41666\/revisions"}],"predecessor-version":[{"id":89448,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41666\/revisions\/89448"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}