Foreman 1.7 & postgres with pgpool-II or active/stdby db

Support
1

Anyone using the foreman with a PgPool-II Postgres cluster? or using log
ship standby?

2

Hey. I'm using it like that.
Foreman is talking to pgPool cluster, active active, and pgPool forward
queries to 6 PostgreSQL backends, streaming replication.

··· On 8 Dec 2014 04:23, "Byron Miller" wrote:

Anyone using the foreman with a PgPool-II Postgres cluster? or using log
ship standby?

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at http://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

3

fantastic! have you ran into any issues or quirks? looks like latest
pgpool-II is pretty safe for most transactions foreman would have.

Do you run puppetDB on your postgres cluster by any chance or are you using
a primary / standby with reads on standby for puppetdb or no puppetDB at
all?

thanks!
-byron

··· On Monday, December 8, 2014 3:14:29 AM UTC-6, Guy Meler wrote: > > Hey. I'm using it like that. > Foreman is talking to pgPool cluster, active active, and pgPool forward > queries to 6 PostgreSQL backends, streaming replication. > On 8 Dec 2014 04:23, "Byron Miller" <byr...@gmail.com > > wrote: > >> Anyone using the foreman with a PgPool-II Postgres cluster? or using log >> ship standby? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Foreman users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to foreman-user...@googlegroups.com . >> To post to this group, send email to forema...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/foreman-users. >> For more options, visit https://groups.google.com/d/optout. >> >
4

PuppetDB is on the same PostgreSQL cluster.

We have not encouter any issues with pgPool and foreman :slight_smile:

··· On 8 Dec 2014 16:09, "Byron Miller" wrote:

fantastic! have you ran into any issues or quirks? looks like latest
pgpool-II is pretty safe for most transactions foreman would have.

Do you run puppetDB on your postgres cluster by any chance or are you
using a primary / standby with reads on standby for puppetdb or no puppetDB
at all?

thanks!
-byron

On Monday, December 8, 2014 3:14:29 AM UTC-6, Guy Meler wrote:

Hey. I’m using it like that.
Foreman is talking to pgPool cluster, active active, and pgPool forward
queries to 6 PostgreSQL backends, streaming replication.
On 8 Dec 2014 04:23, “Byron Miller” byr...@gmail.com wrote:

Anyone using the foreman with a PgPool-II Postgres cluster? or using
log ship standby?

–
You received this message because you are subscribed to the Google
Groups “Foreman users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to foreman-user...@googlegroups.com.
To post to this group, send email to forema...@googlegroups.com.
Visit this group at http://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at http://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.