Thread: Mirroring Possible

Mirroring Possible

From
Michael Yeung
Date:
Dear all,

I have installed Postgres in one of the servers on our site and just called it the "Primary Database Server'.

Now, for the back-up purpose, we may want to install Postgres in one of the other servers on site acting as an mirror
ofthe "Primary" one. That means whatever modifications made on the primary will do the same on the mirror database
server.Is Postgresql capable of doing that ? If it is , How ? 

Thanks for your attention and any suggestion is highly appreciated.

Cheers,
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
| Michael Yeung                 |
| Alpha Network Shop            |
| Tel:(02)9413-3886        Fax:(02)9413-3617    |
| Mobile:0411-233-597            |
| mailto:michaely@alphanet.net.au        |
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/


Re: [GENERAL] Mirroring Possible

From
The Hermit Hacker
Date:
On Mon, 27 Jul 1998, Michael Yeung wrote:

> Dear all,
>
> I have installed Postgres in one of the servers on our site and just
> called it the "Primary Database Server'.
>
> Now, for the back-up purpose, we may want to install Postgres in one of
> the other servers on site acting as an mirror of the "Primary" one. That
> means whatever modifications made on the primary will do the same on the
> mirror database server. Is Postgresql capable of doing that ? If it is ,
> How ?

    Someone had written a few scripts for doing this, but I never
heard anything further on it.  There is currently no "internal" way of
doing this though...