Changelog

postgis: Drop EL5 leftovers and fix package name for Fedora #1521 (bastelfreak)
Drop EoL SLES 11.4 code #1520 (bastelfreak)
Drop code for Debian without systemd #1514 (bastelfreak)
puppet/systemd: Allow 6.x #1505 (SimonHoenscheid)
set datatype for directories to Stdlib::Absolutepath #1499 (SimonHoenscheid)
Drop postgresql 8.4/RHEL6 specific code #1489 (bastelfreak)
Drop postgresql 8.1/RHEL5 specific code #1486 (bastelfreak)
Delete deprecated validate_db_connection() defined resource #1484 (bastelfreak)
postgresql::server: Remove deprecated createdb_path parameter #1483 (bastelfreak)
postgresql::server: Remove deprecated version parameter #1482 (bastelfreak)
puppetlabs/stdlib: Require 9.x #1481 (bastelfreak)
port: Enforce Stdlib::Port datatype #1473 (bastelfreak)
Add Server Instance Feature #1450 (SimonHoenscheid)

Added

Drop EoL FreeBSD 9.4/9.5 specific code #1519 (bastelfreak)
Drop code compatibility for non-systemd Red Hat #1518 (ekohl)
add $manage_selinux as a parameter, keep default, simpler condition #1516 (SimonHoenscheid)
add port and psql_path parameter to initdb define #1510 (SimonHoenscheid)
PDK update 2.7.0->3.0.0 #1508 (SimonHoenscheid)
variables to parameters for tablespace/schema/reassign_owned_by #1507 (SimonHoenscheid)
server::schema: Drop unused $version variable #1506 (bastelfreak)
Prefer $connect_settings over explicit parameters #1498 (bastelfreak)
server::extension: make user/group/psql_path configureable #1497 (SimonHoenscheid)
server::db: Make port/user/group configureable #1494 (bastelfreak)
server::database_grant: Always set default user/group and expose port as parameter #1493 (bastelfreak)
server::database: make user/group/psql_path/default_db configureable #1492 (SimonHoenscheid)
Provide a default for config_entry's path and enforce absolute path #1490 (SimonHoenscheid)

Fixed

Fix password_encryption for DBVERSION in server::role #1515 (cruelsmith)
Flexible password encryption in pg hba conf #1512 (cruelsmith)
service name should be unique to allow instances #1504 (SimonHoenscheid)
server::grant: make port optional/restore connect_settings feature #1496 (bastelfreak)

v9.2.0 - 2023-08-30

Full Changelog

Added

port parameter: Cleanup datatype #1471 (bastelfreak)
puppet/systemd: Allow 5.x & puppetlabs/concat: Allow 9.x #1448 (bastelfreak)
Add default version for Fedora 37, 38 #1421 (lweller)
Defaulting password encryption for version above 14 #1406 (cruelsmith)

Fixed

port parameter: log warning when its a string #1474 (bastelfreak)
pg_hba.conf: Introduce a newline after each rule #1472 (bastelfreak)
(CAT-1262)-updated legacy repo for SUSE #1462 (praj1001)
Fix log directory config entry name #1457 (chillinger)
Make anchors in defined resources unique #1455 (SimonHoenscheid)
implement key parameter for config_entry defined resource #1454 (SimonHoenscheid)
add missing parameters to initdb #1451 (SimonHoenscheid)
Fix default value for $service_status on ArchLinux #1410 (smortex)
Fix wrong Sensitive handling for updating role passwords #1404 (cruelsmith)

v9.1.0 - 2023-06-12

Full Changelog

Added

pdksync - (MAINT) - Allow Stdlib 9.x #1440 (LukasAud)

v9.0.3 - 2023-05-09

Full Changelog

Fixed

