Re: How to use pgbouncer

Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> wrote:

> 2010/12/21 Andreas Kretschmer <akretschmer(at)spamfence(dot)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°