{"id":9024,"date":"2016-10-05T14:43:12","date_gmt":"2016-10-05T12:43:12","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/"},"modified":"2016-10-05T14:43:12","modified_gmt":"2016-10-05T12:43:12","slug":"how-to-patch-postgres-plus-advanced-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/","title":{"rendered":"How to patch Postgres Plus Advanced Server"},"content":{"rendered":"

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server<\/a> instances. Is that different from patching Community PostgreSQL<\/a>? Yes and no \ud83d\ude42 The difference is that you need a subscription<\/a> to get access to the EDB Customer Portal<\/a> for being able to download the patch. This is pretty much the same as with My Oracle Support<\/a> where you need a customer support identifier mapped to your account for being able to download patches, to have access to the knowledge base and for being able to open cases in case you run into troubles which you are not able to solve yourself.<\/p>\n

<\/p>\n

Assuming you have access to the EDB customer portal and you downloaded the patch for your base release the procedure is pretty simple. For this little demo I am running the 9.5.0.5 base release of Postgres Plus Advanced Server:<\/p>\n

\npostgres@centos7:\/home\/postgres\/ [PG2] psql\npsql.bin (9.5.0.5)\nType \"help\" for help.\n\npostgres=# select version();\n                                                   version                                                    \n--------------------------------------------------------------------------------------------------------------\n EnterpriseDB 9.5.0.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit\n(1 row)\n\npostgres=# \n<\/pre>\n
This is the release you can download from the EDB website<\/a> for testing. The patch I downloaded from the portal is this one:<\/p>\n
\npostgres@centos7:\/home\/postgres\/ [PG2] cd \/u01\/app\/postgres\/software\/\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] ls -la\ntotal 27216\ndrwxrwxr-x. 2 postgres postgres       51 Oct  5 10:16 .\ndrwxrwxr-x. 5 postgres postgres       47 Jun 15 13:10 ..\n-rw-rw-r--. 1 postgres postgres 27868299 Oct  5 10:16 postgresplusas-9.5.4.9-1-linux-x64.run\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] chmod +x postgresplusas-9.5.4.9-1-linux-x64.run \n<\/pre>\n
This should patch my base release to currently latest release which is 9.5.4.9-1. How does it work? Lets execute the binary and see what happens:<\/p>\n
\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] .\/postgresplusas-9.5.4.9-1-linux-x64.run \nLanguage Selection\n\nPlease select the installation language\n[1] English - English\n[2] Japanese - \u65e5\u672c\u8a9e\n[3] Simplified Chinese - \u7b80\u4f53\u4e2d\u6587\n[4] Traditional Chinese - \u7e41\u4f53\u4e2d\u6587\n[5] Korean - \ud55c\uad6d\uc5b4\nPlease choose an option [1] : 1\n\nError: There has been an error.\nThis installer requires root privileges. Please become superuser before \nexecuting the installer\nPress [Enter] to continue:\n<\/pre>\n
A no go for most of the cases. Running installers as root is not a good practice and should be avoided whenever possible. But, luckily, as with the base release installer the patch itself can be installed in “extract only” mode:<\/p>\n
\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] .\/postgresplusas-9.5.4.9-1-linux-x64.run --extract-only yes --prefix \/u01\/app\/postgres\/product\/95edb\/db_5\/9.5AS\/\nLanguage Selection\n\nPlease select the installation language\n[1] English - English\n[2] Japanese - \u65e5\u672c\u8a9e\n[3] Simplified Chinese - \u7b80\u4f53\u4e2d\u6587\n[4] Traditional Chinese - \u7e41\u4f53\u4e2d\u6587\n[5] Korean - \ud55c\uad6d\uc5b4\nPlease choose an option [1] : 1\n----------------------------------------------------------------------------\nWelcome to the Postgres Plus Advanced Server Setup Wizard.\n\n----------------------------------------------------------------------------\nPlease specify the directory where Postgres Plus Advanced Server will be \ninstalled.\n\nInstallation Directory [\/u01\/app\/postgres\/product\/95edb\/db_5\/9.5AS]: \n\n----------------------------------------------------------------------------\nSetup is now ready to begin installing Postgres Plus Advanced Server on your \ncomputer.\n\nDo you want to continue? [Y\/n]: y\n\n----------------------------------------------------------------------------\nPlease wait while Setup installs Postgres Plus Advanced Server on your computer.\n\n Installing Database Server\n 0% ______________ 50% ______________ 100%\n #########################################\n\n----------------------------------------------------------------------------\nSetup has finished installing Postgres Plus Advanced Server on your computer.\n\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] \n<\/pre>\n
Looks good, but you never should do this when your PostgreSQL is running, otherwise you’ll get this:<\/p>\n
\n2016-10-05 10:22:43 CEST LOG:  server process (PID 4359) was terminated by signal 11: Segmentation fault\n2016-10-05 10:22:43 CEST LOG:  terminating any other active server processes\n2016-10-05 10:22:43 CEST WARNING:  terminating connection because of crash of another server process\n2016-10-05 10:22:43 CEST DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.\n2016-10-05 10:22:43 CEST HINT:  In a moment you should be able to reconnect to the database and repeat your command.\n2016-10-05 10:22:43 CEST LOG:  statistics collector process (PID 3324) was terminated by signal 11: Segmentation fault\n2016-10-05 10:22:43 CEST LOG:  all server processes terminated; reinitializing\n<\/pre>\n
Always shutdown, before you begin to patch. In my case I just started the instance again and I am on the current release:<\/p>\n
\npostgres@centos7:\/u01\/app\/postgres\/software\/ [PG2] sqh\npsql.bin (9.5.4.9)\nType \"help\" for help.\n\npostgres=# select version();\n                                                   version                                                    \n--------------------------------------------------------------------------------------------------------------\n EnterpriseDB 9.5.4.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit\n(1 row)\n\npostgres=# \n<\/pre>\n
Simple and fast. If you prepare this very well your downtime will be around one minute. I can already hear the question: Can I switchover to my standby, apply the patch on the master, switchback and then proceed on the standby for reducing the downtime even more? This will be a topic for another post.<\/p>\n
PS: Of course you can also prepare a brand new home for the patched binaries and then shutdown your instance, switch to the new binaries and start again from there.<\/p>\n
PS2: Just in case you are not aware of: As we have established a partnership with EnterpriseDB<\/a> in the past you can obtain (an) EDB subscription(s) easily from us. Of course we would do a review of what you really need before. It is not always required to go for the Postgres Plus version. Community PostgreSQL works very well in the most cases and can be backed by a EDB subscription as well, if required.<\/p>\n","protected":false},"excerpt":{"rendered":"
As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no \ud83d\ude42 The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This […]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[713,155,77],"type_dbi":[],"class_list":["post-9024","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-enterprisedb","tag-patching","tag-postgresql"],"acf":[],"yoast_head":"\nHow to patch Postgres Plus Advanced Server - dbi Blog<\/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.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to patch Postgres Plus Advanced Server\" \/>\n<meta property=\"og:description\" content=\"As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no \ud83d\ude42 The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-05T12:43:12+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"How to patch Postgres Plus Advanced Server\",\"datePublished\":\"2016-10-05T12:43:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\"},\"wordCount\":445,\"commentCount\":0,\"keywords\":[\"enterprisedb\",\"Patching\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\",\"name\":\"How to patch Postgres Plus Advanced Server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-10-05T12:43:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to patch Postgres Plus Advanced Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to patch Postgres Plus Advanced Server - dbi Blog","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.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/","og_locale":"en_US","og_type":"article","og_title":"How to patch Postgres Plus Advanced Server","og_description":"As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no \ud83d\ude42 The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This […]","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/","og_site_name":"dbi Blog","article_published_time":"2016-10-05T12:43:12+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"How to patch Postgres Plus Advanced Server","datePublished":"2016-10-05T12:43:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/"},"wordCount":445,"commentCount":0,"keywords":["enterprisedb","Patching","PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/","name":"How to patch Postgres Plus Advanced Server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-10-05T12:43:12+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-patch-postgres-plus-advanced-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to patch Postgres Plus Advanced Server"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9024"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9024\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9024"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}