(GH-1426) - Update value to accept array #1434 (jordanbreen28)
(#1432) - Fix Unable to mark 'unless' as sensitive #1433 (kBite)

v9.0.2 - 2023-05-02

Full Changelog

Fixed

(CONT-950) - Fix mismatched data types #1430 (jordanbreen28)
(CONT-904) - Removal of tech debt #1429 (jordanbreen28)
(CONT-949) - Bump stdlib dependency #1428 (jordanbreen28)

v9.0.1 - 2023-04-24

Full Changelog

Fixed

Fix wrong data type for data_checksums parameter #1420 (smortex)

v9.0.0 - 2023-04-21

Full Changelog

Changed

(CONT-792) - Add Puppet 8/Drop Puppet 6 #1414 (jordanbreen28)

v8.3.0 - 2023-04-21

Full Changelog

Added

convert ERB templates to EPP #1399 (SimonHoenscheid)
(CONT-361) Syntax update #1397 (LukasAud)
Add multi instance support, refactoring reload.pp (6/x) #1392 (SimonHoenscheid)
Add multi instance support, refactoring password.pp (5/x) #1391 (SimonHoenscheid)
Add multi instance support, refactoring late_initdb.pp (3/x) #1384 (SimonHoenscheid)
Add multi instance support, refactoring initdb.pp (2/x) #1383 (SimonHoenscheid)
Add multi instance support, refactoring config.pp (1/x) #1382 (SimonHoenscheid)
pg_hba_rule: Validate userinput in postgresql::server #1376 (bastelfreak)
pg_hba_rule: Move type datatype to own type #1375 (bastelfreak)
pg_hba_rule does not properly verify address parameter #1372 (tuxmea)

Fixed

Ubuntu 14/16/17: Drop code leftovers #1388 (bastelfreak)
remove debian 8 and 9 corpses #1387 (SimonHoenscheid)
Archlinux client and server package names were swapped around #1381 (tobixen)
apt::source: configure repo only for current architecture #1380 (bastelfreak)
pdksync - (CONT-189) Remove support for RedHat6 / OracleLinux6 / Scientific6 #1371 (david22swan)
pdksync - (CONT-130) - Dropping Support for Debian 9 #1368 (jordanbreen28)
(maint) Codebase Hardening #1366 (david22swan)
Fix table grant with schema #1315 (vaol)

v8.2.1 - 2022-08-24

Full Changelog

Fixed

Fix puppet-strings documentation #1363 (ekohl)
(GH-1360) Reverting REFERENCE.md changes #1361 (pmcmaw)
Only require password when used #1356 (arjenz)

v8.2.0 - 2022-08-23

Full Changelog

Added

pdksync - (GH-cat-11) Certify Support for Ubuntu 22.04 #1355 (david22swan)
(MODULES-11251) Add support for backup provider "pg_dump" #1319 (fraenki)

Fixed

Ensure multiple postgresql::server::recovery resources can be defined #1348 (Deroin)

v8.1.0 - 2022-07-21

Full Changelog

Added

Fix service status detection on Debian-based OSes #1349 (arjenz)
(FM-8971) allow deferred function for role pwd #1347 (tvpartytonight)
Set version for Fedora 36 #1345 (lweller)
Add Red Hat Enterprise Linux 9 support #1303 (ekohl)

Fixed

(GH-1352) - Updating postgresql service version on SLES #1353 (pmcmaw)
Respect $service_status on Red Hat-based distros #1351 (ekohl)
Add version for Ubuntu 22.04 #1350 (arjenz)
README.md: correct postgresql_conn_validator example #1332 (bastelfreak)
pdksync - (GH-iac-334) Remove Support for Ubuntu 14.04/16.04 #1331 (david22swan)
Remove unused variable in reload.pp #1327 (ekohl)
Use systemctl reload on EL 7 and higher #1326 (ekohl)

v8.0.0 - 2022-03-03

Full Changelog

Changed

Support setting default_privileges on all schemas #1298 (fish-face)

Added

add default version for Fedora 35 #1317 (jflorian)
add scram-sha-256 support #1313 (fe80)
add support for Ubuntu Hirsute and Impish #1312 (nicholascioli)
Allow systemd to mask postgresql service file #1310 (kimsondrup)
Make ::contrib a noop on OSes without a contrib package #1309 (carlosduelo)
pdksync - (IAC-1753) - Add Support for AlmaLinux 8 #1308 (david22swan)
MODULES-11201: add service_name for Ubuntu 18.04 and later #1306 (moritz-makandra)
pdksync - (IAC-1751) - Add Support for Rocky 8 #1305 (david22swan)
Default privileges support schemas #1300 (fish-face)
Support target_role in default_privileges #1297 (fish-face)

Fixed

pdksync - (IAC-1787) Remove Support for CentOS 6 #1324 (david22swan)
Fix python package name in RHEL/CentOS 8 #1316 (kajinamit)
Drop further code for Debian 6 and Ubuntu 10 #1307 (ekohl)

v7.5.0 - 2021-09-28

Full Changelog

Added

Use Puppet-Datatype Sensitive for Passwords #1279 (cocker-cc)

Fixed

(IAC-1598) - Remove Support for Debian 8 #1302 (david22swan)
Inline file contents in the catalog #1299 (ekohl)
Fix changing default encoding #1296 (smortex)

v7.4.1 - 2021-08-25

Full Changelog

Fixed

(maint) Allow stdlib 8.0.0 #1293 (smortex)

v7.4.0 - 2021-08-24

Full Changelog

Added

pdksync - (IAC-1709) - Add Support for Debian 11 #1288 (david22swan)

Fixed

drop code for Debian 6/7 and Ubuntu 10.04/12.04 #1290 (evgeni)

v7.3.0 - 2021-08-03

Full Changelog

Added

MODULES-11049 - Implement default privileges changes #1267 (mtancoigne)

Fixed

Do not add version component to repo definition #1282 (weastur)
(MODULES-8700) Autorequire the service in postgresql_psql #1276 (ekohl)

v7.2.0 - 2021-05-24

Full Changelog

Added

(MODULES-11069) add default version for fedora 34 #1272 (lweller)
MODULES-11047 - Allow managing rights for PUBLIC role #1266 (mtancoigne)

v7.1.0 - 2021-04-12

Full Changelog

Added

Add new common repo which contains add-ons #1190 (jorhett)

v7.0.3 - 2021-04-12

Full Changelog

v7.0.2 - 2021-03-15

Full Changelog

Fixed

(MODULES-10957) Override the set_sensitive_parameters method #1258 (sheenaajay)

v7.0.1 - 2021-03-08

Full Changelog

Fixed

Ensure port is a string in psql command #1253 (ekohl)

v7.0.0 - 2021-03-04

Full Changelog

Changed

pdksync - (MAINT) Remove SLES 11 support #1247 (sanfrancrisko)
pdksync - (MAINT) Remove RHEL 5 family support #1246 (sanfrancrisko)
pdksync - Remove Puppet 5 from testing and bump minimal version to 6.0.0 #1238 (carabasdaniel)

Added

Add DNF module management #1239 (ekohl)

v6.10.2 - 2021-02-22

Full Changelog

Fixed

Fix command shell escaping #1240 (DavidS)

v6.10.1 - 2021-02-09

Full Changelog

v6.10.0 - 2021-02-08

Full Changelog

Added

Set default PostgreSQL version for FreeBSD #1227 (olevole)
Clean up globals logic to support CentOS 8 stream #1225 (ekohl)

Fixed

Also perform systemd daemon-reload on Puppet 6.1+ #1233 (ekohl)
(bug) fix systemd daemon-reload order when updating service files #1230 (sheenaajay)
Fix postgresql::sql task when password is not set #1226 (smortex)

v6.9.0 - 2021-01-18

Full Changelog

Added

pdksync - (feat) - Add support for puppet 7 #1215 (daianamezdrea)
Manage postgresql_conf_path file permissions #1199 (ekohl)

Fixed

(maint) updated defaults for rhel7 policycoreutils #1212 (sheenaajay)
(IAC-1189) - Fix for SLES 15 SP 1 and later #1209 (david22swan)
Change - Use systemd drop-in directory for unit overrides #1201 (blackknight36)

v6.8.0 - 2020-09-29

Full Changelog

Added

add hostgssenc type to pg_hba rules #1195 (osijan)
Allow removal of config_entries via main class #1187 (ekohl)

Fixed

Fix contrib package name under debian 10 #1188 (neomilium)

v6.7.0 - 2020-08-28

Full Changelog

Added

pdksync - (IAC-973) - Update travis/appveyor to run on new default branch main #1182 (david22swan)

v6.6.0 - 2020-06-22

Full Changelog

Added

(IAC-746) - Add ubuntu 20.04 support #1172 (david22swan)

Fixed

Invert psql/package dependency logic #1179 (raphink)
Fix custom port in extension #1165 (Vampouille)

v6.5.0 - 2020-05-13

Full Changelog

Added

service_ensure => true is now an allowed value (aliased to running) #1167 (binford2k)
Finish conversion of postgresql_acls_to_resources_hash function #1163 (alexjfisher)
Finish conversion of postgresql_escape function #1162 (alexjfisher)
Finish conversion of postgresql_password function #1161 (alexjfisher)
Allow usage of grant and role when not managing postgresql::server #1159 (tuxmea)
Add version configs for SLES 12 SP 3 to 5 #1158 (XnS)
Add extra parameter "extra_systemd_config" #1156 (veninga)

Fixed

(MODULES-10610) Use correct lower bound for concat version #1160 (ghoneycutt)

v6.4.0 - 2020-03-17

Full Changelog

Added

Add Fedora 31 compatibility #1141 (blackknight36)
feat: enable different database resource name in extension #1136 (jfroche)
pdksync - (FM-8581) - Debian 10 added to travis and provision file refactored #1130 (david22swan)
Puppet 4 functions #1129 (binford2k)

Fixed

Fix incorrectly quoted GRANT cmd on functions #1150 (olifre)
Correct versioncmp logic in config.pp #1137 (boydtom)
Treat $version as an integer for comparison, defaults to string #1135 (boydtom)
Allow usage of PUBLIC role #1134 (Vampouille)
fix missing systemd override config for EL8 (CentOS and RHEL) #1131 (david-barbion)

v6.3.0 - 2019-12-18

Full Changelog

Added

Add support for granting privileges on functions #1118 (crispygoth)
(FM-8679) - Support added for CentOS 8 #1117 (david22swan)
MODULES-10041 - allow define password_encryption for version above 10 #1111 (k2patel)

Fixed

Remove duplicate REFERENCE.md file with strange unicode character at end of filename #1108 (nudgegoonies)

v6.2.0 - 2019-09-13

Full Changelog

Added

FM-8408 - add support on Debian10 #1103 (lionce)
Fix/directory defined twice #1089 (arcenik)
Adding SLES 15 #1087 (msurato)
(FM-7500) conversion to use litmus #1081 (tphoney)

Fixed

(MODULES-9658) - custom ports are not labeled correctly #1099 (blackknight36)
Fix: When assigning a tablespace to a database, no equal sign is needed in the query #1098 (biertie)
Grant all tables in schema fixup #1096 (georgehansper)
(MODULES-9219) - puppetlabs-postgresql : catalog compilation fails when the service command is not installed #1093 (blackknight36)

v6.1.0 - 2019-06-04

Full Changelog

Added

(FM-8031) Add RedHat 8 support #1083 (eimlav)

v6.0.0 - 2019-05-14

Full Changelog

Changed

pdksync - (MODULES-8444) - Raise lower Puppet bound #1070 (david22swan)
(maint) remove inconsistent extra variable #1044 (binford2k)

Added

Add Fedora 30 compatibility #1067 (blackknight36)
Include EL8 version for config checks #1060 (ehelms)

Fixed

Support current version of puppetlabs/apt. #1073 (pillarsdotnet)
change username/group/datadir defaults for FreeBSD #1063 (olevole)

5.12.1 - 2019-02-14

Full Changelog

Fixed

(FM-7811) - Use postgresql 9.4 for SLES 11 sp4 #1057 (david22swan)
(MODULES-8553) Further cleanup for package tag issues #1055 (HelenCampbell)

5.12.0 - 2019-02-01

Full Changelog

Added

(MODULES-3804) Fix sort order of pg_hba_rule entries #1040 (olavmrk)

Fixed

(MODULES-8553) Fix dependency on apt by explicitly using 'puppetlabs-postgresql' as tag #1052 (HelenCampbell)
(MODULES-8352) Don't use empty encoding string on initdb #1043 (binford2k)
pdksync - (FM-7655) Fix rubygems-update for ruby < 2.3 #1042 (tphoney)

5.11.0 - 2018-11-21

Full Changelog

Added

Add postgis support for postgres 10 #1032 (smussie)

Fixed

Strip quotes from role names #1034 (jstuart)
Ignore .psqlrc so output is clean and doesn't break Puppet #1021 (flaviogurgel)
Change initdb option '--xlogdir' to '-X' for PG10 compatibility #976 (fcanovai)

5.10.0 - 2018-09-27

Full Changelog

Added

pdksync - (MODULES-6805) metadata.json shows support for puppet 6 #1026 (tphoney)

5.9.0 - 2018-09-07

Full Changelog

Added

pdksync - (MODULES-7705) - Bumping stdlib dependency from < 5.0.0 to < 6.0.0 #1018 (pmcmaw)

5.8.0 - 2018-08-07

Full Changelog

Added

metadata.json: bump allowed version of puppetlabs-apt to 6.0.0 #1012 (mateusz-gozdek-sociomantic)

5.7.0 - 2018-07-20

Full Changelog

Added

(MODULES-7479) Update postgresql to support Ubuntu 18.04 #1005 (david22swan)
(MODULES-6542) - Adding SLES 11 & 12 to metadata #1001 (pmcmaw)

Fixed

(MODULES-7479) Ensure net-tools is installed when testing on Ubuntu 18.04 #1006 (david22swan)
(MODULES-7460) - Updating grant table to include INSERT privileges #1004 (pmcmaw)
Fix packages choice for ubuntu 17.10 #1000 (fflorens)

5.6.0 - 2018-06-21

Full Changelog

5.5.0 - 2018-06-19

Full Changelog

Changed

Fix creation of recovery.conf file when recovery configuration is not specified #995 (cdloh)

Added

Add compatibility for Fedora 28 #994 (jflorian)
(MODULES-5994) Add debian 9 #992 (hunner)
Adding default Postgresql version for Ubuntu 18.04 #981 (lutaylor)

Fixed

Fix quoting on schema owners #979 (hasegeli)

5.4.0 - 2018-03-27

Full Changelog

Added

(MODULES-6330) PDK convert 1.4.1 #961 (pmcmaw)
Parameter ensure on postgresql::server::grant and postgresql::server::database_grant #891 (georgehansper)

Fixed

Documentation error, reassign_owned_by uses *_role not *_owner. #958 (computermouth)

5.3.0 - 2018-02-26

Full Changelog

Added

Support extension schemas #948 (hasegeli)
Inherit 9.6 settings for later PgSQL version on FreeBSD #945 (olevole)
MODULES-6194 - Add scram-sha-256 as a valid pg_hba_rule auth method #941 (f3nry)
FM-6445 add a task #930 (tphoney)
add ensure=>absent to postgresql::server::role #897 (georgehansper)

Fixed

(maint) - Skip run_puppet_access_login on LTS #956 (pmcmaw)
(MODULES-6608) - Adding puppet requirement for tasks versioncmp in beaker-task_helper #952 (pmcmaw)
defaulted psql_path to postgresql::server::psql_path #947 (crayfishx)
According to the puppet doc, Pattern should be a list of regex. #942 (PierreR)
This pull request fixes an augeas warning #935 (iakovgan)

5.2.1 - 2017-11-14

Full Changelog

Fixed

(MODULES-5956) fixes for postgresql release #934 (jbondpdx)
add parameter "version" to postgresql::server::extension - fix dependency on database #932 (georgehansper)

5.2.0 - 2017-10-09

Full Changelog

Added

add parameter "version" to postgresql::server::extension to update the extension version #896 (georgehansper)

Fixed

(PUP-8008) monkey patch spec_helper_acceptance #925 (eputnam)
(PUP-8008) monkey patch spec_helper_acceptance #924 (eputnam)
enhance --data-checksums on initdb #915 (mmoll)
MODULES-5378 fix the change in error message #909 (tphoney)
MODULES-5378 fix error message checking in test #908 (tphoney)
Default contcat order #900 (matonb)

5.1.0 - 2017-07-17

Full Changelog

Added

add defined type postgresql::server::reassign_owned_by #894 (georgehansper)
add data_checksums option to initdb #878 (tjikkun)

5.0.0 - 2017-06-21

Full Changelog

Changed

Unset default log_line_prefix #870 (hasegeli)
Let listen_addresses be defined independently #865 (hasegeli)

Added

(MODULES-1394) replace validate_db_connection type with custom type #879 (eputnam)
[msync] 786266 Implement puppet-module-gems, a45803 Remove metadata.json from locales config #860 (wilson208)
(FM-6116) - Adding POT file for metadata.json #857 (pmcmaw)
Allowo to disable managing passwords for users #846 (bjoernhaeuser)

Fixed

(maint) fix for connection validator #882 (eputnam)
(MODULES-5050) Fix for grant_schema_spec #881 (eputnam)
[MODULES-4598] Revert "Revert "fix default params for SUSE family OSes"" #863 (mmoll)
[MODULES-4598] Revert "fix default params for SUSE family OSes" #858 (wilson208)

4.9.0 - 2017-03-09

Full Changelog

Added

(MODULES-1508) add support for unix_socket_directories #845 (eputnam)
(MODULES-1127) allow LANGUAGE as valid object_type #838 (eputnam)
Support granting SELECT and UPDATE permission on sequences (MODULES-4158) #823 (chris-reeves)

Fixed

(MODULES-1707) add logic to params.pp for jdbc driver package on Debian #847 (eputnam)
(maint) Schemas for a db should come after db #840 (hunner)
Fix typo: hostnosssl #837 (df7cb)
Fix SQL style on role.pp #794 (hasegeli)
(#3858) Fix unless check in grant_role to work with roles as well as users #788 (thunderkeys)

4.8.0 - 2016-07-26

Full Changelog

4.7.1 - 2016-02-18

Full Changelog

Fixed

Add missing onlyif_function to sequence grant code #738 (cfrantsen)
Correctly set $service_provider #735 (antaflos)

4.7.0 - 2016-02-02

Full Changelog

Added

(MODULES-2960) Allow float postgresql_conf values #721 (hunner)

4.6.1 - 2015-12-04

Full Changelog

4.6.0 - 2015-09-01

Full Changelog

Fixed

Fix postgis default package name on RedHat #674 (ckaenzig)

4.5.0 - 2015-07-28

Full Changelog

4.4.2 - 2015-07-08

Full Changelog

Added

(#2056) Added 9.4, corrected past versions based on docs #625 (cjestel)

Fixed

(MODULES-2185) Fix withenv execution under Puppet 2.7 #664 (domcleal)

4.4.1 - 2015-07-01

Full Changelog

Fixed

(MODULES-2181) Fix variable scope for systemd-override #659 (kbarber)

4.4.0 - 2015-06-30

Full Changelog

Added

(MODULES-1761) Provide defined resource for managing recovery.conf #603 (dacrome)

Fixed

(FM-2931) fixes logic problem with onlyif type param validation. #654 (bmjen)
Fixed systemd override for manage_repo package versions #639 (cdenneen)
Apt fix #618 (tphoney)
Fix URLs in metadata.json #599 (raphink)

4.3.0 - 2015-03-25

Full Changelog

4.2.0 - 2015-03-10

Full Changelog

Fixed

Fix comment detection #559 (hunner)
Fix comment detection #558 (hunner)

4.1.0 - 2014-11-04

Full Changelog

Fixed

fix future parser error #504 (steeef)

4.0.0 - 2014-09-10

Full Changelog

Fixed

Fixes the accidental erasing of pg_ident.conf #464 (txaj)

3.4.2 - 2014-08-06

Full Changelog

3.4.1 - 2014-07-21

Full Changelog

3.4.0 - 2014-07-09

Full Changelog

Added

postgis support #280 (kitchen)

Fixed

This corrects the location of the pg_hba config file on debian oses in tests #440 (justinstoller)
Fix trailing }. #436 (apenney)
Fix postgresql_conf quote logic #297 (reidmv)