[pgpool-general: 6674] Re: Pgpool connection

[Bo Peng]

Hi,

On Sat, 27 Jul 2019 16:05:53 +0530
Lakshmi Raghavendra <lakshmiym108 at gmail.com> wrote:

>      Am trying to use pgpool for my production setup.
> Am running a streaming replication mode pgpool with watchdog. Attached is
> my pgpool.conf file. I have an application , where in  for the database
> connection string am using the delegateIP and pgpool user and pgpool
> password.
> 
> The application actually wants to connect to 'saas' database, 'saas'
> schema, as horizon user having a different password.
> 
> Could you please let me know what configuration changes need to be done in
> pgpool.conf,so tht the delegateIP gets the db requests and it passes on to
> the actual postgres master for any read/write transactions.

Sorry for late response.

Do you want to send all read/write queris only to primary postgres?

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan