EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Postgres can also work as a multi instance database like Oracle RAC  XML

Forum Index » GridSQL - Developers
Author Message
mostalika

New member

Joined: 17 May 2011 12:58:22
Messages: 1
Offline

Hi Folks,

I would like to know can Postgres supports migration of Oracle RAC mutli instance database to Postgres.
Is there any multi instance database feature supported by Postgres similar to Oracle RAC database, it is
different from Single instance database.

Thanks
-Ravi
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

No. PostgreSQL does't have multiple Instance Single Database Concept.

However, you can try following solutions:
1. Streaming Replication and Load Balancing of SELECT using pgpool.
2. Slony Replication + Load Balancing of SELECT using pgpool.
3. Multi-Master Replication using Bucardo and Load Balancing of DML.
4. From PG 9.1, PostgreSQL would be having Synchronous Replication. So, you can use Replication + Load Balancing.

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
 
Forum Index » GridSQL - Developers
Go to:   
Powered by JForum 2.1.8 © JForum Team