| From: | "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br> |
|---|---|
| To: | Tulio <tulio(at)informidia(dot)com(dot)br> |
| Cc: | GMAIL <federico(dot)serale(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: allow servers to access to the same data |
| Date: | 2012-10-17 17:53:31 |
| Message-ID: | 507EF09B.6090105@mandic.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tulio wrote:
> You can use a stream replication in hot standby (native) to have the
> same data and access in both (but not update and insert in the slave,
> just select)
> and create a virtual IP using heartbeat.. configuring a master to use
> some IP (virtual) and when this lost the IP, the second server (slave)
> will be use this IP..
> and will allow update and insert...
>
> is it that you want?
I've come across a few mentions of Heartbeat being used for PostgreSQL
failover, do have any links to more information about this?
> Em 17/10/2012 10:20, GMAIL escreveu:
>> it's possible to access the same data from two different servers. the
>> two servers have the same IP and not run simultaneously
Thanks in advance,
Daniel Serodio
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-10-17 17:59:44 | Re: problem with distinct not distincting... |
| Previous Message | Daniel Serodio (lists) | 2012-10-17 17:09:38 | Re: database corruption questions |