Thread: how can I mirror a postgres database

Hi all,

    I am having postgres6.5 installed on a remote
linux server. Now i have installed the same scenario
in a local machine. Now i want to update my local
machine with any transaction or changes made in remote
machine. something like a oracle parallel server.
where if one machine breaks down due to some reason
the other machine can take over as it has all the data
with it.

  I want to move my complete database with critical
data on to postgres. can anybody please suggest how do
i do it as the server is a mission critical server.

  any suggestions are appreciated and thanks for all
of the suggestions in advance.

Thanks & Regards
Rajesh.

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

7.1 will have replication curtesy of PostgreSQL Inc:
http://www.pgsql.com/press/Pgsql_Inc_Press-5.pdf

(it is being freely donated to the source tree, according to their statement)




----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/