Does the latest PostgreSQL 7.1.2 support database mirroring?
I have machine A, B and C, they all have the same database and tables.
Machine A is the operational machine, machine B and C are backup.
If users do INSERT, UPDATE and DELETE in machine A, I want have the
same SQL statements in machine B and C.
1. I can do pg_dump or COPY every hour.
2. I can use PerlDBI or JDBC open multiple connections for each SQL statement.
3. But I prefer if the system auto mirroring the database, then I can do
nothing. All I need is set the auto mirroring configure.
Please tell me how to do in 3. above. Thank you in advance!