Re: How to use pgbouncer
От | Andreas Kretschmer |
---|---|
Тема | Re: How to use pgbouncer |
Дата | |
Msg-id | 20101222190106.GA29060@tux обсуждение исходный текст |
Ответ на | Re: How to use pgbouncer (Filip Rembiałkowski <filip.rembialkowski@gmail.com>) |
Список | pgsql-general |
Filip Rembiałkowski <filip.rembialkowski@gmail.com> wrote: > 2010/12/21 Andreas Kretschmer <akretschmer@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 :-) 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°
В списке pgsql-general по дате отправления: