{"id":539,"date":"2018-06-29T21:34:59","date_gmt":"2018-06-29T21:34:59","guid":{"rendered":"http:\/\/dbtut.com\/?p=539"},"modified":"2020-10-08T07:49:57","modified_gmt":"2020-10-08T07:49:57","slug":"how-to-stop-start-restart-and-reload-postgresql-service","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/","title":{"rendered":"How To Stop, Start, Restart and Reload PostgreSQL Service"},"content":{"rendered":"

You can do PostgreSQL service management in two ways.<\/p>\n

Generally, restart or reload is required when changes are made to the postgresql.conf file.<\/p>\n

You can find information on the right side of the parameters in the postgresql.conf file that require restart or reload.<\/p>\n

For example, you can see the line for max_connection parameter below.<\/p>\n

max_connections = 4000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # (change requires restart)<\/p>\n

First Method:<\/h3>\n

You can do this using the systemctl command with the root user.<\/p>\n

The PostgreSQL service name will depend on the version you are using.<\/p>\n

If you are using version 9.6, the service name is “postgresql-9.6.service”<\/p>\n

If you are using version 10.2, the service name will be “PostgreSQL-10.2.service”.<\/p>\n

systemctl stop postgresql-10.service\nsystemctl start postgresql-10.service\nsystemctl restart postgresql-10.service\nsystemctl status postgresql-10.service\nsystemctl reload postgresql-10.service<\/pre>\n\n
Second Method:<\/h3>\n
You can use the pg_ctl command while in the postgres user. I usually prefer the 1st method.<\/p>\n
The pgsql-10 value in the following commands will change according to your version.<\/p>\n
\/usr\/pgsql-10\/bin\/pg_ctl stop -D \/postgres\/pg_data\n\/usr\/pgsql-10\/bin\/pg_ctl start -D \/postgres\/pg_data\n\/usr\/pgsql-10\/bin\/pg_ctl restart -D \/postgres\/pg_data\n\/usr\/pgsql-10\/bin\/pg_ctl status -D \/postgres\/pg_data\n\/usr\/pgsql-10\/bin\/pg_ctl reload -D \/postgres\/pg_data<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
You can do PostgreSQL service management in two ways. Generally, restart or reload is required when changes are made to the postgresql.conf file. You can find information on the right side of the parameters in the postgresql.conf file that require restart or reload. For example, you can see the line for max_connection parameter below. max_connections …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"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,"footnotes":""},"categories":[5],"tags":[591,590,589,588,220,585,586,198,587,197],"class_list":["post-539","post","type-post","status-publish","format-standard","","category-postgres","tag-change-requires-reload","tag-change-requires-restart","tag-max_connections","tag-pg_ctl","tag-postgresql-conf","tag-reload-postgresql-service","tag-restart-postgresql-service","tag-start-postgresql-service","tag-stop-postgresql-service","tag-systemctl"],"aioseo_notices":[],"yoast_head":"\nHow To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Stop, Start, Restart, Status and Reload PostgreSQL Service\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Stop, Start, Restart, Status and Reload PostgreSQL Service\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-29T21:34:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-08T07:49:57+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Stop, Start, Restart and Reload PostgreSQL Service\",\"datePublished\":\"2018-06-29T21:34:59+00:00\",\"dateModified\":\"2020-10-08T07:49:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\"},\"wordCount\":156,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"change requires reload\",\"change requires restart\",\"max_connections\",\"pg_ctl\",\"postgresql.conf\",\"Reload PostgreSQL Service\",\"Restart PostgreSQL Service\",\"start postgresql service\",\"Stop PostgreSQL Service\",\"systemctl\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\",\"name\":\"How To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-06-29T21:34:59+00:00\",\"dateModified\":\"2020-10-08T07:49:57+00:00\",\"description\":\"How To Stop, Start, Restart, Status and Reload PostgreSQL Service\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Stop, Start, Restart and Reload PostgreSQL Service\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials","description":"How To Stop, Start, Restart, Status and Reload PostgreSQL Service","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:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/","og_locale":"en_US","og_type":"article","og_title":"How To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials","og_description":"How To Stop, Start, Restart, Status and Reload PostgreSQL Service","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-29T21:34:59+00:00","article_modified_time":"2020-10-08T07:49:57+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Stop, Start, Restart and Reload PostgreSQL Service","datePublished":"2018-06-29T21:34:59+00:00","dateModified":"2020-10-08T07:49:57+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/"},"wordCount":156,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["change requires reload","change requires restart","max_connections","pg_ctl","postgresql.conf","Reload PostgreSQL Service","Restart PostgreSQL Service","start postgresql service","Stop PostgreSQL Service","systemctl"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/","name":"How To Stop, Start, Restart and Reload PostgreSQL Service - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-06-29T21:34:59+00:00","dateModified":"2020-10-08T07:49:57+00:00","description":"How To Stop, Start, Restart, Status and Reload PostgreSQL Service","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-stop-start-restart-and-reload-postgresql-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Stop, Start, Restart and Reload PostgreSQL Service"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=539"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/539\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}