PostgreSQL HA questions

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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