[Pgpool-general] PgPool-II installation issues

[Tatsuo Ishii]

> Hi Tatsuo,
> 
> I am a developer for a company called BMK and am facing some teething
> problems with configuring PgPool-II.
> We have two database servers running postgres and I got them replicated
> using Slony. I now wish to get PgPool running ont eh slave so that all
> writes go to the master.
> 
> I set replication to false, master/slave to true and then provided the
> hostname, port and directory for both hosts.
> 
> I haven't created a systemDB and the weights for the master is 1 and that
> for the slave is 0.5.
> 
> When i startup PgPool, I can see the different processes running and the
> logfile seems to be ok.
> 
> But on issuing a update queryon the slave gives me an error instead of
> sending it to the master. Nothing is seen in the logs.
> 
> Is there something with my config file that I am missing out?

If you are sending queries directly to the slave PostgreSQL, then you
loose. You need to send all queries to pgpool-II.
--
Tatsuo Ishii
SRA OSS, Inc. Japan