[Pgpool-general] PgAdmin and pgpool-II

Glyn Astill glynastill at yahoo.co.uk
Wed Jan 14 15:36:39 UTC 2009


This sound's like the same issue I saw when I tried to use pgpool-II across our slony nodes, I tested to see if I could send a query using pgadmin and got a similar error.

Since then I've only used it as a connection pool to our main server.



----- Original Message ----
> From: Iñigo Martinez Lasala <imartinez at vectorsf.com>
> To: Łukasz Jagiełło <lukasz.jagiello at gforces.pl>
> Cc: pgpool-general at pgfoundry.org
> Sent: Wednesday, 14 January, 2009 15:11:39
> Subject: Re: [Pgpool-general] PgAdmin and pgpool-II
> 
> And there is no solution...
> I'm gonna perform a full-resync between both nodes and we will see if 
> problem remains.
> 
> > -----Mensaje original-----
> > De: Łukasz Jagiełło [mailto:lukasz.jagiello at gforces.pl]
> > Enviado el: miércoles, 14 de enero de 2009 16:09
> > Para: Iñigo Martinez Lasala
> > CC: pgpool-general at pgfoundry.org
> > Asunto: Re: [Pgpool-general] PgAdmin and pgpool-II
> >
> > 2009/1/14 Iñigo Martinez Lasala :
> > > Hi everybody.
> > >
> > > We are testing pgpool-II 2.1 with postgres 8.2.11 in order
> > to increase
> > > our database server capacity for an on-line store. Most of database
> > > load are read-only SELECTs.
> > >
> > > Our preliminary tests show that pgpool-II is working fine.
> > However we
> > > have detected a problem when using PgAdmin-III as admin/query tool.
> > > When we open PgAdmin-III, it shows a "mismatch" database error and
> > > secondary node disconnects from pgpool.
> >
> > http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg00319.html
> >
> > Guess it's same problem.
> >
> > --
> > Łukasz Jagiełło
> > G-Forces Web Management Polska
> >
> > T: +44 (0) 845 055 9040
> > F: +44 (0) 845 055 9038
> > E: lukasz.jagiello at gforces.pl
> > W: www.gforces.co.uk
> >
> > This e-mail is confidential and intended solely for the use
> > of the individual to whom it is addressed. If you are not the
> > intended recipient, please notify the sender immediately. Do
> > not disclose the contents of this e-mail to any other person,
> > use it for any purpose, print, copy, store, or distribute it.
> > This e-mail should then be destroyed. Any views expressed in
> > this message are those of the individual sender except where
> > the sender specifically states them to be the views of
> > G-Forces Web Management Ltd. Registered Office: 4 & 5 Kings
> > Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
> > Company No. 3863609. VAT Registration No. 7250 384 50
> >
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general



      


More information about the Pgpool-general mailing list