PostgreSQL HA questions
От | Dragan Zubac |
---|---|
Тема | PostgreSQL HA questions |
Дата | |
Msg-id | 904911fb0609261339i719455afh46ec4c42694fb4c@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL HA questions
|
Список | pgsql-hackers |
Hello<br /><br /> We're looking for HA PostgreSQL solution,so have a couple of questions:<br /><br /> 1. Is it possible formultiply PostgreSQL instances (engines,cores) to use same DATA space? For example,to have two PostgreSQL processes whichwill use same data directory,same files,and same data ? So,if You update some data in some table over postmaster1,theprocess which uses connection to postmaster2 will 'see' the exact same data in the same table ?<br /><br />2. Becouse of vaccuming issues,is it possible to create such a client process which will use two identical tables,and onreceiving a signal,it will switch between those tables.For example,first a client application uses table1,after some time,senda signal to process,it will switch using table2,so You can freely vacuum table1 or whatsoever.After vacuuming done,table1 will sinchronize with table2 and keep up-to-date until You send next signal to application,which will switchusing table1,so You can vacuum table2.<br /><br /> If any one has any ideas,thoughts ?<br /><br /> Sincerely<br /><br/> Dragan<br />
В списке pgsql-hackers по дате отправления: