Automated PuppetDB/PostgreSQL install?

[Keith Miller]

Hey guys, new to Puppet and looking for some help. Some facts first:

• Using Ubuntu 16.04
• Cluster will be of about 60-80 nodes
• Building the infrastructure with Terraform
• Have Puppet Server and Puppet Agents installing through automated startup scripts and working.

So I'm looking to see if it's possible to automate the install of PuppetDB and PostgreSQL, hopefully on the Puppet Server machine. I found multiple instructions on how to install, but they all seem to involve manual setup of the PostgreSQL database. Any help would be appreciated. 

Thanks!

[Lowe Schmidt]

Doesn't the puppetdb module do what you want? 

https://forge.puppet.com/puppetlabs/puppetdb#setup

--

Lowe Schmidt | +46 723 867 157

--
You received this message because you are subscribed to the Google Groups "Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/6a57ce96-c30a-478d-aeaf-0c7d230ffc24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andrew Grimberg]

On 07/22/2017 09:50 AM, Keith Miller wrote:
> Hey guys, new to Puppet and looking for some help. Some facts first:
>

> * Using Ubuntu 16.04
> * Cluster will be of about 60-80 nodes
> * Building the infrastructure with Terraform
> * Have Puppet Server and Puppet Agents installing through automated

> startup scripts and working.
>
> So I'm looking to see if it's possible to automate the install of
> PuppetDB and PostgreSQL, hopefully on the Puppet Server machine. I found
> multiple instructions on how to install, but they all seem to involve
> manual setup of the PostgreSQL database. Any help would be appreciated.
>
> Thanks!

When we were building up our Puppet infrastructure we initially
configured the puppet master to not use PuppetDB. Then we added in the
PuppetDB module and PostgreQL modules and had them properly configure
things. Once that was done we stepped the puppet master into using PuppetDB.

-Andy-

[Keith Miller]

I ended up having to do the same thing. Thanks for the guidance! 

[Keith Miller]

It could, I don't know. I'm new to Puppet so installing PuppetDB as a module before Puppet Server was installed was very confusing starting out. I ended up writing a Bash script following Andrew Grimberg's flow. 

Thanks

On Sunday, July 23, 2017 at 2:27:17 AM UTC-7, Lowe Schmidt wrote:

Doesn't the puppetdb module do what you want? 

https://forge.puppet.com/puppetlabs/puppetdb#setup

--

Lowe Schmidt | +46 723 867 157

On 22 July 2017 at 18:50, Keith Miller <kee...@gmail.com> wrote:

Hey guys, new to Puppet and looking for some help. Some facts first:

• Using Ubuntu 16.04
• Cluster will be of about 60-80 nodes
• Building the infrastructure with Terraform
• Have Puppet Server and Puppet Agents installing through automated startup scripts and working.

So I'm looking to see if it's possible to automate the install of PuppetDB and PostgreSQL, hopefully on the Puppet Server machine. I found multiple instructions on how to install, but they all seem to involve manual setup of the PostgreSQL database. Any help would be appreciated. 

Thanks!

--
You received this message because you are subscribed to the Google Groups "Puppet Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users...@googlegroups.com.

[Martijn]

I did the same thing last week during our Puppet 4 upgrade process. Removed our very old Puppetdb instance with its embedded db. Then upgraded Puppetserver to the latest and when it was working fine by itself I installed the puppetlabs-puppetdb module to install PostgreSQL and Puppetdb. Since our Puppetdb runs on the same host as the puppetserver the installation was extremely easy. I only had to add the following lines to our puppetmaster role:

  class { 'puppetdb':
    listen_addresses => '0.0.0.0',
  }

  class { 'puppetdb::master::config': }

Regards, Martijn

Op maandag 24 juli 2017 15:37:23 UTC+2 schreef Andrew Grimberg:

[Keith Miller]

That is a lot simpler then the bash script I cooked up :) 

Thanks!