Ask Your Question
0

puppetlabs/postgresql needs to support v9.4 - how to change?

asked 2016-01-21 02:17:18 -0500

Per H gravatar image

ver 9.2 was released 2012 and is a bit old - too bad it is default in RHEL7. But, 9.3 introduced critical features, we have 9.4 and 9.5 out now ...

How do I use this module to install and manage the later versions?

It is very hard to find any limitations in the https://forge.puppetlabs.com/puppetla... page on versions - and why should there be, it should give a notice of how far it was well-tested, and a way to point out any yum source url or even local rpm package for the postgres base version?

Especially as puppets own embedded postgres database is v9.4.5, whys is the supported module so far behind?

TIA

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2016-01-22 10:20:32 -0500

Grant Croker gravatar image

We use RHEL 6.x machines with PG 9.4 and install the official PostgreSQL 9.4 RPMs using the following code:

class { 'postgresql::globals':
    version          => '9.4',
    service_name     => 'postgresql-9.4',
    needs_initdb     => true,
    confdir          => $pg_data_dir,
    pg_hba_conf_path => "${pg_data_dir}/pg_hba.conf",
    bindir           => '/usr/pgsql-9.4/bin',
    encoding         => 'UTF-8',
    locale           => 'en_US.UTF-8',
    require          => File['/etc/yum.repos.d/postgres.repo'],
}->
class { 'postgresql::server':
    ip_mask_deny_postgres_user => '0.0.0.0/32',
    postgres_password          => $db_postgres_password,
    listen_addresses           => $pg_listen_address,
    require                    => File['/etc/yum.repos.d/postgres.repo'],
}

You might be able to get away with less "manifest" code as this is what we used to install 9.4 alongside 8.4. Perhaps version => '9.4' is all you need?

edit flag offensive delete link more

Comments

Thanks, this was an excellent answer. It turned out much of my problems was mostly due to the fact I used the official REDHAT-PACKAGED version from RedHat software channel, and it's packing differs enough to throw the postgresql module of track.

Per H gravatar imagePer H ( 2016-03-08 18:04:17 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2016-01-21 02:17:18 -0500

Seen: 257 times

Last updated: Jan 22 '16