Postgres Pro
Downloads
Home   >   mailing lists

Thread: Links to Replication

Links to Replication

From
Adarsh Sharma
Date:
Dear all,

I am using PostgresPlus-8.4SS version of Postgres on Linux & Windows
Systems.
Now I need to enable replication of two servers. OS may be same or
different.

Please let me know any useful links to do that.


Thanks

Re: Links to Replication

From
Shoaib Mir
Date:
On Thu, Aug 25, 2011 at 2:03 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
Dear all,

I am using PostgresPlus-8.4SS version of Postgres on Linux & Windows Systems.
Now I need to enable replication of two servers. OS may be same or different.

Please let me know any useful links to do that.

I am not really sure what PostgresPlus-8.4SS is? but if you were using PostgreSQL 8.4 then Slony (http://slony.info/) can be a good option, otherwise upgrade to 9.0 and go with streaming replication which out-of-box.

cheers,
Shoaib

Re: Links to Replication

From
tuanhoanganh
Date:
You can use SymmetricDS to replicate on PostgreSQL, Oracle, SQL Server database.


On Thu, Aug 25, 2011 at 11:07 AM, Shoaib Mir <shoaibmir@gmail.com> wrote:
On Thu, Aug 25, 2011 at 2:03 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
Dear all,

I am using PostgresPlus-8.4SS version of Postgres on Linux & Windows Systems.
Now I need to enable replication of two servers. OS may be same or different.

Please let me know any useful links to do that.

I am not really sure what PostgresPlus-8.4SS is? but if you were using PostgreSQL 8.4 then Slony (http://slony.info/) can be a good option, otherwise upgrade to 9.0 and go with streaming replication which out-of-box.

cheers,
Shoaib