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
