[Spacewalk-list] [External] Spacewak 2.7 and PgPool-II integration problems

[Paul Robert Marino]

well I've done this before and sadly you are going down a rabbit hole with
no benefits.
I'm not sure why you are getting that specific error because you haven't
provided sufficient information to debug it but you shouldn't bother.
there are a few architectural points that make that solution not work in
this case
first is how PGpool determine which queries go to the master and which get
load balanced. anything done in a transaction is assumed to write and
anything not in a transaction is assumed to be read only, this assumption
makes PGPool incompatible with JDBC because JDBC wrapps every thing in a
transaction so all queries will go to the master.
Second its recommended you use different users for read and write queries
but spacewalk doesn't support this.
third PGPool recommends you have 3 servers not 2 because then it can auto
recover with no down time.

in your senario what i recommend is using something like keepalived with a
monitoring script a vip and a master and slave notify script and simply use
PostgreSQL's native hotmode replication.


On Thu, Feb 15, 2018 at 12:17 PM, Avi Miller <avi.miller at oracle.com> wrote:

> Hey Eduardo
>
> On 15 Feb 2018, at 7:12 pm, Eduardo Capistrán <eduardocap at herbalife.com>
> wrote:
>
> Thanks for your reply Avi,
>
> We have installed spacewalk 2.7 in Oracle Linux using the embedded
> postgresql method without problem since version 1.9.
>
>
> That's good to know.
>
> We are now trying to move to a HA architecture and we are facing these
> kind of problems.
> Any success case you know making usage of porsgres cluster with pgpool-II ?
>
>
> To be honest, we don't test (or support) PostgreSQL or pgpool. We do test
> and support Spacewalk with Oracle Database RAC, but I guess that's not an
> option here. :)
>
> I would suggest perhaps providing the configuration steps you followed
> exactly in mode detail so that any PostgreSQL/pgpool experts can chime in,
> because the  original email didn't have much detail on how you configured
> Spacewalk during installation.
>
> Cheers,
> Avi
>
> --
> Oracle <http://www.oracle.com>
> Avi Miller | Product Management Director | +61 (3) 8616 3496
> <+61%203%208616%203496>
> Oracle Linux and Virtualization
> 417 St Kilda Road, Melbourne, Victoria 3004 Australia
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180215/485ffcb7/attachment.htm>