{"id":41712,"date":"2024-01-02T05:31:34","date_gmt":"2024-02-16T06:25:51","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/"},"modified":"2024-05-04T16:25:03","modified_gmt":"2024-05-04T08:25:03","slug":"%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/","title":{"rendered":"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade"},"content":{"rendered":"<p>\u5728\u5f00\u53d1\u73af\u5883\u4e2d\u6267\u884c\u4e86brew update; brew upgrade\u4e4b\u540e\uff0c\u7531\u4e8e\u6700\u65b0\u7248\u672c\u7684PostgreSQL9.5.0\u521a\u521a\u53d1\u5e03\uff0c\u56e0\u6b64\u4f7f\u7528pg_upgrade\u6765\u8fc1\u79fb\u6570\u636e\u5e93\u5185\u5bb9\u3002<\/p>\n<h2>\u51c6\u5907\u5de5\u4f5c<\/h2>\n<p>\u67e5\u8be2\u901a\u8fc7brew\u5b89\u88c5\u7684PostgreSQL9.4\u548c9.5\u7684\u5b89\u88c5\u8def\u5f84\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">9.4\u304c \/usr\/local\/Cellar\/postgresql\/9.4.5_2<\/ul>\n<\/li>\n<\/ul>\n<p>9.5\u304c \/usr\/local\/Cellar\/postgresql\/9.5.0<\/p>\n<p>\u5982\u679c\u8fd9\u6837\u7684\u8bdd\u3002<\/p>\n<p>\u53e6\u5916\uff0c<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3053\u308c\u307e\u3067\u306ePostgreSQL9.4\u306ePGDATA\u30d5\u30a9\u30eb\u30c0\uff08\u53e4\u3044PGDATA\uff09\u306e\u30d1\u30b9\u3092\/database\/data94<\/ul>\n<\/li>\n<\/ul>\n<p>\u65b0\u3057\u304f\u4f5c\u308bPostgreSQL9.5\u306ePGDATA\u30d5\u30a9\u30eb\u30c0\uff08\u65b0\u3057\u3044PGDATA\uff09\u306e\u30d1\u30b9\u3092\/database\/data95<\/p>\n<p>PostgreSQL\u306e\u7ba1\u7406\u30e6\u30fc\u30b6 \u3092foo\uff08\u7279\u306b\u6307\u5b9a\u3057\u3066\u3044\u306a\u3051\u308c\u3070\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u306e\u306f\u305a\uff09<\/p>\n<p>\u5047\u8bbe\u8fd9\u6837\u8bf4\u3002<\/p>\n<h3>\u70ba\u4e86\u5b89\u5168\u8d77\u898b\uff0c\u5c07PostgreSQL 9.4\u7684\u7b26\u865f\u9023\u63a5\u5207\u63db\u81f39.5\u3002<\/h3>\n<p>\u7406\u8bba\u4e0a\uff0c\u5e94\u8be5\u5728\u201cbrew upgrade\u201d\u8fdb\u884c\u5347\u7ea7\u65f6\u81ea\u52a8\u5207\u6362\uff0c\u4f46\u4e3a\u4e86\u4fdd\u9669\u8d77\u89c1\uff0c\u6211\u4eec\u9700\u8981\u786e\u8ba4\u4e00\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code>psql <span class=\"nt\">--version<\/span>\r\n  <span class=\"c\"># psql (PostgreSQL) 9.5.0 \u3068\u8868\u793a<\/span>\r\n  <span class=\"c\"># \u3082\u30579.4\u306e\u307e\u307e\u306e\u5834\u5408\u306f\u3001brew switch\u306a\u3069\u3067\u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af\u3092\u4fee\u6b63<\/span>\r\n  <span class=\"c\"># ex) brew switch postgresql 9.5.0 <\/span>\r\n<\/code><\/pre>\n<h3>\u4e3a\u4e86\u5b89\u5168\u8d77\u89c1\uff0c\u505c\u6b62PostgreSQL 9.4\u3002<\/h3>\n<pre class=\"post-pre\"><code>\/usr\/local\/Cellar\/postgresql\/9.4.5_2\/bin\/pg_ctl stop\r\n<\/code><\/pre>\n<h2>\u521b\u5efa\u5e76\u521d\u59cb\u5316\u4e00\u4e2a\u65b0\u7684PGDATA\u6587\u4ef6\u5939\u3002<\/h2>\n<p>\u4f7f\u7528PostgreSQL 9.5\u6765\u521d\u59cb\u5316initdb\u3002\u8fd9\u65f6\u5019\uff0c<\/p>\n<blockquote><p>\u8bf7\u4f7f\u7528\u4e0e\u65e7\u96c6\u7fa4\u517c\u5bb9\u7684 initdb \u9009\u9879\u3002<\/p><\/blockquote>\n<p>\u8bf7\u6ce8\u610f\uff0c\u6839\u636e\u6587\u4ef6\u4e2d\u7684\u8bb0\u5f55\uff08\u5373\u57289.4\u7248\u672c\u65f6\u901a\u8fc7initdb\u547d\u4ee4\u521b\u5efaPGDATA\u6587\u4ef6\u5939\u65f6\u4f7f\u7528\u7684\u76f8\u540c\u9009\u9879\uff09\uff0c\u5728\u672c\u6587\u4e2d\u4f7f\u7528&#8211;no-locale -E UNICODE -U foo\uff08\u65e0\u533a\u57df\u8bbe\u7f6e\uff0c\u9ed8\u8ba4\u7f16\u7801\u4e3aUTF8\uff0c\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u4e3afoo\uff09\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nb\">mkdir<\/span> \/database\/data95\r\ninitdb <span class=\"nt\">-D<\/span> \/database\/data95 <span class=\"nt\">--no-locale<\/span> <span class=\"nt\">-E<\/span> UNICODE <span class=\"nt\">-U<\/span> foo\r\n<\/code><\/pre>\n<p>\u5c06\u73af\u5883\u53d8\u91cf$PGDATA\u7684\u8def\u5f84\u4ece\u65e7\u7684PGDATA\u6587\u4ef6\u5939\u5207\u6362\u5230\u65b0\u7684PGDATA\u6587\u4ef6\u5939\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nb\">echo<\/span> <span class=\"nv\">$PGDATA<\/span>\r\n  <span class=\"c\"># \/database\/data94 \u3068\u8868\u793a\u3055\u308c\u308b<\/span>\r\n<span class=\"nb\">export <\/span><span class=\"nv\">PGDATA<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"\/database\/data95\"<\/span>\r\n  <span class=\"c\"># .bash_profile\u306a\u3069\u3067\u521d\u671f\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u305d\u3061\u3089\u3082\u5909\u66f4<\/span>\r\n<\/code><\/pre>\n<h2>\u6267\u884cpg_upgrade<\/h2>\n<p>\u4f7f\u7528pg_upgrade\u547d\u4ee4\uff0c\u5c06\u65e7\u7684PGDATA\u6587\u4ef6\u5939\u7684\u5185\u5bb9\u540c\u6b65\u5230\u65b0\u7684PGDATA\u6587\u4ef6\u5939\u4e2d\u3002<\/p>\n<pre class=\"post-pre\"><code>pg_upgrade <span class=\"nt\">-d<\/span> \/database\/data94 <span class=\"nt\">-D<\/span> \/database\/data95 <span class=\"nt\">-b<\/span> \/usr\/local\/Cellar\/postgresql\/9.4.5_2\/bin <span class=\"nt\">-B<\/span> \/usr\/local\/Cellar\/postgresql\/9.5.0\/bin <span class=\"nt\">-U<\/span> foo\r\n<\/code><\/pre>\n<p>\u8fd0\u884c\u793a\u4f8b<\/p>\n<pre class=\"post-pre\"><code><span class=\"go\">Performing Consistency Checks\r\n-----------------------------\r\nChecking cluster versions                                   ok\r\nChecking database user is a superuser                       ok\r\nChecking for prepared transactions                          ok\r\nChecking for reg* system OID user data types                ok\r\nChecking for contrib\/isn with bigint-passing mismatch       ok\r\nChecking for invalid \"line\" 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 a superuser                       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 on the new cluster                        ok\r\nDeleting files from new pg_clog                             ok\r\nCopying old pg_clog 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\nAdding support functions to new cluster                     ok\r\nRestoring database schemas in the new cluster\r\n                                                            ok\r\nCreating newly-required TOAST tables                        ok\r\nRemoving support functions from new cluster                 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's data files:\r\n    delete_old_cluster.sh\r\n\r\n<\/span><\/code><\/pre>\n<p>\u53ea\u8981\u6ca1\u6709\u51fa\u73b0\u9519\u8bef\u6216\u4e2d\u65ad\u7684\u65e5\u5fd7\uff0c\u5c31\u7b97\u662f\u6210\u529f\u4e86\u3002<\/p>\n<p>\u6700\u540e\uff0c\u6267\u884cpg_upgrade\u751f\u6210\u7684analyze_new_cluster.sh\u5e76\u7ed3\u675f\u3002<\/p>\n<pre class=\"post-pre\"><code>pg_ctl start\r\nanalyze_new_cluster.sh\r\npsql <span class=\"nt\">-l<\/span>\r\n   <span class=\"c\"># 9.4\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5185\u5bb9\u304c\u79fb\u884c\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/span>\r\n<\/code><\/pre>\n<p>\u53e6\u5916\uff0cpg_upgrade\u8fd8\u4f1a\u751f\u6210\u4e00\u4e2a\u540d\u4e3adelete_old_cluster.sh\u7684\u811a\u672c\uff0c\u7528\u4e8e\u5220\u9664\u65e7\u7684PGDATA\u6587\u4ef6\u5939\uff08\u5728\u6b64\u793a\u4f8b\u4e2d\u4e3a\/database\/data94\uff09\u3002\u60a8\u53ef\u4ee5\u9009\u62e9\u6267\u884c\u6b64\u811a\u672c\u4ee5\u5220\u9664\u65e7\u7684PGDATA\u6587\u4ef6\u5939\uff0c\u6216\u8005\u6839\u636e\u4e2a\u4eba\u559c\u597d\u9009\u62e9\u4fdd\u7559\u5b83\u4eec\u3002<\/p>\n<p>\u5982\u679c\u9700\u8981\u8c03\u6574\uff0c\u7531\u4e8epg_hda.conf\u548cpostgresql.conf\u4e0d\u4f1a\u8fc1\u79fb\uff0c\u60a8\u9700\u8981\u81ea\u884c\u8fdb\u884c\u4fee\u6b63\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5f00\u53d1\u73af\u5883\u4e2d\u6267\u884c\u4e86brew update; brew upgrade\u4e4b\u540e\uff0c\u7531\u4e8e\u6700\u65b0\u7248\u672c\u7684PostgreSQL9 [&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-41712","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>\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade - 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\/\u5c06postgresql-9-4\u5347\u7ea7\u5230postgresql-9-5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\" \/>\n<meta property=\"og:description\" content=\"\u5728\u5f00\u53d1\u73af\u5883\u4e2d\u6267\u884c\u4e86brew update; brew upgrade\u4e4b\u540e\uff0c\u7531\u4e8e\u6700\u65b0\u7248\u672c\u7684PostgreSQL9 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06postgresql-9-4\u5347\u7ea7\u5230postgresql-9-5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-16T06:25:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T08:25:03+00:00\" \/>\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=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/\",\"name\":\"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-02-16T06:25:51+00:00\",\"dateModified\":\"2024-05-04T08:25:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\"}]},{\"@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%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade - 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\/\u5c06postgresql-9-4\u5347\u7ea7\u5230postgresql-9-5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade","og_description":"\u5728\u5f00\u53d1\u73af\u5883\u4e2d\u6267\u884c\u4e86brew update; brew upgrade\u4e4b\u540e\uff0c\u7531\u4e8e\u6700\u65b0\u7248\u672c\u7684PostgreSQL9 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06postgresql-9-4\u5347\u7ea7\u5230postgresql-9-5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-02-16T06:25:51+00:00","article_modified_time":"2024-05-04T08:25:03+00:00","author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/","name":"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-02-16T06:25:51+00:00","dateModified":"2024-05-04T08:25:03+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c06PostgreSQL 9.4\u5347\u7ea7\u5230PostgreSQL 9.5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528pg_upgrade"}]},{"@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%b0%86postgresql-9-4%e5%8d%87%e7%ba%a7%e5%88%b0postgresql-9-5%e7%9a%84%e6%96%b9%e6%b3%95%e6%98%af%e4%bd%bf%e7%94%a8pg_upgrade%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\/41712","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=41712"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41712\/revisions"}],"predecessor-version":[{"id":99403,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41712\/revisions\/99403"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}