| From: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org |
| Subject: | Mirroring the database? |
| Date: | 2001-08-06 17:35:01 |
| Message-ID: | 3B6ED545.4C1F96BE@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando Benites | 2001-08-06 17:37:14 | tables in tables |
| Previous Message | Andrew Gould | 2001-08-06 16:42:37 | Would a PostgreSQL database on a DVD be usable? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kristopher Yates | 2001-08-06 19:05:56 | prob with PERL/Postgres |
| Previous Message | Tom Lane | 2001-08-06 15:33:36 | Re: Re: Data type confusion |