[Linux-cluster] postgres cluster without shared storage

[Carlos Maiolino]

On Tue, Jun 29, 2010 at 02:26:56PM +0200, ESGLinux wrote:
> Hi all, 
> 
> I need to mount a two nodes cluster with postgres as service. I have mounted it
> in the past but with a shared storage and using GFS but now I don t have this
> element. 
> 
> The idea is to have a master node with all the data in its own disk and have a
> mechanism to replicate this data to the slave node in its own disk. If the
> master goes down the slave begin to give the service and the flow of data will
> go from this node to the other one. (the slave node becomes the master one)
> 
> Is it possible to do something like this?
> 
> Thanks in advance, 
> 
> ESG

> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster

Hi,

I'm not completely aware of postgres, but it should have its own replication system. I know MySQL has (at least I already built a master/slave database with mySQL, which does replication via network).

the only thing I think you should take care is if the slave postgres will be read/write too. In case of MySQL, iirc, it should has a read-only slave.

-- 
---

Best Regards

Carlos Eduardo Maiolino