Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status


postgresql (121) Versions 7.0.0

Installs and configures postgresql for clients or servers

cookbook 'postgresql', '= 7.0.0', :supermarket
cookbook 'postgresql', '= 7.0.0'
knife supermarket install postgresql
knife supermarket download postgresql
Quality 100%

postgresql cookbook

Build Status Cookbook Version

Installs and configures PostgreSQL as a client or a server.


If you are wondering where all the recipes went in v7.0+, or how on earth I use this new cookbook please see for a full description.



  • Amazon Linux
  • Debian 7+
  • Ubuntu 14.04+
  • Red Hat/CentOS/Scientific 6+
  • Fedora

PostgreSQL version

We follow the currently supported versions listed on

The earliest supported version is currently:

  • 9.3 (9.3.23)


  • Chef 13.8+

Cookbook Dependencies

  • openssl
  • build-essential



This resource installs PostgreSQL client packages.


  • install - (default) Install client packages


Name Types Description Default Required?
version String Version of PostgreSQL to install '9.6' no
setup_repo Boolean Define if you want to add the PostgreSQL repo true no
hba_file String #{conf_dir}/main/pg_hba.conf no
ident_file String #{conf_dir}/main/pg_ident.conf no
external_pid_file String /var/run/postgresql/#{version} no
password String, nil Pass in a password, or have the cookbook generate one for you 'generate' no
port [String, Integer] Database listen port 5432 no
initdb_locale String Locale to initialize the database with 'UTF-8' no


To install '9.5' version:

postgresql_client_install 'My Postgresql Client install' do
  version '9.5'


This resource installs PostgreSQL client and server packages.


  • install - (default) Install client and server packages
  • create - Initialize the database


Name Types Description Default Required?
version String Version of PostgreSQL to install '9.6' no
setup_repo Boolean Define if you want to add the PostgreSQL repo true no
hba_file String Path of pg_hba.conf file <default_os_path>/pg_hba.conf' no
ident_file String Path of pg_ident.conf file <default_os_path>/pg_ident.conf no
external_pid_file String Path of PID file /var/run/postgresql/<version></version> no
password String, nil Set postgres user password 'generate' no
port String, Integer Set listen port of postgresql service 5432 no


To install PostgreSQL server, set you own postgres password and set another service port.

postgresql_server_install 'My Postgresql Server install' do
  action :install

postgresql_server_install 'Setup my postgresql 9.5 server' do
  password 'MyP4ssw0d'
  port 5433
  action :create


This resource manages postgresql.conf configuration file.


  • modify - (default) Manager PostgreSQL configuration file (postgresql.conf)


Name Types Description Default Required?
version String Version of PostgreSQL to install '9.6' no
data_directory String Path of postgresql data directory <default_os_data_path> no
hba_file String Path of pg_hba.conf file <default_os_conf_path>/pg_hba.conf no
ident_file String Path of pg_ident.conf file <default_os_conf_path>/pg_ident.conf no
external_pid_file String Path of PID file /var/run/postgresql/<postgresql_version> no
stats_temp_directory String Path of stats file /var/run/postgresql/version>-main.pg_stat_tmp no
additional_config Hash Extra configuration for the config file {} no


To setup your PostgreSQL configuration with a specific data directory. If you have installed a specific version of PostgreSQL (different from 9.6), you must specify version in this resource too.

postgresql_server_conf 'My PostgreSQL Config' do
  version '9.5'
  data_directory '/data/postgresql/9.5/main'
  notification :reload


This resource manages postgresql extensions for a given database.


  • create - (default) Creates an extension in a given database
  • drop - Drops an extension from the database


Name Types Description Default Required?
database String Name of the database to install the extension into yes
extension String Name of the extension to install the database Name of resource yes
old_version String Older module name for new extension replacement. Appends FROM to extension query no


To install the adminpack extension:

# Add the contrib package in Ubuntu/Debian
package 'postgresql-contrib-9.6'

# Install adminpack extension
postgresql_extension 'postgres adminpack' do
  database 'postgres'
  extension 'adminpack'


This resource uses the accumulator pattern to build up the pg_hba.conf file via chef resources instead of piling on a mountain of chef attributes to make this cookbook more reusable. It directly mirrors the configuration options of the postgres hba file in the resource and by default notifies the server with a reload to avoid a full restart, causing a potential outage of service. To revoke access, simply remove the resource and the access change won't be computed into the final pg_hba.conf


  • grant - (default) Creates an access line inside of pg_hba.conf


Name Types Description Default Required?
name String Name of the access resource, this is left as a comment inside the pg_hba config Resource name yes
source String The cookbook template filename if you want to use your own custom template 'pg_hba.conf.erb' yes
cookbook String The cookbook to look in for the template source 'postgresql' yes
comment String A comment to leave above the entry in pg_hba nil no
access_type String The type of access, e.g. local or host 'local' yes
access_db String The database to access. Can use 'all' for all databases 'all' yes
access_user String The user accessing the database. Can use 'all' for any user 'all' yes
access_addr String The address(es) allowed access. Can be nil if method ident is used since it is local then nil no
access_method String Authentication method to use 'ident' yes
notification Symbol How to notify Postgres of the access change. :reload yes


To grant access to the postgresql user with ident authentication:

postgresql_access 'local_postgres_superuser' do
  comment 'Local postgres superuser access'
  access_type 'local'
  access_db 'all'
  access_user 'postgres'
  access_addr nil
  access_method 'ident'

This generates the following line in the pg_hba.conf:

# Local postgres superuser access
local   all             postgres                                ident

Note: The template by default generates a local access for Unix domain sockets only to support running the SQL execute resources. In Postgres version 9.1 and higher, the method is 'peer' instead of 'ident' which is identical. It looks like this:

# "local" is for Unix domain socket connections only
local   all             all                                     peer


This resource generate pg_ident.conf configuration file to manage user mapping between system and PostgreSQL users.


  • create - (default) Creates an mapping line inside of pg_ident.conf


Name Types Description Default Required?
mapname String Name of the user mapping Resource name yes
source String The cookbook template filename if you want to use your own custom template 'pg_ident.conf.erb' no
cookbook String The cookbook to look in for the template source 'postgresql' no
comment String, nil A comment to leave above the entry in pg_ident nil no
system_user String System user or regexp used for the mapping None yes
pg_user String Pg user or regexp used for the mapping None yes
notification Symbol How to notify Postgres of the access change. :reload no


Creates a mymapping mapping that map john system user to user1 PostgreSQL user:

postgresql_ident 'Map john to user1' do
  comment 'John Mapping'
  mapname 'mymapping'
  system_user 'john'
  pg_user 'user1'

This generates the following line in the pg_ident.conf:


# John Mapping
mymapping       john                    user1

To grant access to the foo user with password authentication:

postgresql_access 'local_foo_user' do
  comment 'Foo user access'
  access_type 'host'
  access_db 'all'
  access_user 'foo'
  access_addr ''
  access_method 'md5'

This generates the following line in the pg_hba.conf:

# Local postgres superuser access
host   all             foo                ident


This resource manages PostgreSQL databases.


  • create - (default) Creates the given database.
  • drop - Drops the given database.


Name Types Description Default Required?
database String Name of the database to create Resource name yes
user String User which run psql command 'postgres' no
template String Template used to create the new database 'template1' no
host String Define the host server where the database creation will be executed Not set (localhost) no
port Integer Define the port of Postgresql server 5432 no
encoding String Define database encoding 'UTF-8' no
locale String Define database locale 'en_US.UTF-8' no
owner String Define the owner of the database Not set no


To create database named 'my_app' with owner 'user1':

postgresql_database 'my_app' do
  owner 'user1'


