Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Craig Ringer
Please reply to the mailing list, not directly to me. Reply follows below. On 10/17/2012 10:46 PM, GMAIL wrote: i want that the main pc save two identical databases, the first database will be saved on local hard drive and the second database will be saved on a nas. if the main pc has a failov

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Daniel Serodio (lists)
Shaun Thomas wrote: On 10/17/2012 12:53 PM, Daniel Serodio (lists) wrote: I've come across a few mentions of Heartbeat being used for PostgreSQL failover, do have any links to more information about this? This was the subject of my talk at PG Open this year. I've got the entire PDF of slides

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Shaun Thomas
On 10/17/2012 12:53 PM, Daniel Serodio (lists) wrote: I've come across a few mentions of Heartbeat being used for PostgreSQL failover, do have any links to more information about this? This was the subject of my talk at PG Open this year. I've got the entire PDF of slides, liner notes, and in

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Alan Hodgson
> 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? If you're going to use Heartbeat on a 2-server setup, you should use DRBD for the replication, not the PostgreSQL replication. DRBD basical

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Tulio
Sorry Daniel, but I don't have.. and I was needing test this I was searching other tutorial... and was configuring ans testing.. are you brazilian.. not? read this.. http://www.hardware.com.br/tutoriais/drbd-heartbeat-samba/pagina2.html can be usefull for you..

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Daniel Serodio (lists)
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 serv

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Tulio
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

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Craig Ringer
On 17/10/2012 9:20 PM, GMAIL wrote: it's possible to access the same data from two different servers. the two servers have the same IP and not run simultaneously On shared storage? Yes, but it's a bad idea, because if they're ever both started at the same time the data will be critically corru

[GENERAL] allow servers to access to the same data

2012-10-17 Thread GMAIL
it's possible to access the same data from two different servers. the two servers have the same IP and not run simultaneously -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general