Re: PgPool-II installation issues

Are you sure that you are sending queries to pgpool-II, not
to PostgreSQL?

To make it clear, can you please show me pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Doesn't Pgpool reside on the slave? will it not detect the queries?
> 
> On Feb 11, 2008 11:10 PM, Tatsuo Ishii 
> <ishii-r5vX20e9KLfqq2nvvmkE/A@xxxxxxxxxxxxxxxx> wrote:
> 
> > > 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