This resource manage PostgreSQL users.


  • create - (default) Creates the given user with default or given privileges.
  • update - Update user privilieges.
  • drop - Deletes the given user.


Name Types Description Default Required?
user String User to create Yes
superuser Boolean Define if user needs superuser role false no
createdb Boolean Define if user needs createdb role false no
createrole Boolean Define if user needs createrole role false no
inherit Boolean Define if user inherits the privileges of roles true no
replication Boolean Define if user needs replication role false no
login Boolean Define if user can login true no
password String Set user's password no
encrypted_password String Set user's password with an hashed password no
valid_until String Define an account expiration date no


Create an user user1 with a password, with createdb role and set an expiration date to 2018, Dec 21.

postgresql_user 'user1' do
  password 'UserP4ssword'
  createdb true
  valid_until '2018-12-31'


To install and configure your PostgreSQL instance you need to create your own cookbook and call needed resources with your own parameters.

More examples can be found in test/cookbooks/test/recipes

Example Useage

Example: cookbooks/my_postgresql/recipes/default.rb

postgresql_client_install 'Postgresql Client' do
  setup_repo false
  version '9.5'

postgresql_server_install 'Postgresql Server' do
  version '9.5'
  setup_repo false
  password 'P0sgresP4ssword'

postgresql_server_conf 'PostgreSQL Config' do
  notification :reload


Please refer to each project's style guidelines and guidelines for submitting patches and additions. In general, we follow the "fork-and-pull" Git workflow.

  1. Fork the repo on GitHub
  2. Clone the project to your own machine
  3. Commit changes to your own branch
  4. Push your work back up to your fork
  5. Submit a Pull request so that we can review your changes

NOTE: Be sure to merge the latest from "upstream" before making a pull request!

[Contribution informations for this project] (


Copyright 2010-2017, Chef Software, Inc.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.

Dependent cookbooks

openssl >= 4.0
build-essential >= 2.0.0

Contingent cookbooks

akibanserver Applicable Versions
alfresco Applicable Versions
askbot Applicable Versions
bacula-server Applicable Versions
bamboo Applicable Versions
chef-bareos Applicable Versions
chef-manageiq Applicable Versions
chef_crowd Applicable Versions
chef_jira Applicable Versions
cloudfoundry-cloud_controller Applicable Versions
cloudless-box Applicable Versions
confluence Applicable Versions
crowd Applicable Versions
database Applicable Versions
database_application Applicable Versions
databox Applicable Versions
django_platform Applicable Versions
dvwa Applicable Versions
etherpad-lite Applicable Versions
eulipion-cleanspeak Applicable Versions
fanfare Applicable Versions
flyway-cli Applicable Versions
foreman Applicable Versions
github_connector Applicable Versions
gitlab Applicable Versions
gitlabhq Applicable Versions
gitrob Applicable Versions
gotcms Applicable Versions
ignite-openfire Applicable Versions
jenkins_build Applicable Versions
jira Applicable Versions
lemur Applicable Versions
liquid-feedback Applicable Versions
mediacore Applicable Versions
metarepo Applicable Versions
mirage Applicable Versions
multicorn Applicable Versions
mx Applicable Versions
noosfero Applicable Versions
oc-id Applicable Versions
openerp Applicable Versions
openfire Applicable Versions
opennms Applicable Versions
openresty Applicable Versions
openstack-mistral Applicable Versions
openstack-ops-database Applicable Versions
owncloud Applicable Versions
paramount Applicable Versions
pentester Applicable Versions
pg-multi Applicable Versions
pg_monz Applicable Versions
pg_repack Applicable Versions
postfixadmin Applicable Versions
postgis Applicable Versions
postgres-hardening Applicable Versions
postgresql-cluster Applicable Versions
pvpgn Applicable Versions
rackmonkey Applicable Versions
railsbox Applicable Versions
razor Applicable Versions
redmine2 Applicable Versions
repmgr Applicable Versions
rubycas Applicable Versions
sphinx Applicable Versions
stackstorm Applicable Versions
stash Applicable Versions
supermarket Applicable Versions
webapp Applicable Versions
zabbix Applicable Versions
zabbix-pkg Applicable Versions
zabbix_lwrp Applicable Versions

postgresql Cookbook CHANGELOG

This file is used to list changes made in each version of the postgresql cookbook.

Breaking Change Please see and the for information how to use.

v7.0.0 (25-05-2018)

  • 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 -
  • 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


  • Add 16.04 Xenial to the allowed list


  • Add leading pound symbol on pg_hba.conf template comment line
  • Update gem install for compile_time to correct deprication warning
  • Add support Ubuntu Wily Werewolf pgdg apt repository
  • test-kitchen platforms for Centos 7.2 and Ubuntu 15.04
  • Fixes PostgreSQL version & package name defaults for EL7 distros
  • Add appropriate systemd unit file overrides for EL7 distros


  • Add Code of Conduct
  • Add Rubocop
  • Clean up of syntax in many places as result of adding and evaluating Rubocop
  • Updates to test-kitchen.yml
  • added additional attribute for people who are importing pgdg packages for internal repositories

    • default['postgresql']['use_pgdg_packages'] = false


WARNING: Please read carefully through the stated changes, as they probably will break your current setup and can result in duplicate postgresql versions being installed, configuration corruption and data loss! This list might not be complete, so be careful when using the 4.x version and make sure to test it extensively before production use!

When in doubt, put the following in your Berksfile until you are ready to upgrade:

cookbook 'postgresql', '~> 3.4.0'
  • Potential breaking change: Restructured default attributes to avoid compile time deriving other attribute values from value of the node[‘postgresql’][‘version’] (#313, #302, #295, #288, #280, #261, #260, #254, #248, #217, #214, #167, #143). If you specify a custom postgresql version, make sure to adapt the following attributes as well:
default['postgresql']['dir'] = "/etc/postgresql/#{node['postgresql']['version']}/main"
default['postgresql']['client']['packages'] = [ "postgresql-client-#{node['postgresql']['version']}", 'libpq-dev' ]
default['postgresql']['server']['packages'] = [ "postgresql-#{node['postgresql']['version']}" ]
default['postgresql']['contrib']['packages'] = [ "postgresql-contrib-#{node['postgresql']['version']}" ]
  • Potential breaking change: SSL configuration parameters. Due to the new structuring, make sure you set all SSL attributes to override when specifying them in a cookbook:
override['postgresql']['config']['ssl'] = true
override['postgresql']['config']['ssl_cert_file'] = "/path/to/cert.crt"
override['postgresql']['config']['ssl_key_file']  = "/path/to/cert.key"
override['postgresql']['config']['ssl_ciphers']  = "<my cipher suite>"
  • Potential breaking change: Some node attributes are now persistet in your node configuration. This affects the following attributes:
"config": {
  "data_directory": "/var/lib/postgresql/9.4/main",
  "hba_file": "/etc/postgresql/9.4/main/pg_hba.conf",
  "ident_file": "/etc/postgresql/9.4/main/pg_ident.conf",
  "external_pid_file": "/var/run/postgresql/",
  "unix_socket_directories": "/var/run/postgresql",
  "ssl_cert_file": "/etc/ssl/certs/ssl-cert-snakeoil.pem",
  "ssl_key_file": "/etc/ssl/private/ssl-cert-snakeoil.key"
  • Potential breaking change: Parsing of attributes from node/ environment configuration. It has been reported that setting the node['postgresql']['client']['packages'] attribute in a cookbook might result in the default version of the postgresql client package being installed alongside the required version. This might affect the server packages as well.
  • Correct issues which caused the inability to override installation version defaults
  • Correct issues which caused configuration file entries with miss matching version numbers and incorrect file system paths being defined
  • Remove method pgdgrepo_rpm_info compile time use of derived attributes case many issues
  • Use correct directory path and check for the correct not_if condition to determine if the database has been initialized
  • Ensure that correct packages are installed in all scenarios where pg gem is compiled
  • Fix errors in configuration files for unix_socket_directory and unix_socket_directories
  • Updates to test-kitchen suite configuration
  • Added more grey hair to my beard


  • Corrections to address repositories signed with newer certificates that some distributions have in their default ca-certificates package
  • Updates to more accurately determine distributions service init systems adds better support for systemd systems
  • Correct how version attribute is evaluated in certain places
  • test-kitchen suite configuration corrections
  • Opensuse support


  • Skipping 3.4.22 with Develop branch 3.4.23 to return to releasing cookbook from master on even numbers and develop on odd numbers.


  • Use more optimistic openssl version constraint
  • Add Postgresql 9.4 package sources for RHEL platforms
  • Update testing infrastructure to address bit rot


  • Revert #251, a change which caused the postgresql service to restart every Chef run.


  • could better not be run on every chef run since it causes node.default attributes stored to the node objects to differ during a chef run and when
  • Missing attribute in docs for yum_pgdg_postgresql
  • restart postgres service immediately on config change
  • Run restart command right away on the postgresql service.
  • Add kitchen test for shared_preload_libraries & extension setup.
  • Fix install order of contrib packages to fix pg_stat_statements issues.
  • Add Debian Jessie to whitelist for repo
  • Install version 9.4 on Debian Jessie
  • add amazon 2015
  • add rhel7 support


  • Revert changes from #201 with the intention of revisiting these changes as part of the next major version release.
  • Specify version constraint on openssl cookbook due to an upstream release mishap


  • Changed hard coded value to attribute #219
  • Correction for directory creation under debian, etc. #222
  • Fedora 20 yum support #223
  • Define version-sensitive attributes in a recipe #201


  • Support apt repository for Ubuntu Utopic 14.10
  • Do not try and set password on standby hosts


  • Create configuration templates at the appropriate time
  • If template is updated restart service changed to default of :delayed
  • Fix SSL for PostgreSQL versions < 9.2


  • correct conditional error created in 3.4.8.


  • Correct scenario where work_mem could be set to 0 if con is greater than mem Issue #185
  • Add Centos7 suites to kitchen configuration


  • Don't include the pgdg recipes on the wrong machine types
  • Add missing dir /etc/sysconfig/pgsl for centos7
  • CentOS 7 package support


  • fix packages on SLES11SP2 and higher
  • [COOK-4737] Add flag to control database user password behavior
  • add amazon platform rpm info
  • Fix issues with the server_redhat recipe on Fedora 16 and later
  • attribute typo correction
  • correctly check and set max_connections to an integer


  • Changed the Gem::Installer::ExtensionBuildError to a Mixlib::ShellOut::ShellCommandFailed



Updated CONTRIBUTING document. Refreshed test kitchen configuration. Merged Pull Requests: 122, 116, 104, 102, 99, 96, 93, 90.




  • Testing maintainer transfer to Heavywater with Opscode as collaborator



  • COOK-3851 - Postgresql: reload after config change does not pick up certain configuration changes
  • COOK-3611 - unix_socket_directory does not exists in 9.3
  • COOK-2954 - PostgreSQL installation ignores version attribute on CentOS >= 6


  • [COOK-3717] Pgdg repositories improvements
  • [COOK-3756] Change postgresql.conf mode from 0600 to 0644



  • COOK-3685 - Upgrade Repo Attributes for Postgresql 9.3
  • COOK-3597 - Fix implementation of initdb_locale attribute for RHEL
  • COOK-3566 - Give the user's rules more priority than the default ones in pg_hba
  • COOK-3553 - Remove automatic apt-get update


  • COOK-3611 - Remove unix_socket_directory (it does not exists in 9.3)
  • COOK-3599 - Automatically add PGDG apt repo dependency on PostgreSQL version
  • COOK-3555 - Documentation Fix
  • COOK-2383 - Update Postgres version in attributes



  • COOK-3173 - Use :reload instead of :restart on conf changes
  • COOK-2939 - Fix RedHat support



  • [COOK-3076]: postgresql::ruby recipe error when using pgdg repositories


This is a backwards-incompatible release because the Pitti PPA is deprecated and the recipe removed, replaced with the PGDG apt repository.


  • [COOK-2571]: Create helper library for pg extension detection
  • [COOK-2797]: Contrib extension contianing '-' fails to load.


  • [COOK-2387]: Pitti Postgresql PPA is deprecated


  • [COOK-3022]: update baseboxes in .kitchen.yml


  • [COOK-2163] - Dangerous "assign-postgres-password" in "recipes/server.rb" -- Can lock out dbadmin access
  • [COOK-2390] - Recipes to auto-generate many postgresql.conf settings, following "initdb" and "pgtune"
  • [COOK-2435] - Foodcritic fixes for postgresql cookbook
  • [COOK-2476] - Installation into database of any contrib module extensions listed in a node attribute


  • [COOK-2232] -Provide PGDG yum repo to install postgresql 9.x on redhat-derived distributions


  • [COOK-2230] - Careful about Debian minor version numbers
  • [COOK-2231] - Fix support for postgresql 9.x in server_redhat recipe
  • [COOK-2238] - Postgresql recipe error in password check
  • [COOK-2176] - PostgreSQL cookbook in Solo mode can cause "NoMethodError: undefined method `[]' for nil:NilClass"
  • [COOK-2233] - Provide postgresql::contrib recipe to install useful server administration tools


  • [COOK-1872] - Allow latest PostgreSQL deb packages to be installed
  • [COOK-1961] - Postgresql config file changes with every Chef run
  • [COOK-2041] - Postgres cookbook no longer installs on OpenSuSE 11.4


  • [COOK-1406] - pg gem compile is unable to find libpq under Chef full stack (omnibus) installation


This version is backwards incompatible with previous versions of the cookbook due to use of platform_family, and the refactored configuration files using node attributes. See for details on how to modify configuration of PostgreSQL.

  • [COOK-1508] - fix mixlib shellout error on SUSE
  • [COOK-1744] - Add service enable & start
  • [COOK-1779] - Don't run apt-get update and others in ruby recipe if pg is installed
  • [COOK-1871] - Attribute driven configuration files for PostgreSQL
  • [COOK-1900] - don't assume ssl on all postgresql 8.4+ installs
  • [COOK-1901] - fail a chef-solo run when the postgres password attribute is not set


Important note for this release

This version no longer installs Ruby bindings in the client recipe by default. Use the ruby recipe if you'd like the RubyGem. If you'd like packages for your distribution, use them in your application's specific cookbook/recipe, or modify the client packages attribute.

This resolves the following tickets.

  • COOK-1011
  • COOK-1534

The following issues are also resolved with this release.

  • [COOK-1011] - Don't install postgresql packages during compile phase and remove pg gem installation
  • [COOK-1224] - fix undefined variable on Debian
  • [COOK-1462] - Add attribute for specifying listen address


  • [COOK-421] - config template is malformed
  • [COOK-956] - add make package on ubuntu/debian


  • [COOK-916] - use < (with float) for version comparison.


  • Better support for Red Hat-family platforms
  • Integration with database cookbook
  • Make sure the postgres role is updated with a (secure) password

Collaborator Number Metric

7.0.0 passed this metric

Contributing File Metric

7.0.0 passed this metric

Foodcritic Metric

7.0.0 passed this metric

No Binaries Metric

7.0.0 passed this metric

Testing File Metric

7.0.0 passed this metric

Version Tag Metric

7.0.0 passed this metric