1 2013-07-19 Release 2.4.0
2 ========================
6 This updates adds the ability to change permissions on tables, create template
7 databases from normal databases, manage PL-Perl's postgres package, and
8 disable the management of `pg_hba.conf`.
12 - Add `postgresql::table_grant` defined resource
13 - Add `postgresql::plperl` class
14 - Add `manage_pg_hba_conf` parameter to the `postgresql::config` class
15 - Add `istemplate` parameter to the `postgresql::database` define
19 - Update `postgresql::role` class to be able to update roles when modified
20 instead of only on creation.
22 - Fix documentation of `postgresql::database_grant`
27 This feature release includes the following changes:
29 * Add a new parameter `owner` to the `database` type. This can be used to
30 grant ownership of a new database to a specific user. (Bruno Harbulot)
31 * Add support for operating systems other than Debian/RedHat, as long as the
32 user supplies custom values for all of the required paths, package names, etc.
34 * Improved integration testing (Ken Barber)
39 This release fixes a bug whereby one of our shell commands (psql) were not ran from a globally accessible directory. This was causing permission denied errors when the command attempted to change user without changing directory.
41 Users of previous versions might have seen this error:
43 Error: Error executing SQL; psql returned 256: 'could not change directory to "/root"
45 This patch should correct that.
49 * Set /tmp as default CWD for postgresql_psql
54 This feature release introduces a number of new features and bug fixes.
56 First of all it includes a new class named `postgresql::python` which provides you with a convenient way of install the python Postgresql client libraries.
58 class { 'postgresql::python':
61 You are now able to use `postgresql::database_user` without having to specify a password_hash, useful for different authentication mechanisms that do not need passwords (ie. cert, local etc.).
63 We've also provided a lot more advanced custom parameters now for greater control of your Postgresql installation. Consult the class documentation for PuppetDB in the README.
65 This release in particular has largely been contributed by the community members below, a big thanks to one and all.
69 * Add support for psycopg installation (Flaper Fesp and Dan Prince)
70 * Added default PostgreSQL version for Ubuntu 13.04 (Kamil Szymanski)
71 * Add ability to create users without a password (Bruno Harbulot)
72 * Three Puppet 2.6 fixes (Dominic Cleal)
73 * Add explicit call to concat::setup when creating concat file (Dominic Cleal)
74 * Fix readme typo (Jordi Boggiano)
75 * Update postgres_default_version for Ubuntu (Kamil Szymanski)
76 * Allow to set connection for noew role (Kamil Szymanski)
77 * Fix pg_hba_rule for postgres local access (Kamil Szymanski)
78 * Fix versions for travis-ci (Ken Barber)
79 * Add replication support (Jordi Boggiano)
80 * Cleaned up and added unit tests (Ken Barber)
81 * Generalization to provide more flexability in postgresql configuration (Karel Brezina)
82 * Create dependent directory for sudoers so tests work on Centos 5 (Ken Barber)
83 * Allow SQL commands to be run against a specific DB (Carlos Villela)
84 * Drop trailing comma to support Puppet 2.6 (Michael Arnold)
89 This release provides a bug fix for RHEL 5 and Centos 5 systems, or specifically systems using PostgreSQL 8.1 or older. On those systems one would have received the error:
91 Error: Could not start Service[postgresqld]: Execution of ‘/sbin/service postgresql start’ returned 1:
93 And the postgresql log entry:
95 FATAL: unrecognized configuration parameter "include"
97 This bug is due to a new feature we had added in 2.1.0, whereby the `include` directive in `postgresql.conf` was not compatible. As a work-around we have added checks in our code to make sure systems running PostgreSQL 8.1 or older do not have this directive added.
101 2013-01-21 - Ken Barber <ken@bob.sh>
102 * Only install `include` directive and included file on PostgreSQL >= 8.2
103 * Add system tests for Centos 5
108 This release is primarily a feature release, introducing some new helpful constructs to the module.
110 For starters, we've added the line `include 'postgresql_conf_extras.conf'` by default so extra parameters not managed by the module can be added by other tooling or by Puppet itself. This provides a useful escape-hatch for managing settings that are not currently managed by the module today.
112 We've added a new defined resource for managing your tablespace, so you can now create new tablespaces using the syntax:
114 postgresql::tablespace { 'dbspace':
115 location => '/srv/dbspace',
118 We've added a locale parameter to the `postgresql` class, to provide a default. Also the parameter has been added to the `postgresql::database` and `postgresql::db` defined resources for changing the locale per database:
120 postgresql::db { 'mydatabase':
122 password => 'mypassword',
127 There is a new class for installing the necessary packages to provide the PostgreSQL JDBC client jars:
129 class { 'postgresql::java': }
131 And we have a brand new defined resource for managing fine-grained rule sets within your pg_hba.conf access lists:
133 postgresql::pg_hba { 'Open up postgresql for access from 200.1.2.0/24':
137 address => '200.1.2.0/24',
138 auth_method => 'md5',
141 Finally, we've also added Travis-CI support and unit tests to help us iterate faster with tests to reduce regression. The current URL for these tests is here: https://travis-ci.org/puppetlabs/puppet-postgresql. Instructions on how to run the unit tests available are provided in the README for the module.
143 A big thanks to all those listed below who made this feature release possible :-).
145 #### Detailed Changes
147 2013-01-18 - Simão Fontes <simaofontes@gmail.com> & Flaper Fesp <flaper87@gmail.com>
148 * Remove trailing commas from params.pp property definition for Puppet 2.6.0 compatibility
150 2013-01-18 - Lauren Rother <lauren.rother@puppetlabs.com>
151 * Updated README.md to conform with best practices template
153 2013-01-09 - Adrien Thebo <git@somethingsinistral.net>
154 * Update postgresql_default_version to 9.1 for Debian 7.0
156 2013-01-28 - Karel Brezina <karel.brezina@gmail.com>
157 * Add support for tablespaces
159 2013-01-16 - Chris Price <chris@puppetlabs.com> & Karel Brezina <karel.brezina@gmail.com>
160 * Provide support for an 'include' config file 'postgresql_conf_extras.conf' that users can modify manually or outside of the module.
162 2013-01-31 - jv <jeff@jeffvier.com>
163 * Fix typo in README.pp for postgresql::db example
165 2013-02-03 - Ken Barber <ken@bob.sh>
166 * Add unit tests and travis-ci support
168 2013-02-02 - Ken Barber <ken@bob.sh>
169 * Add locale parameter support to the 'postgresql' class
171 2013-01-21 - Michael Arnold <github@razorsedge.org>
172 * Add a class for install the packages containing the PostgreSQL JDBC jar
174 2013-02-06 - fhrbek <filip.hbrek@gmail.com>
175 * Coding style fixes to reduce warnings in puppet-lint and Geppetto
177 2013-02-10 - Ken Barber <ken@bob.sh>
178 * Provide new defined resource for managing pg_hba.conf
180 2013-02-11 - Ken Barber <ken@bob.sh>
181 * Fix bug with reload of Postgresql on Redhat/Centos
183 2013-02-15 - Erik Dalén <dalen@spotify.com>
184 * Fix more style issues to reduce warnings in puppet-lint and Geppetto
186 2013-02-15 - Erik Dalén <dalen@spotify.com>
187 * Fix case whereby we were modifying a hash after creation
192 Minor bugfix release.
194 2013-01-16 - Chris Price <chris@puppetlabs.com>
195 * Fix revoke command in database.pp to support postgres 8.1 (43ded42)
197 2013-01-15 - Jordi Boggiano <j.boggiano@seld.be>
198 * Add support for ubuntu 12.10 status (3504405)
203 Many thanks to the following people who contributed patches to this
223 * William Van Hevelingen
227 * Add support for versions of postgres other than the system default version
228 (which varies depending on OS distro). This includes optional support for
229 automatically managing the package repo for the "official" postgres yum/apt
230 repos. (Major thanks to Etienne Pelletier <epelletier@maestrodev.com> and
231 Ken Barber <ken@bob.sh> for their tireless efforts and patience on this
232 feature set!) For example usage see `tests/official-postgresql-repos.pp`.
234 * Add some support for Debian Wheezy and Ubuntu Quantal
236 * Add new `postgres_psql` type with a Ruby provider, to replace the old
237 exec-based `psql` type. This gives us much more flexibility around
238 executing SQL statements and controlling their logging / reports output.
240 * Major refactor of the "spec" tests--which are actually more like
241 acceptance tests. We now support testing against multiple OS distros
242 via vagrant, and the framework is in place to allow us to very easily add
243 more distros. Currently testing against Cent6 and Ubuntu 10.04.
245 * Fixed a bug that was preventing multiple databases from being owned by the
247 (9adcd182f820101f5e4891b9f2ff6278dfad495c - Etienne Pelletier <epelletier@maestrodev.com>)
249 * Add support for ACLs for finer-grained control of user/interface access
250 (b8389d19ad78b4fb66024897097b4ed7db241930 - dharwood <harwoodd@cat.pdx.edu>)
252 * Many other bug fixes and improvements!
257 2012-09-17 - Version 0.3.0 released
259 2012-09-14 - Chris Price <chris@puppetlabs.com>
260 * Add a type for validating a postgres connection (ce4a049)
262 2012-08-25 - Jari Bakken <jari.bakken@gmail.com>
263 * Remove trailing commas. (e6af5e5)
265 2012-08-16 - Version 0.2.0 released