Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Martijn van OosterhoutDate: 2006-09-26 20:40:18
Subject: Re: Faster StrNCpy
Previous:From: Tom LaneDate: 2006-09-26 20:24:51
Subject: Faster StrNCpy

pgsql-general by date

Next:From: Robert TreatDate: 2006-09-27 02:54:08
Subject: Re: pl/perl autonomous transactions question
Previous:From: Asok ChattopadhyayDate: 2006-09-26 19:26:14
Subject: Transaction is read-only in auto commit mode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group