{"id":34915,"date":"2021-06-25T06:51:28","date_gmt":"2021-06-25T06:51:28","guid":{"rendered":"https:\/\/ittutorial.org\/?p=34915"},"modified":"2021-06-25T06:51:28","modified_gmt":"2021-06-25T06:51:28","slug":"docker-pgmaster-postgresql-version-update","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/docker-pgmaster-postgresql-version-update\/","title":{"rendered":"Docker PGMASTER PostgreSQL Version Update"},"content":{"rendered":"<p>Hello, I will explain pgmaster postgresql version update on docker<\/p>\n<p>1-similar file is uploaded to \/tmp directory of the related server with scp and ftp<\/p>\n<pre>postgresql-12.x.xx.image.tar.gz<\/pre>\n<p>2-Bash shell login on the server. The following command is executed<\/p>\n<pre>gunzip -c \/tmp\/postgresql-12.x.xx.image.tar.gz |docker load<\/pre>\n<p>3-Which pg will be updated, if the version has changed in the relevant pg.conf file, it may be necessary to update it.<\/p>\n<p>4-The following command is executed in the relevant pg directory.<\/p>\n<pre>make stop\r\nmake start<\/pre>\n<pre>make logs\u00a0 \u00a0 \u00a0 \u00a0 #pgmaster container logs are checked for any errors<\/pre>\n<pre>make pglog\u00a0 \u00a0 \u00a0#postgresql core logs are checked for any errors<\/pre>\n<pre>make pg-view\u00a0 #With the #commands, it is ensured that the server is running correctly.<\/pre>\n<pre>make pg-activity<\/pre>\n<p>pgagent notes<br \/>\nThe pg.conf file must have the line ENABLE_PGAGENT=yes. (change to this information requires restart)<br \/>\nThe running status of the pgagent service is checked with the pg-pgagent-isRunning command in the container.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello, I will explain pgmaster postgresql version update on docker 1-similar file is uploaded to \/tmp directory of the related server with scp and ftp postgresql-12.x.xx.image.tar.gz 2-Bash shell login on the server. The following command is executed gunzip -c \/tmp\/postgresql-12.x.xx.image.tar.gz |docker load 3-Which pg will be updated, if the version has changed in the relevant &hellip;<\/p>\n","protected":false},"author":36,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3896],"tags":[9475,19842,2606],"class_list":["post-34915","post","type-post","status-publish","format-standard","","category-postgresql","tag-docker-ora-00845-memory_target-not-supported-on-this-system","tag-docker-postgresql","tag-postgresql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/36"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=34915"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34915\/revisions"}],"predecessor-version":[{"id":34916,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34915\/revisions\/34916"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=34915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=34915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=34915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}