Filip RembiaÅkowski <filip.rembialkowski@xxxxxxxxx> wrote: > 2010/12/21 Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx>: > > > > I'm looking for a solution to split read and write access to different > > servers (streaming replication, you know ...). Can i do that with > > pgpool? (setting backend_weightX=0 or 1)? I have read the doc, but i'm > > not sure if pgpool the right solution, maybe you can enlighten me? > > (or someone else ...) > > did you see http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#master_slave_mode > ? I think it answers your question :-) Now, yes ;-) Thx. > > warning: > it works by detecting which queries are read-only, which does not > always work "out of the box". > you will sometimes have to modify driver settings or worse, modify SQL > queries including "hints" for pgpool. > > see: > http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#restriction > http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#white_function_list > http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#black_function_list Thank you. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082Â, E 13.56889Â -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general