Hi chandang,
Connect the application or your script to the pgpool port, after which you will be able to utilize the pgpool connections. However, you will have to tune the database parameters in such a way that they do not contradict.
Below is the document for pgpool details :
http://www.pgpool.net/mediawiki/index.php/Main_Page
Hope this helps. Let us know in case you have any other issues.
Hi chandang,
Does your script connect to pgpool port or to the database port directly?
The reason I am asking this is you have mentioned a tag "pgpool", further investigation depends on this data.
Hi chandang,
Connect the application or your script to the pgpool port, after which you will be able to utilize the pgpool connections. However, you will have to tune the database parameters in such a way that they do not contradict.
Below is the document for pgpool details :
http://www.pgpool.net/mediawiki/index.php/Main_Page
Hope this helps. Let us know in case you have any other issues.