Re: Reading a live database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reading a live database
Date: 2002-09-14 22:53:15
Message-ID: 24544.1032043995@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"D'Arcy J.M. Cain" <darcy(at)druid(dot)net> writes:
> 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 odds of this are nil, unless maybe *all* the servers treat the
database as read-only, which doesn't seem very interesting.

> 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?

There are binary incompatibilities if the platforms have differences in
endianness, alignment, or floating-point formats.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2002-09-15 02:42:52 Re: Reading a live database
Previous Message Avishay Orpaz 2002-09-14 22:50:28 Problem with psql on Win32