The current postgres module doesn't implement replication by default. I use the module to build up the DB and get everything going, but the log shipping is setup manually since the failover would be manual. Postgres/mysql are moving towards handling this better internally so the issue may be moot in the future. PuppetPE with orchestrator may take out some of the complexity and make it more trivial and i know they're making a new PE PupeptDB that is more active/active.
I found out the hard way though i was better off making sure i could rebuild PuppetDB quickly than needing an HA puppetdb.. puppetdb itself has never died on us so the usecase of availability has gone out the door and they have optimized it nicely that distributed reads isn't an issue anymore and quite frankly, created more problems than i wished. It stinks when the log shipper fails and you get stale reads because you're configured to read from read-only standby but all of the tooling is behaving like everything is a-ok.. once i started writing conditional logic to look for these exceptions i realized that was a job i didn't want to have so i just made it super trivial to bootstrap and collect data quickly again. we don't use exported resources or anything that would cause a state failure in our system if puppetdb failed, just nodes would be in limbo for the period querying some stuff but its a safe failed state. On Wednesday, February 24, 2016 at 9:05:24 PM UTC-6, Ken Lareau wrote: > > I'm not sure if anyone here will be able to help, but I feel I need to > give it > a shot, so... > > My team is in the process of getting ready to use PostgreSQL, but before > that I need to ensure that our Puppet infrastructure can manage the systems > properly, which means making sure replication stays working even when > a box needs to be rebuilt. I'm using the PuppetLabs 'postgresql' module > which seems pretty thorough, but I don't believe it's sufficient to > actually > handle recovery from a rebuild, so I'm asking here to see if anyone's > already > gone through this process before and could give some pointers, perhaps? > The plan is to use the latest release (9.5.1) which is supposed to make > this > easier, but digging around the web hasn't turned up anything useful so far. > Might someone be able to help? I can give more details as needed. > > (Apologies if this is off-topic for this list in any way.) > > Thanks in advance. > > -- > Ken Lareau > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/517830ca-f2a0-4324-b94c-bbe3f978781a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
