Anyone really using Postgres for a Hiera backend?

[leam hall]

Just wondering. I found some options but don't see any under current development.

Leam

--

Mind on a Mission

[Martin]

Funny, I'd rather ask: is anyone *not* using Postgres?

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CACv9p5p5La7KacvTn1RG-V-E30K77Zt873SBR8_7s%2BbvV6Oy8A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[jcbollinger]

On Wednesday, May 13, 2015 at 3:10:29 PM UTC-5, Martin Marcher wrote:

Funny, I'd rather ask: is anyone *not* using Postgres?

Postgres for PuppetDB for sure, but for an Hiera back end?  I'm sure there indeed are people who use a Postgres-based Hiera back end, but I have seen no evidence to suggest that doing so is remotely common.

The most commonly used Hiera backend seems to be the built-in YAML one, which should be no surprise to anyone.  The JSON back end also seems popular, and the eYAML backend sees some use, too.  As judged by traffic on this group, no other Hiera backend moves the needle.

John

[Corey Osman]

What is the use case for a SQL hiera backend?  This seems like an oxymoron.  Do you have some sort of UI wrapped around it for data input? Also you could just create a data binding terminus for postgres.

example: https://github.com/domcleal/foreman_data_binding

Corey

[Tony Thayer]

I used this one a while back: https://github.com/tioteath/hiera-psql

The main issue I ran into was it required a very recent version of Postgres in order to use the JSON column type. I had a django frontend hooked into it to allow for easily updating node definitions.

On Wednesday, May 13, 2015 at 9:45:55 AM UTC-7, leam hall wrote:

[Tony Thayer]

Actually, I just realized I was using my own fork of the original: https://github.com/tthayer/hiera-psql

I'm not using it actively anymore and I doubt my previous employer is still using it either. There is an open issue stating that it doesn't work with the new puppetserver, too: https://github.com/dalen/hiera-psql/issues/7

On Wednesday, May 13, 2015 at 9:45:55 AM UTC-7, leam hall wrote:

[Garrett Honeycutt]

Hi,

I'm actually using PostgreSQL for some Hiera data, but using a simple
Sinatra web app to present that data to Hiera. From a security
perspective, this allows me to limit my exposure by only allowing puppet
masters to speak to the web app, which in turn can speak to the
database. It also makes it easier to switch between database backends
and most importantly, do multiple queries and data munging.

Recommend checking out hiera-http[1] and hiera-rest[2] from Craig Dunn
and Ben Ford, respectively.

[1] - https://github.com/crayfishx/hiera-http
[2] - https://github.com/binford2k/hiera-rest

Best regards,
-g

--
Garrett Honeycutt
@learnpuppet
Puppet Training with LearnPuppet.com
Mobile: +1.206.414.8658

[Erik Dalén]

Yeah, I'm not really using puppet server (yet at least) or the postgres hiera backend. So if someone else wants to take over maintainership of it I can transfer the repo ownership.

--

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/6a3391ec-22d7-4f43-b7f0-7036ee722869%40googlegroups.com.

[Tom De Vylder]

Puppet-Community [1] would be a prime example to take over the maintainership.

[1] https://github.com/puppet-community/

Tom

To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAAAzDLd-WGbX3iceb99NJF_b%2BgCjNFe8oHjqE%3DH8ZXW--K%3D1FA%40mail.gmail.com.