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 <[email protected]> > To: Łukasz Jagiełło <[email protected]> > Cc: [email protected] > 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:[email protected]] > > Enviado el: miércoles, 14 de enero de 2009 16:09 > > Para: Iñigo Martinez Lasala > > CC: [email protected] > > 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/[email protected]/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: [email protected] > > 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
