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.