[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] DB Synchronization.
From:       "Shoaib Mir" <shoaibmir () gmail ! com>
Date:       2006-08-26 15:15:00
Message-ID: bf54be870608260815y7802b1f9o253bf40dc8aa5c03 () mail ! gmail ! com
[Download RAW message or body]

You can use Slony (
http://gborg.postgresql.org/project/slony1/projdisplay.php) for replication
(data synchronization) and it also does offer the failover (not automatic)
feature as well.

You can also have a combination of Linux HA + Slony for high availablity.

-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 8/26/06, nilesh khode <nilesh_khode@yahoo.com> wrote:
>
> Hello All,
>
> I am having Postgresql 8 installed on 2 RH Linux box.
> I am keeping one server in stand-by mode. If one server is failed for any
> reason, the DB should be serving from another server.
>
> I am having one question about the synchronization.
> How to keep another server in updated mode?
> It should takes an updated db from first server and restore it on another
> server.
>
> Please help me out.
>
> Regards,
> Nilesh
>

[Attachment #3 (text/html)]

You can use Slony (<a \
href="http://gborg.postgresql.org/project/slony1/projdisplay.php">http://gborg.postgresql.org/project/slony1/projdisplay.php</a>) \
for replication (data synchronization) and it also does offer the failover (not \
automatic) feature as well.  <br><br>You can also have a combination of Linux HA + \
Slony for high availablity.<br><br>-- <br>Shoaib Mir<br>EnterpriseDB (<a \
href="http://www.enterprisedb.com">www.enterprisedb.com</a>)<br><br><br><div><span \
class="gmail_quote"> On 8/26/06, <b class="gmail_sendername">nilesh khode</b> &lt;<a \
href="mailto:nilesh_khode@yahoo.com">nilesh_khode@yahoo.com</a>&gt; \
wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, \
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div><div><div \
style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div>

<p>Hello All,<br>
<br>
I am having Postgresql 8 installed on 2 RH Linux box.<br>
I am keeping one server in stand-by mode. If one server is failed for any
reason, the DB should be serving from another server. <br>
<br>
I am having one question about the synchronization.<br>
How to keep another server in updated mode? <br>
It should takes an updated db from first server and restore it on another
server.<br><br>
Please help me out.<br>
<br>
Regards,<br>
Nilesh<span style="font-size: 10pt; font-family: Arial;"></span></p>

</div></div></div>
</div></blockquote></div><br><br clear="all"><br><br>



[prev in list] [next in list] [prev in thread] [next in thread]