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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
