--- On Thu, 10/7/10, Tatsuo Ishii <ishii@xxxxxxxxxxxxxx> wrote: > > The scenario I'm most interested in is this: > > > > 2 servers - a master and a hot standby. All writes are > sent to master, reads are split between master and hot > standby. > > > > 1) If the hot standby goes down, how do I redirect > reads to the master? > > pgpool-II 3.0 will take care of this. > > > 2) If the master fails > > -how do I automatically > promote the standby to master and send all reads/writes to > the new master? > > This is covered by pgpool-II 3.0 as well. > > > -what happens when the old > master comes back up? Do I need to so anything to make it > catches up to the new master? > > I recommend to use it a standby. Such a configuration is > possible by > using pgpool-II 3.0. > -- Oh so I'd still need a proxy such as pgpool-II for HA setup? I was thinking that with the new built-in replication in 9.0 there would be no need to use pgpool-II. If pgpool is still necessary why not also use it for replication? What would be the advantages of using the 9.0's built-in replication as opposed to pgpool's replication? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
