Thread: Mirroring ENTIRE DATABASE.
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.
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.
Dear Rajesh Kumar Mallah, Thankx for your response and sorry for my late response. Here find the link for pgreplicator user discussion. http://sourceforge.net/forum/forum.php?forum_id=60248 I wasn't aware of usogres & rserv forums and would be better if someone point those links. regards, bhuvaneswaran. On May 30, Rajesh Kumar Mallah. wrote: > 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. >