2010/12/21 Andreas Kretschmer <akretsch...@spamfence.net>: > > 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 :-) 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 greets, Filip -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
