| Lists: | Postg스포츠 토토 사이트SQL |
|---|
| From: | Rajiv Dhawan <rajivengineer(at)gmail(dot)com> |
|---|---|
| To: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | Postgres Cluster |
| Date: | 2011-02-04 10:42:36 |
| Message-ID: | AANLkTikn_BKkV8Zo2L2YVTXgsAaXCxQA3rK6M8cLLsCF@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
Hi all,
Does Postgres supports Clustering like Oracle RAC in Active/Passive Mode.e.q
2 systems with Linux installed and PostgresDB on SAN ?
Would appreciate your response on this.
Best Regards
RAJIV DHAWAN
| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Rajiv Dhawan <rajivengineer(at)gmail(dot)com> |
| Cc: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | Re: Postgres Cluster |
| Date: | 2011-02-04 10:55:35 |
| Message-ID: | AANLkTimPk4VaE3rB97s1Hj0v66q+rtk43-TLxfxS=w-N@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
On Fri, Feb 4, 2011 at 4:12 PM, Rajiv Dhawan <rajivengineer(at)gmail(dot)com> wrote:
> Hi all,
>
> Does Postgres supports Clustering like Oracle RAC in Active/Passive Mode.e.q
> 2 systems with Linux installed and PostgresDB on SAN ?
>
Postgres does not natively support Oracle RAC kind of setup. There is
something known an Hot Standby which supports read-write access on one
system and read-only access to a replicated system. But the database
is not shared between these nodes, rather is replicated using
techniques such as streaming replication.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
| From: | Deepak <mail(dot)dktyagi(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | Rajiv Dhawan <rajivengineer(at)gmail(dot)com>, pgsql-in-general(at)postgresql(dot)org |
| Subject: | Re: Postgres Cluster |
| Date: | 2011-02-05 12:52:33 |
| Message-ID: | AANLkTi==oornmeLz-V8TgurfTqg0eW00FD_EhddTsfUE@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg스포츠 토토 사이트SQL |
Hi Rajiv, postgres does not support Active-Active approach but through
redhat/sun clustering u can achieve Active-Passive functionality.
Regd,
Deepak Tyagi
On 2/4/11, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> wrote:
> On Fri, Feb 4, 2011 at 4:12 PM, Rajiv Dhawan <rajivengineer(at)gmail(dot)com>
> wrote:
>> Hi all,
>>
>> Does Postgres supports Clustering like Oracle RAC in Active/Passive
>> Mode.e.q
>> 2 systems with Linux installed and PostgresDB on SAN ?
>>
>
> Postgres does not natively support Oracle RAC kind of setup. There is
> something known an Hot Standby which supports read-write access on one
> system and read-only access to a replicated system. But the database
> is not shared between these nodes, rather is replicated using
> techniques such as streaming replication.
>
> Thanks,
> Pavan
>
> --
> Pavan Deolasee
> EnterpriseDB http://www.enterprisedb.com
>
> --
> Sent via pgsql-in-general mailing list (pgsql-in-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-in-general
>