2

I'm using one pgpool server and 2 RDS servers in load-balance master-slave mode. It's all going well but I have this one problem i can't find a solution. I have one query that does only SELECTs with a some joins and etc. However, when I execute this query and then look in pgpool log, it prints the message : " Unable to parse the query:". The query then is executed in the backend 0 (master) with no problem. Thing is, This is a heavy query and i want it to be balanced as well.

The query has : "INNER JOIN; INNER JOIN LATERAL; COUNT(); GROUP BY; COALESCE(); MAX(); EXTRACT(); EPOCH(); NOW()"

Searching I did only find questions, but no solution at all. Hope any of you guys can help me. Thanks

Guilherme Rodriguez
  • 184
  • 1
  • 12

1 Answers1

2

By taking a look at the LATERAL JOIN (Table Expressions). It's only available after Postgresql 9.3. So maybe you're using an older pgpool version. That's why pgpool can't parse your query.

Igor Montella
  • 100
  • 1
  • 6