Hello, On Fri, 19 Aug 2011 18:11:52 +0200 Olivier NOEL <[email protected]> wrote:
> Hello, > > new problem : > > 2011-08-19 17:52:03 LOG: pid 8968: find_primary_node: > pgpool_walrecrunning does not exist > > 2011-08-19 18:01:25 LOG: pid 8990: pool_send_and_wait: Error or > notice message from backend: : DB node id: 1 backend pid: 10280 > statement: message: cannot execute UPDATE in a read-only transaction > > Pgpool seems to send the DML queries to all the backends, instead of > just the master. Is it normal ? Same config file as above. It seems that you failed in installation of pgpool_walrecrunning(). pgpool_walrecrunning() is the function that is necessary to recognize a primary node in pgpool-II 3.0.x. You have to execute install-functions.sh again. install-functions.sh can download from tutorial page. -- Toshihiro Kitagawa SRA OSS, Inc. Japan > I followed this tutorial : > http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html > > Olivier > > 2011/8/17 Olivier NOEL <[email protected]>: > > 2011/8/17 Tatsuo Ishii <[email protected]>: > >> Are you able to connect to pgpool-II using psql? > > > > Yes I was able to connect to pgpool, but with the error and no queries > > was sent to the servers, pgpool crashed after the error. > > > > I moved back to the fresh snapshot I made after installing the OS and > > postgresql server (The servers are on VMware VMs), and I don't have > > the error anymore, only the ssl part : SSL requested but SSL support > > is not available. > > > > I am able to connect to pgpool and all queries are sent to the > > servers, but I still don't know where the error came from. > > > > Olivier. > > > >> -- > >> Tatsuo Ishii > >> SRA OSS, Inc. Japan > >> English: http://www.sraoss.co.jp/index_en.php > >> Japanese: http://www.sraoss.co.jp > >> > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
