Hello
We're looking for HA PostgreSQL solution,so have a couple of questions:
1. Is it possible for multiply PostgreSQL instances (engines,cores) to
use same DATA space? For example,to have two PostgreSQL processes which
will use same data directory,same files,and same data ? So,if You
update some data in some table over postmaster1,the process which uses
connection to postmaster2 will 'see' the exact same data in the same
table ?
2. Becouse of vaccuming issues,is it possible to create such a client
process which will use two identical tables,and on receiving a
signal,it will switch between those tables.For example,first a client
application uses table1,after some time,send a signal to process,it
will switch using table2,so You can freely vacuum table1 or
whatsoever.After vacuuming done,table 1 will sinchronize with table2
and keep up-to-date until You send next signal to application,which
will switch using table1,so You can vacuum table2.
If any one has any ideas,thoughts ?
Sincerely
Dragan
- [HACKERS] PostgreSQL HA questions Dragan Zubac
- Re: [HACKERS] PostgreSQL HA questions Andrew Sullivan
- Re: [HACKERS] PostgreSQL HA questions Chris Browne