<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">I am really stuck with this issue, where Pgpool oftens errors out with "Connection is Broken" message with logs which states "geom" column does not exist on one Postgresql server. I did verified this that this holds true on one postgresql server that it did not have geom and geom_low columns.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px;
color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Here is my set-up.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Two postgresql boxes on separate boxes</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">One Pgpool box pointing to above mentioned postgresql boxes.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style:
normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">I am attaching my logs for your references--</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Here is the sequence of queries that gets fired :</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div><div style="background-color: transparent;"><font face="times new roman, new york, times, serif">SET CLIENT_ENCODING TO UTF8;SET STANDARD_CONFORMING_STRINGS TO ON;BEGIN; create table
public._1ebac66315f34b00a9fcfd0b19bfad69 ( gid serial PRIMARY KEY, SRA varchar(3),INCORP varchar(1),HAZ_CODE int,HAZ_CLASS varchar(25),VH_REC varchar(25),Shape_Leng double precision,Shape_Area double precision ) ;</font><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'Times New Roman'; font-style: normal;"><font face="times new roman, new york, times, serif"><br></font></div><div style="background-color: transparent;"><font face="times new roman, new york, times, serif">SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom','3857','MULTIPOLYGON',2); <br></font></div><div style="background-color: transparent;"><font face="times new roman, new york, times, serif">SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom_low','3857','MULTIPOLYGON',2);<br></font></div><div style="background-color: transparent;
color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><font face="times new roman, new york, times, serif"><br></font></div><div style="background-color: transparent;"><font face="times new roman, new york, times, serif">insert into _1ebac66315f34b00a9fcfd0b19bfad69 ( SRA,HAZ_CODE,HAZ_CLASS,Shape_Leng,Shape_Area,geom) values ( 'FRA',2,'High',3.63920547962e+003,1.47780526502e+005,
ST_GeomFromWKB(st_multi(decode('AQMAAAABAAAAHwAAAKWSCbtw62jB4EhufEg7TkGVAj2cXOtowcWr/AFHO05BLlKxzVvraMFzC4X0RjtOQaEpMD9662jB1UPX3QM6TkEDlBzQoutowX55VodcOE5BxK3ftKLraME/tVvzazhOQVn3UPyh62jBff7ZcdQ4TkG27El5putowTKMIfLUOE5BPyhnWabraMHmf0oA5zhOQc0rYdaq62jBvTuOgOc4TkEreJ2WqutowRhv6pwLOU5B5YmZE6/raMEdjSodDDlOQVyd19Ou62jBcFiUOTA5TkEJy85ExetowfydmroyOU5BfaUWBcXraMGIoRPXVjlOQW0MF4LJ62jBEmw8V1c5TkFYPXp9yetowXzUgfRZOU5Bv6yoVsnraMHMCgL1bzlOQdrjsPqM62jBoRGC6G45TkHX8ixRjOtowR6SZpMCOk5BHNWuTYzraMFVkPrjAzpOQT++MEqM62jBRaGKNAU6TkE9afhsietowTS2m+IEOk5ByktnzYjraME2nJsqXzpOQX/JkVqL62jBOh+hc186TkGMLuHPiutowSA6Cq+TOk5BmxXnl23raME/sqL7kTpOQSpg4WRt62jBho7wdNI6TkGBi+n6bOtowROfMokSO05B7ldWGnHraMFYnjqaEjtOQaWSCbtw62jB4EhufEg7TkEAAAAA','base64')),3857));<br></font></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><br></div><div style="background-color: transparent;
color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">Any help will be greatly appreciated....</div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">Thank you in advance,</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div></div></body></html>