cookbook 'postgresql', '= 11.8.2'
postgresql
(124) Versions
11.8.2
-
-
11.11.2
-
11.11.1
-
11.11.0
-
11.10.3
-
11.10.2
-
11.10.1
-
11.10.0
-
11.9.0
-
11.8.5
-
11.8.4
-
11.8.3
-
11.8.2
-
11.8.1
-
11.8.0
-
11.7.1
-
11.7.0
-
11.6.3
-
11.6.2
-
11.6.1
-
11.6.0
-
11.5.1
-
11.5.0
-
11.4.0
-
11.3.0
-
11.2.12
-
11.2.11
-
11.2.10
-
11.2.9
-
11.2.8
-
11.2.7
-
11.2.6
-
11.2.5
-
11.2.4
-
11.2.3
-
11.2.2
-
11.2.1
-
11.2.0
-
11.1.6
-
11.1.5
-
11.1.4
-
11.1.3
-
11.1.2
-
11.1.1
-
11.1.0
-
11.0.1
-
11.0.0
-
10.0.2
-
10.0.1
-
10.0.0
-
9.1.0
-
9.0.3
-
9.0.2
-
9.0.1
-
9.0.0
-
8.3.0
-
8.2.1
-
8.2.0
-
8.1.1
-
8.1.0
-
8.0.2
-
8.0.1
-
8.0.0
-
7.1.9
-
7.1.8
-
7.1.7
-
7.1.6
-
7.1.5
-
7.1.4
-
7.1.3
-
7.1.2
-
7.1.1
-
7.1.0
-
7.0.0
-
6.1.4
-
6.1.1
-
6.1.0
-
6.0.1
-
6.0.0
-
5.2.0
-
5.1.0
-
5.0.0
-
4.0.6
-
4.0.4
-
4.0.2
-
4.0.0
-
3.4.24
-
3.4.21
-
3.4.20
-
3.4.19
-
3.4.18
-
3.4.16
-
3.4.14
-
3.4.12
-
3.4.10
-
3.4.8
-
3.4.6
-
3.4.4
-
3.4.2
-
3.4.1
-
3.4.0
-
3.3.4
-
3.3.0
-
3.2.0
-
3.1.0
-
3.0.4
-
3.0.2
-
3.0.0
-
2.4.0
-
2.2.2
-
2.2.0
-
2.1.0
-
2.0.2
-
2.0.0
-
1.0.0
-
0.99.4
-
0.99.2
-
0.99.0
-
0.11.1
-
0.11.0
-
0.10.2
-
0.10.1
-
0.10.0
-
0.9.0
-
0.7.0
Follow350
- 11.11.2
- 11.11.1
- 11.11.0
- 11.10.3
- 11.10.2
- 11.10.1
- 11.10.0
- 11.9.0
- 11.8.5
- 11.8.4
- 11.8.3
- 11.8.2
- 11.8.1
- 11.8.0
- 11.7.1
- 11.7.0
- 11.6.3
- 11.6.2
- 11.6.1
- 11.6.0
- 11.5.1
- 11.5.0
- 11.4.0
- 11.3.0
- 11.2.12
- 11.2.11
- 11.2.10
- 11.2.9
- 11.2.8
- 11.2.7
- 11.2.6
- 11.2.5
- 11.2.4
- 11.2.3
- 11.2.2
- 11.2.1
- 11.2.0
- 11.1.6
- 11.1.5
- 11.1.4
- 11.1.3
- 11.1.2
- 11.1.1
- 11.1.0
- 11.0.1
- 11.0.0
- 10.0.2
- 10.0.1
- 10.0.0
- 9.1.0
- 9.0.3
- 9.0.2
- 9.0.1
- 9.0.0
- 8.3.0
- 8.2.1
- 8.2.0
- 8.1.1
- 8.1.0
- 8.0.2
- 8.0.1
- 8.0.0
- 7.1.9
- 7.1.8
- 7.1.7
- 7.1.6
- 7.1.5
- 7.1.4
- 7.1.3
- 7.1.2
- 7.1.1
- 7.1.0
- 7.0.0
- 6.1.4
- 6.1.1
- 6.1.0
- 6.0.1
- 6.0.0
- 5.2.0
- 5.1.0
- 5.0.0
- 4.0.6
- 4.0.4
- 4.0.2
- 4.0.0
- 3.4.24
- 3.4.21
- 3.4.20
- 3.4.19
- 3.4.18
- 3.4.16
- 3.4.14
- 3.4.12
- 3.4.10
- 3.4.8
- 3.4.6
- 3.4.4
- 3.4.2
- 3.4.1
- 3.4.0
- 3.3.4
- 3.3.0
- 3.2.0
- 3.1.0
- 3.0.4
- 3.0.2
- 3.0.0
- 2.4.0
- 2.2.2
- 2.2.0
- 2.1.0
- 2.0.2
- 2.0.0
- 1.0.0
- 0.99.4
- 0.99.2
- 0.99.0
- 0.11.1
- 0.11.0
- 0.10.2
- 0.10.1
- 0.10.0
- 0.9.0
- 0.7.0
Installs and configures postgresql for clients or servers
cookbook 'postgresql', '= 11.8.2', :supermarket
knife supermarket install postgresql
knife supermarket download postgresql
PostgreSQL cookbook
Installs and configures PostgreSQL as a client or a server.
Maintainers
This cookbook is maintained by the Sous Chefs. The Sous Chefs are a community of Chef cookbook maintainers working together to maintain important cookbooks. If you’d like to know more please visit sous-chefs.org or come chat with us on the Chef Community Slack in #sous-chefs.
Upgrading
If you are wondering where all the recipes went in v7.0+, or how on earth I use this new cookbook please see UPGRADING.md for a full description.
Requirements
Platforms
- Amazon Linux
- Debian 9+
- Ubuntu 18.04+
- Red Hat/CentOS/Scientific 7+
PostgreSQL version
We follow the currently supported versions listed on https://www.postgresql.org/support/versioning/
Chef
- Chef 16
Cookbook Dependencies
-
yum
>= 7.2.0 (fordnf_module
resource)
Resources
- [postgresql_access](documentation/postgresql_access.md)
- [postgresql_config](documentation/postgresql_config.md)
- [postgresql_database](documentation/postgresql_database.md)
- [postgresql_extension](documentation/postgresql_extension.md)
- [postgresql_ident](documentation/postgresql_ident.md)
- [postgresql_install](documentation/postgresql_install.md)
- [postgresql_role](documentation/postgresql_role.md)
- [postgresql_service](documentation/postgresql_service.md)
Contributors
This project exists thanks to all the people who contribute.
Backers
Thank you to all our backers!
Sponsors
Support this project by becoming a sponsor. Your logo will show up here with a link to your website.
postgresql Cookbook CHANGELOG
This file is used to list changes made in the last 3 major versions of the postgresql cookbook.
11.8.2 - 2023-09-28
11.8.1 - 2023-09-04
11.8.0 - 2023-09-01
- Refactor access ordering to allow moves
11.7.1 - 2023-08-31
- Fix package source detection when other packages matching the postgresql name are installed
11.7.0 - 2023-08-21
- Add insert position option for access resources
- Refactor ident class to use update method to empty properties overwriting settings on update
11.6.3 - 2023-07-25
- Fix PostgreSQL version detection
11.6.2 - 2023-07-24
- Prevent
postgresql_config
resource from triggering changes, iffilemode
,owner
orgroup
are specified, but there values don't change.
11.6.1 - 2023-07-09
11.6.0 - 2023-07-07
- Allow to configure multiple databases and users in one
pg_hba.conf
entry
11.5.1 - 2023-06-26
- Fix typo in documentation of
postgresql_extension
resource
11.5.0 - 2023-06-19
- Added support for Debian 12
11.4.0 - 2023-06-18
- Allow to configure auth method with complex/multiple option(s)
11.3.0 - 2023-06-06
- Allow package installation from OS distribution repository
11.2.12 - 2023-05-16
11.2.11 - 2023-05-04
- Make the encrypted_password property in the role resource idempotent.
11.2.10 - 2023-05-04
- Fix unparsable pg_hba.conf when a column value is longer than the max width
11.2.9 - 2023-05-04
- Update CI permissions and remove markdown-link check
11.2.8 - 2023-04-17
11.2.7 - 2023-04-07
Standardise files with files in sous-chefs/repo-management
11.2.6 - 2023-04-01
11.2.5 - 2023-04-01
11.2.4 - 2023-04-01
Standardise files with files in sous-chefs/repo-management
11.2.3 - 2023-03-15
Standardise files with files in sous-chefs/repo-management
Standardise files with files in sous-chefs/repo-management
Standardise files with files in sous-chefs/repo-management
11.2.2 - 2023-02-27
11.2.1 - 2023-02-21
- Make database names an identifier to allow additional permitted characters
- Make sure perl-IPC-Run package is installed for RHEL 8/9 platforms
11.2.0 - 2023-02-20
- Allow database encoding to be specified as a String
11.1.6 - 2023-02-19
Standardise files with files in sous-chefs/repo-management
Standardise files with files in sous-chefs/repo-management
11.1.5 - 2023-02-15
11.1.4 - 2023-02-14
Standardise files with files in sous-chefs/repo-management
11.1.3 - 2023-02-01
- Fix regex not matching databases names containing dashes and underscores
- Update formatting output of pg_hba to support longer values
11.1.2 - 2023-01-12
- Fix regex not matching usernames containing characters other than word characters
11.1.1 - 2022-12-22
11.1.0 - 2022-12-20
- resolved cookstyle error: resources/role.rb:1:1 refactor:
Chef/Deprecations/ResourceWithoutUnifiedTrue
- Fix connection to server via local socket
- Fix parsing of address field in
pga_hba.conf
11.0.1 - 2022-12-13
Standardise files with files in sous-chefs/repo-management
11.0.0 - 2022-12-13
- Major refactor, see [UPGRADING.md](UPGRADING.md)
- Condense repository, client_install and server_install into common install resource with actions replacing the previous split resources.
-
:repository
action -
:install
action -
:client_install
action -
:server_install
action
-
- Refactor database, role (user) and extension resources to use pg gem for database access
- All
load_current_value
support
- All
- Rename user resource to role to match PostgreSQL (still aliased to
:postgresql_user
) - Update various resource properties to match PostgreSQL side
10.0.2 - 2022-12-04
Standardise files with files in sous-chefs/repo-management
Standardise files with files in sous-chefs/repo-management
10.0.1 - 2022-02-04
- Remove delivery and move to calling RSpec directly via a reusable workflow
- Update tested platforms
10.0.0 - 2021-10-19
- Move connection options to a resource partial
- Require Chef 16+ for resource partials
9.1.0 - 2021-10-07
- Use
dnf_module
resource from yum cookbook instead of manually shelling out- requires new dependency on
yum
>= 7.2.0
- requires new dependency on
- Remove unneeded
apt
&yum-epel
dependencies - Move resource documentation out of README
9.0.3 - 2021-08-30
- Standardise files with files in sous-chefs/repo-management
- resolved cookstyle error: spec/libraries/helpers_spec.rb:84:31 convention:
Layout/ClosingParenthesisIndentation
9.0.2 - 2021-06-01
- Standardise files with files in sous-chefs/repo-management
9.0.1 - 2021-05-13
- Prevent leaking the users password during account creation
9.0.0 - 2021-05-13
- Use unified_mode for Chef 17 support
- Update minimum Chef version top 15.3 where unified mode was introduced
- Drop testing PostgreSQL 9.5 support now it's EOL
- Add PostgreSQL 13 testing
8.3.0 - 2021-03-24
- Fix idempotency when installing multiple client versions
8.2.1 - 2021-02-08
- Fix changelog formatting
8.2.0 - 2021-02-04
- Makes psqlrc optional when invoking
psql_command_string
8.1.1 - 2021-01-12
- Fix attribute updates for users with dashes
8.1.0 - 2020-12-09
- Fix potential password exposure in logs
8.0.2 - 2020-11-20
- Fix quoting of DROP ROLE query
v8.0.1 (2020-11-12)
- Use system default locale when creating databases
- resolved cookstyle error: spec/libraries/helpers_spec.rb:2:18 convention:
Style/RedundantFileExtensionInRequire
v8.0.0 (2020-08-26)
- Bumped default version of postgresql to 12
- Added support for dnf by disabling the postgresql module on repo configuration
- Add support for the pgdg-common repository
- Add provides to resources
- Add tests for currently supported postgresql releases
- remove need to surround extension names with "" if they contain a '-'
- resolved cookstyle error: libraries/helpers.rb:43:7 convention:
Style/RedundantAssignment
- resolved cookstyle error: libraries/helpers.rb:46:1 convention:
Layout/EmptyLinesAroundMethodBody
- resolved cookstyle error: libraries/helpers.rb:46:1 convention:
Layout/TrailingWhitespace
v7.1.9 (2020-05-14)
- resolved cookstyle error: resources/access.rb:30:28 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: resources/access.rb:30:29 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: resources/access.rb:54:44 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: resources/access.rb:54:45 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: resources/ident.rb:50:44 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: resources/ident.rb:50:45 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: resources/repository.rb:35:59 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: resources/repository.rb:35:60 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: resources/user.rb:39:66 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: resources/user.rb:39:67 refactor:
ChefModernize/FoodcriticComments
v7.1.8 (2020-02-22)
- Fix incorrect ubuntu platform family value in
postgresql_server_install
- Re-add unit tests that were skipped
v7.1.7 (2020-02-21)
- Correctly configure postgres-common on Ubuntu hosts (fixes #596)
v7.1.6 (2020-02-20)
- Remove unnecessary nil default in resource properties
- Migrate to GitHub Actions for testing
v7.1.5 (2019-11-18)
- Allow to install extensions with hyphens, ex:
postgresql_extension '"uuid-ossp"'
- Update Circle CI config to match sous-chefs defaults #617
- Remove Fedora testing from CI, not an official supported OS by sous-chefs, PR welcome #617
v7.1.4 (2019-03-28)
- Fix installation of extensions.
v7.1.3 (2019-01-15)
- Added support for dash in database role name.
v7.1.2 (2019-06-01)
- Cleanup and update the user resource documentation and code. Removed extraneous 'sensitive' property which is a common property in all Chef resources.
- Change default permissions on the postgres.conf to be world readable so that psql can work.
v7.1.1 (2018-09-26)
- Rename slave to follower
- Use CircleCI for testing
- Simplyfy extension resource
v7.1.0 (2018-06-22)
- Update the
initdb
script to use initdb rather than a service. #542 - Refactor database commands to use the common connect method. #535
- Increase the unit test coverage.
v7.0.0 (2018-05-25)
Breaking Change Please see UPGRADING.md and the README.md for information how to use.
-
Add custom resources for:
postgresql_client_install
postgresql_server_install
postgresql_repository
postgresql_pg_gem
-
Deprecate recipes:
apt_pgdg_postgresql
config_initdb
config_pgtune
contrib
ruby
yum_pgdg_postgresql
Remove deprecated tests
v6.1.3 (2018-04-18)
- Fix recipes referencing the old helpers
v6.1.2 (2018-04-16)
this will be the last release of the 6.0 series before all recipes are removed from the cookbook
- Deprecate all recipes
v6.1.1 (2017-03-08)
- Fix pg gem installation on non-omnibus chef runs
- Resolve resource cloning deprecation warnings in the ruby recipe
- Fix issues resolving the timezone on CentOS 7 and probably other distros
- Test with Delivery local instead of Rake
v6.1.0 (2017-02-18)
- Fix a method name conflict that caused errors if Chef Sugar was also being used on the run list
- Revert a previous PR that added support for Postgresql 9.6 as it introduced incorrect configuration values
- Added Fedora 25 support for pgdg packages
- Added RHEL 5 support for Postgresql 9.4 pgdg packages
- Removed testing for RHEL 5 and Ubuntu 12.04 as they are scheduled for EoL in the near future
- Improvements to Test Kitchen testing to allow more extensive testing in Travis CI
- Fixed the client recipe on Fedora
- Added Inspec tests for client installs
v6.0.1 (2017-01-04
- Fix systemd unit file template
v6.0.0 (2017-01-03)
- This cookbook now requires Chef 12.1 or later
- Removed the dependency on the apt cookbook as this functionality is built into modern chef client releases
- Added a new custom resource for installing extensions. This acts as a replacement for the contrib recipe with minimal backwards compatibility. You can now install / remove extensions into any database. This adds the compat_resource cookbook dependency so we can continue to support Chef 12.1-12.4, which lack custom resource support.
- The unused get_result_orig helper has been removed. If you utilized this you'll want to move it to your own wrapper cookbook
- Updates for compatibility with Postgresql 9.5 and 9.6
- Fixed client package installation on openSUSE Leap 42.2
- ca-certificates recipe has been deprecated. If ca-certificates package needs to be upgraded the user should do so prior to including this recipe. Package upgrades in community cookbooks are generally a bad idea as this bring in updated packages to production systems. The recipe currently warns if used and will be removed with the next major cookbook release.
- Fixed RHEL platform detection in the Ruby recipe
- systemd fixes for RHEL systems
- Fix systemd service file include when using pgdg packages
- Package installation now uses multi-package installs to speed up converge times
- Added integration testing in Travis of the client recipe using a new test cookbook. This will be expanded in the future to cover server installation as well
- Expanded the specs to test converges on multiple platforms
v5.2.0 (2016-12-30)
- Updated contacts and links to point to Sous Chefs now
- Added a Code of Conduct (the Chef CoC)
- Removed duplicate platforms in the metadata
- Fix Chef runs with local mode in the server recipe
- Fix the ruby recipe to not fail when you specify enabling both the apt and yum repos for mixed distro environments
- Set the postgresql data directory to 700 permissions
- Added node['postgresql']['pg_gem']['version'] to specify the version of the pg gem to install
- Cookstyle fixes for the latest cookstyle release
- Removed test deps from the Gemfile. Rely on ChefDK for base testing deps instead
v5.1.0 (2016-11-01)
- Maintenance of this cookbook has been migrated from Heavy Water to Sous Chefs - https://sous-chefs.org/
- Add support for Chef-Zero (local mode)
- Don't hardcode the UID / GID on RHEL/Amazon/Suse platforms
- Add PGDG yum RPMs for 9.5 / 9.6
v5.0.0 (2016-10-25)
Breaking changes
- Switched from Librarian to Berkshelf
-
Remove support for the following platforms
- SLES < 12
- openSUSE < 13
- Debian < 7
- Ubuntu < 12.04
- RHEL < 6
- Amazon < 2013
- Unsupported (EOL) Fedora releases
Other changes
- Added support for Ubuntu 16.04
- Loosened cookbook dependencies to not prevent pulling in the latest community cookbooks
- Added chef_version metadata
- Switched from rubocop to cookstyle and fix all warnings
- Removed minitests and the minitest handler
- Added support for opensuse / opensuseleap
- Added support for Fedora 23/24
- Added a chefignore file to limit the files uploaded to the chef server
- Updated Test Kitchen config to test on modern platform releases
- Added a Rakefile and updated Travis to test with ChefDK and that rakefile
- Avoid installing packages included in build-essential twice in the ruby recipe
- Require at least build-essential 2.0
- Don't cleanup the old PPA files in the apt_pgdg_postgresql recipe anymore. These should be long gone everywhere
- Remove logic in the apt_pgdg_postgresql recipe that made Chef fail when new distro releases came out
- Avoid node.set deprecation warnings
- Avoid managed_home deprecation warnings in server_redhat recipe
Collaborator Number Metric
11.8.2 passed this metric
Contributing File Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file
Cookstyle Metric
11.8.2 passed this metric
No Binaries Metric
11.8.2 passed this metric
Testing File Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file
Version Tag Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
11.8.2 passed this metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file
Cookstyle Metric
11.8.2 passed this metric
No Binaries Metric
11.8.2 passed this metric
Testing File Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file
Version Tag Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
11.8.2 passed this metric
11.8.2 passed this metric
Testing File Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file
Version Tag Metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
11.8.2 failed this metric
11.8.2 failed this metric
Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number