Fix the non-defaults test failing to use UTF8

The non-default tests try to set UTF8 when UTF8 is not installed on the en_US
machine. These are non-default settings anyway, but one should presume the
correct locale should be set before this is attempted, this patch includes
that step.

In an ideal world we would use a locale module to do this.

This patch also fixes an Ubuntu 10.04 issue where you need to be absolute about
the locale and encoding as well.

Signed-off-by: Ken Barber <ken@bob.sh>
Merge pull request #194 from kbarber/fixed_failing_utf8_tests

Fix the non-defaults test failing to use UTF8
Alter superuser, createdb, createrole, login, replication status and the connection limit of a role that already exists

Previously we only created a new user, any updates to the defined resource
would not update the role. This patch adds extra logic to modify a role
whenever a parameter is changed.

System tests have also been added to support this.
Merge branch 'alter_existing_user'

* alter_existing_user:
  Alter superuser, createdb, createrole, login, replication status and the connection limit of a role that already exists
Add support for optional management of pg_hba.conf

This patch adds support for disabling management of pg_hba.conf by the module,
through the parameter `manage_pg_hba_conf`.
Merge branch 'manage_pg_hba_conf'

* manage_pg_hba_conf:
  Add support for optional management of pg_hba.conf
Add support for istemplate parameter where creating db
Fix rspec-system
Add support for installing PL/Perl
Document istemplate parameter
Add missing manifests/plperl.pp file
Use $::operatingsystemrelease instead of $::lsbmajdistrelease
Set plperl_package_name to postgresql-plperl on every RedHat family OS except RHEL5
Test plperl only on non standard installation as it does not work on redhat5
Split database_grant up

The code to grant permissions databases and their objects has been
abstracted to `postgresql::grant` and is used by both
`postgresql::database_grant` and `postgresql::table_grant`
Reindent postgresql::database_grant spec
Update readme
Merge pull request #208 from hunner/add_grants

Add grant abilities for more that databases
Tag the postgresql-contrib package as postgresql
Merge pull request #205 from mcanevet/plperl

Add support for installing PL/Perl