Yes, I've seen that. Unfortunately, it doesn't give any suggestion on what to do about it. Extensive googling doesn't give any better explanation.
I have done some testing. When I connect to pgpool (port 9999) on one postgres host and create a table, I can go to the other host and connect to pgpool and the table is there. That is, as far as I know, the expected behavior for pgpool. -----Original Message----- From: x2go-user <x2go-user-boun...@lists.x2go.org> On Behalf Of Oleksandr Shneyder Sent: Friday, September 28, 2018 3:08 AM To: x2go-user@lists.x2go.org Subject: Re: [X2Go-User] X2go server and pgpool Hi David, it doesn't look like X2Go related issue to me. It seems that you have problems with your DB configuration. Check this: http://www.pgpool.net/mantisbt/view.php?id=126 best regards, Alex Am 25.09.2018 um 15:24 schrieb David Barron: > I'm trying to get x2go server running in a high availability > environment, which includes using pgpool for replication etc. > > > > I've got my /etc/x2go/x2gosql/sql file setup this way: > > > > backend=postgres > > host=<hostname> > > port=9999 > > > > When I try x2godbadmin -createdb I get a pgpool error I don't understand: > > > > DBI > connect('dbname=x2go_sessions;host=<hostname>;port=9999;sslmode=disabl > e','postgres',.) failed :ERROR: unable to read message kind > > DETAIL: kind does not match between master(53) slot[1] (45) at > /sbin/x2godbadmin line 530. > > Backend=postgres at /sbin/x2godbadmin line 530. > > > > When I connect with pgAdmin I can see that the x2godbuser has been > created and the x2go_sessions database has been created. > > > > If I try to connect to the database I get this error > > cid:image002.png@01D44F61.9E2EB470 > > > > > > If I change the port= to 5432 (the default postgresql port) the > command works fine. > > > > So, I guess my first question is, is this sort of setup supported? > > If so, is there any documentation or suggestions? > > > > Thanks in advance. > > > > > > > > /architects of vision and strategy for business intelligence/ > > *David Barron* > Senior Consultant > > Zencos Consulting: david.bar...@zencos.com > > > > www.zencos.com <http://www.zencos.com/> > > work: > > > > 919-480-2761 > > mobile: > > > > 919-995-2356 > > fax: > > > > 919-287-2335 > > The information in this e-mail and any attached files is confidential. > It is intended solely for the use of the addressee. Any unauthorized > disclosure or use is prohibited. If you are not the intended recipient > of the message, please notify the sender immediately and do not > disclose the contents to any other person, use it for any purpose, or > store or copy the information in any medium. The views of the author > may not necessarily reflect those of the company. > > > > > > > > _______________________________________________ > x2go-user mailing list > x2go-user@lists.x2go.org > https://lists.x2go.org/listinfo/x2go-user > -- ----------------------------------------------------------- Oleksandr Shneyder | Email: o.shney...@phoca-gmbh.de phoca GmbH | Tel. : 0911 - 14870374 0 Harzstr. 4 | Fax. : 0911 - 14870374 9 D-90491 Nürnberg | Mobil: 0163 - 49 64 461 Geschäftsführung: Dipl.-Inf. Oleksandr Shneyder Amtsgericht München | http://www.phoca-gmbh.de HRB 196 658 | http://www.x2go.org USt-IdNr.: DE281977973 ----------------------------------------------------------- _______________________________________________ x2go-user mailing list x2go-user@lists.x2go.org https://lists.x2go.org/listinfo/x2go-user
