Re: Mirroring ENTIRE DATABASE. - Mailing list pgsql-admin

From Rajesh Kumar Mallah.
Subject Re: Mirroring ENTIRE DATABASE.
Date
Msg-id 200205301516.13707.mallah@trade-india.com
Whole thread Raw
In response to Mirroring ENTIRE DATABASE.  (Bhuvan A <bhuvansql@linuxfreemail.com>)
Responses Re: Mirroring ENTIRE DATABASE.  (Bhuvan A <bhuvansql@linuxfreemail.com>)
List pgsql-admin
Dear Bhuvan,

Advanceded replication features although important
are not currently available with postgresql.


Some solutions do exists like pgreplicator, usogres
rserv etc, but not sure of their status.

Also i would like to ask the list if there exists
some place where these are discussed,..


regds
Mallah.


On Wednesday 29 May 2002 12:54 pm, Bhuvan A wrote:
> Hi,
>
> How can we mirror an ENTIRE DATABASE? I have came across pgreplicator
> and it seems that it will mirror ONLY TABLES. Then how about views,
> functions, triggers, sequences, etc.(somebody correct me if wrong)
>
> So am i unable to mirror a ENTIRE DATABASE in postgres? Else shall i
> do this way on per day basis.
>
> $ pg_dump -h localhost dbname user | psql -h hostname dbname user
>
> Or is there any other better option than this one. Ofcourse i am
> planning to mirror within LAN. Expecting your valuable suggestions.
>
> regards,
> bhuvaneswaran.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.



pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Complex join query
Next
From: "Chad R. Larson"
Date:
Subject: Re: databases and RAID ...