Re: Mirroring ENTIRE DATABASE.

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.