[pgpool-general: 2882] Re: Pgpool on application servers

[Yugo Nagata]

Hi,

On Thu, 22 May 2014 15:25:49 +1200
Juergen Brendel <juergen at brendel.com> wrote:

> 
> Hello!
> 
> On Thu, 2014-05-22 at 13:01 +1000, James Sewell wrote:
> > It is! 
> > 
> > 
> > Thanks for that, it seems all is well.
> 
> 
> If I setup a postgres cluster with the native streaming replication, how
> should I go about configuring the two pgpool instances so that watchdog
> is used? I just need pgpool for the failover here...

The tutorial would be helpful for you.
http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html

> 
> Any ideas would be greatly appreciated.
> 
> Juergen
> 
> 
> 
> 
> > 
> > James Sewell 
> > 
> > On Thursday, 22 May 2014, Juergen Brendel <juergen at brendel.com> wrote:
> >         
> >         Hello James,
> >         
> >         
> >         On Thu, 2014-05-22 at 09:36 +1000, James Sewell wrote:
> >         
> >         > Is it possible to install Pgpool on application servers
> >         directly?
> >         > In this case more than one Pgpool would be servicing client
> >         requests
> >         > balanced across two or more servers. Would this cause
> >         problems?
> >         
> >         I just asked almost exactly the same thing yesterday. Here's
> >         the thread
> >         so far:
> >         
> >         http://www.sraoss.jp/pipermail/pgpool-general/2014-May/002900.html
> >         
> >         
> >         Maybe the response there is helpful?
> >         
> >         Juergen
> >         
> >         
> >         
> > 
> > 
> > -- 
> > 
> > James Sewell,
> > PostgreSQL Team Lead / Solutions Architect 
> > ______________________________________
> >  
> > 
> > Level 2, 50 Queen St, Melbourne VIC 3000
> > 
> > P (+61) 3 8370 8000  W www.lisasoft.com  F (+61) 3 8370 8099
> >  
> > 
> > 
> > 
> > 
> > 
> > ______________________________________________________________________
> > The contents of this email are confidential and may be subject to
> > legal or professional privilege and copyright. No representation is
> > made that this email is free of viruses or other defects. If you have
> > received this communication in error, you may not copy or distribute
> > any part of it or otherwise disclose its contents to anyone. Please
> > advise the sender of your incorrect receipt of this correspondence.
> 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Yugo Nagata <nagata at sraoss.co.jp>