| From: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
|---|---|
| To: | PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Reading a live database |
| Date: | 2002-09-14 22:39:49 |
| Message-ID: | 20020914223950.656ED1C67@druid.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wonder how hard it would be to run a database server against a database
that is already being run. The idea is to be able to do read only queries
against the database from a different server on a shared NFS mounted
database. The second server would need to be able to start in a mode that
ignored the lock and only allowed queries that read the database. This would
allow many intensive report queries against a busy transaction database.
Possible? Possible with a little work? A lot of work?
Another question, can a database server for one system (e.g. NetBSD on i386)
run a database originally created on another (e.g. AIX on RS6000) or are
there binary incompatibilities?
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paesold | 2002-09-14 22:45:24 | Re: Indexes and differing column types |
| Previous Message | Michael Paesold | 2002-09-14 22:25:56 | Indexes and differing column types |