{"id":49445,"date":"2025-05-23T06:52:40","date_gmt":"2025-05-23T06:52:40","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=49445"},"modified":"2025-05-23T06:52:40","modified_gmt":"2025-05-23T06:52:40","slug":"how-to-configure-rundeck-with-postgresql","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-configure-rundeck-with-postgresql\/","title":{"rendered":"How to Configure Rundeck with postgresql"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Step 1 &#8211; Setup PostgreSQL server<\/h1>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-devopsschool-com wp-block-embed-devopsschool-com\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"n6r99ood8p\"><a href=\"https:\/\/www.devopsschool.com\/blog\/postgresql-installation-and-configuration-tutorial-guide\/\">postgresql Installation and Configuration Tutorial Guide<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;postgresql Installation and Configuration Tutorial Guide&#8221; &#8212; DevOpsSchool.com\" src=\"https:\/\/www.devopsschool.com\/blog\/postgresql-installation-and-configuration-tutorial-guide\/embed\/#?secret=WU2SMrsgsz#?secret=n6r99ood8p\" data-secret=\"n6r99ood8p\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Step 2 &#8211; Login to PostgreSQL server &amp; create user\/db &amp; grant perm<\/h1>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/docs.rundeck.com\/docs\/administration\/configuration\/database\/postgres.html#setup-rundeck-database\n<\/div><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Step 3 &#8211; Download PostgreSQL driver<\/h1>\n\n\n\n<p>cd \/var\/lib\/rundeck\/libext<br>sudo wget https:\/\/jdbc.postgresql.org\/download\/postgresql-42.7.3.jar<br>sudo chown rundeck:rundeck postgresql-42.7.3.jar<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Step 4 &#8211; Make a changes in rundeck config<\/h1>\n\n\n\n<h1 class=\"wp-block-heading\">Database configuration<\/h1>\n\n\n\n<p>dataSource.dbCreate = update<br>dataSource.url = jdbc:postgresql:\/\/localhost:5432\/rundeckdb<br>dataSource.username = rundeckuser<br>dataSource.password = rundeckpass<br>dataSource.driverClassName = org.postgresql.Driver<br>dataSource.dialect = org.hibernate.dialect.PostgreSQLDialect<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Step 5 &#8211; Start rundeck<\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Step 1 &#8211; Setup PostgreSQL server Step 2 &#8211; Login to PostgreSQL server &amp; create user\/db &amp; grant perm Step 3 &#8211; Download PostgreSQL driver cd \/var\/lib\/rundeck\/libextsudo wget https:\/\/jdbc.postgresql.org\/download\/postgresql-42.7.3.jarsudo chown&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-49445","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/49445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=49445"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/49445\/revisions"}],"predecessor-version":[{"id":49446,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/49445\/revisions\/49446"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=49445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=49445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=49445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}