From: | "Dragan Zubac" <zubacdragan(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PostgreSQL HA questions |
Date: | 2006-09-26 20:39:18 |
Message-ID: | 904911fb0609261339i719455afh46ec4c42694fb4c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2006-09-27 02:54:08 | Re: pl/perl autonomous transactions question |
Previous Message | Asok Chattopadhyay | 2006-09-26 19:26:14 | Transaction is read-only in auto commit mode |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-09-26 20:40:18 | Re: Faster StrNCpy |
Previous Message | Tom Lane | 2006-09-26 20:24:51 | Faster StrNCpy |