postgresql (121) Versions 7.0.0 Follow349

Installs and configures postgresql for clients or servers

Policyfile

Berkshelf

Knife

cookbook 'postgresql', '= 7.0.0', :supermarket

cookbook 'postgresql', '= 7.0.0'

knife supermarket install postgresql

knife supermarket download postgresql

README

Dependencies

Changelog

Quality 100%

postgresql cookbook

Installs and configures PostgreSQL as a client or a server.

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 7+
Ubuntu 14.04+
Red Hat/CentOS/Scientific 6+
Fedora

PostgreSQL version

We follow the currently supported versions listed on https://www.postgresql.org/support/versioning/

The earliest supported version is currently:

9.3 (9.3.23)

Chef

Chef 13.8+

Cookbook Dependencies

openssl
build-essential

Resources

postgresql_client_install

This resource installs PostgreSQL client packages.

Actions

install - (default) Install client packages

Properties

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}-main.pid`	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

Examples

To install '9.5' version:

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

postgresql_server_install

This resource installs PostgreSQL client and server packages.

Actions

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

Properties

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>-main.pid</version>`	no
`password`	String, nil	Set postgres user password	'generate'	no
`port`	String, Integer	Set listen port of postgresql service	5432	no

Examples

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

postgresql_server_install 'My Postgresql Server install' do
  action :install
end

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

postgresql_server_conf

This resource manages postgresql.conf configuration file.

Actions

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

Properties

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>-main.pid`	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

Examples

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
end

postgresql_extension

This resource manages postgresql extensions for a given database.

Actions

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

Properties

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

Examples

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'
end

postgresql_access

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

Actions

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

Properties

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

Examples

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'
end

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

postgresql_ident

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

Actions

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

Properties

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

Examples

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'
end

This generates the following line in the pg_ident.conf:

# MAPNAME       SYSTEM-USERNAME         PG-USERNAME

# 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 '127.0.0.1/32'
  access_method 'md5'
end

This generates the following line in the pg_hba.conf:

# Local postgres superuser access
host   all             foo               127.0.0.1/32           ident

postgresql_database

This resource manages PostgreSQL databases.

Actions

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

Properties

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

Examples

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

postgresql_database 'my_app' do
  owner 'user1'
end

postgresql_user

This resource manage PostgreSQL users.

Actions

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

Properties

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

Examples

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'
end

Usage

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'
end

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

postgresql_server_conf 'PostgreSQL Config' do
  notification :reload
end

Contributing

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.

Fork the repo on GitHub
Clone the project to your own machine
Commit changes to your own branch
Push your work back up to your fork
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] (CONTRIBUTING.md)

License

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

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
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

postgresql Cookbook CHANGELOG

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

Breaking Change Please see UPGRADING.md and the README.md 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 - 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

v4.0.6

Add 16.04 Xenial to the allowed list

v4.0.4

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

v4.0.2

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

v4.0.0

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/9.4-main.pid",
  "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

v3.4.24

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

v3.4.23

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.

v3.4.21

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

v3.4.20

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

v3.4.19

node.save 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 apt.postgresql.org repo
Install version 9.4 on Debian Jessie
add amazon 2015
add rhel7 support

v3.4.18

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

v3.4.16

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

v3.4.14

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

v3.4.12

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

v3.4.10

correct conditional error created in 3.4.8.

v3.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

v3.4.6

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

v3.4.4

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

v3.4.2

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

v3.4.1

Added support for Ubuntu 14.04 and Postgresql 9.3
Fix [COOK-3490] https://tickets.opscode.com/browse/COOK-3490

v3.4.0

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

v3.3.4

Testing

v3.3.2

Testing maintainer transfer to Heavywater with Opscode as collaborator

v3.3.0

Bug

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

v3.2.0

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

v3.1.0

Improvement

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

Bug

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

v3.0.4

Bug

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

v3.0.2

Bug

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

v3.0.0

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

Bug

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

Improvement

[COOK-2387]: Pitti Postgresql PPA is deprecated

Task

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

v2.4.0

[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

v2.2.2

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

v2.2.0

[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

v2.1.0

[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

v2.0.2

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

v2.0.0

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 README.md 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

v1.0.0

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

v0.99.4

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

v0.99.2

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

v0.99.0

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

Adoptable Cookbooks List

Supermarket Belongs to the Community

View our collection of guides, documentation, and articles

Select Badges

Select Supported Platforms

Select Status

postgresql cookbook

Upgrading

Requirements

Platforms

PostgreSQL version

Chef

Cookbook Dependencies

Resources

postgresql_client_install

Actions

Properties

Examples

postgresql_server_install

Actions

Properties

Examples

postgresql_server_conf

Actions

Properties

Examples

postgresql_extension

Actions

Properties

Examples

postgresql_access

Actions

Properties

Examples

postgresql_ident

Actions

Properties

Examples

postgresql_database

Actions

Properties

Examples

postgresql_user

Actions

Properties

Examples

Usage

Example Useage

Contributing

License

Dependent cookbooks

Contingent cookbooks

postgresql Cookbook CHANGELOG

v7.0.0 (25-05-2018)

v6.1.3 (2018-04-18)

v6.1.2 (2018-04-16)

v6.1.1 (2017-03-08)

v6.1.0 (2017-02-18)

v6.0.1 (2017-01-04

v6.0.0 (2017-01-03)

v5.2.0 (2016-12-30)

v5.1.0 (2016-11-01)

v5.0.0 (2016-10-25)

Breaking changes

Other changes

v4.0.6

v4.0.4

v4.0.2

v4.0.0

v3.4.24

v3.4.23

v3.4.21

v3.4.20

v3.4.19

v3.4.18

v3.4.16

v3.4.14

v3.4.12

v3.4.10

v3.4.8

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