Search Postgresql Archives

Re: How to use pgbouncer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux