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.mil...@oracle.com> wrote: > Hey Eduardo > > On 15 Feb 2018, at 7:12 pm, Eduardo Capistrán <eduardo...@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@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
