{"id":55469,"date":"2023-12-05T10:00:34","date_gmt":"2023-12-05T10:00:34","guid":{"rendered":"https:\/\/dbtut.com\/?p=55469"},"modified":"2023-12-05T10:01:55","modified_gmt":"2023-12-05T10:01:55","slug":"how-to-check-password-policy-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/","title":{"rendered":"How To Check Password Policy In PostgreSQL"},"content":{"rendered":"

In today’s article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.<\/p>\n

When accessing the database, we may sometimes want to make our passwords short and not in compliance with password policies, but there are some packages in Postgresql databases to enforce this.<\/p>\n

One of these is the postgresqlcheck package.<\/p>\n

First we need to install the postgresql13-contrib package.<\/p>\n

yum install postgresql13-contrib<\/pre>\n
After downloading PostgreSQL’s contrib package, we go to the postgresql contrib directory as follows.<\/p>\n
cd \/usr\/pgsql-13\/share\/contrib<\/pre>\n
After going to the directory, we download the postgresqlcheck package and other packages with the following command.<\/p>\n
git clone https:\/\/github.com\/michaelpq\/pg_plugins\/\r\n<\/pre>\n
After the file is downloaded, we enter the passwordcheck_extra directory in pg_plugins.<\/p>\n
cd pg_plugins\/passwordcheck_extra<\/pre>\n
After entering the passwordcheck_extra directory, we run the following command to ensure that the passwordcheck_extra package is installed in Postgresql.<\/p>\n
PATH=\/usr\/pgsql-13\/bin:$PATH make install<\/pre>\n
We change the shared_preload_libraries parameter in Postgresql.conf as follows.<\/p>\n
shared_preload_libraries = 'passwordcheck_extra'<\/pre>\n
We are restarting our service because this process requires a restart in PostgreSQL.<\/p>\n
systemctl restart postgresql-13<\/pre>\n
After the service is restarted, we connect to Postgresql and run the load command below.<\/p>\n
LOAD 'passwordcheck_extra';<\/pre>\n
After running the above command, we determine our password policy via Postgresql as follows.<\/p>\n
SET passwordcheck_extra.restrict_lower = false;\r\nSET passwordcheck_extra.restrict_upper = false;\r\nSET passwordcheck_extra.restrict_special = false;\r\nSET passwordcheck_extra.minimum_length = 6;\r\nSET passwordcheck_extra.maximum_length = 18;<\/pre>\n
In the password above, we specify the parameters that it must be uppercase and lowercase letters, must contain a minimum of 6 characters, must be a maximum of 18 characters long and must use special characters.<\/p>\n
create user passwrdpoltikadeneme password 'farukerdem';<\/pre>\n
<\/p>\n
As seen above, it gave us an error message because we did not create it according to the rules we specified.<\/p>\n
<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13. When accessing the database, we may sometimes want to make our passwords short and not in compliance with password policies, but there are some packages in Postgresql databases to enforce this. One of these is …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":55472,"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":[],"class_list":["post-55469","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nHow To Check Password Policy In PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.\" \/>\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\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check Password Policy In PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-05T10:00:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-05T10:01:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png\" \/>\n\t<meta property=\"og:image:width\" content=\"680\" \/>\n\t<meta property=\"og:image:height\" content=\"308\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"How To Check Password Policy In PostgreSQL\",\"datePublished\":\"2023-12-05T10:00:34+00:00\",\"dateModified\":\"2023-12-05T10:01:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\"},\"wordCount\":250,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\",\"name\":\"How To Check Password Policy In PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png\",\"datePublished\":\"2023-12-05T10:00:34+00:00\",\"dateModified\":\"2023-12-05T10:01:55+00:00\",\"description\":\"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png\",\"width\":680,\"height\":308},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check Password Policy In PostgreSQL\"}]},{\"@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\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check Password Policy In PostgreSQL - Database Tutorials","description":"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.","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\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How To Check Password Policy In PostgreSQL - Database Tutorials","og_description":"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2023-12-05T10:00:34+00:00","article_modified_time":"2023-12-05T10:01:55+00:00","og_image":[{"width":680,"height":308,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"How To Check Password Policy In PostgreSQL","datePublished":"2023-12-05T10:00:34+00:00","dateModified":"2023-12-05T10:01:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/"},"wordCount":250,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/","name":"How To Check Password Policy In PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png","datePublished":"2023-12-05T10:00:34+00:00","dateModified":"2023-12-05T10:01:55+00:00","description":"In today's article, we will learn how to determine your password policy in the parameters determined by Postgresqlcheck on Postgresql13.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-05-125957.png","width":680,"height":308},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/05\/how-to-check-password-policy-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check Password Policy In PostgreSQL"}]},{"@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\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55469","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\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=55469"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55469\/revisions"}],"predecessor-version":[{"id":55474,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55469\/revisions\/55474"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55472"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}