> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
