Re: Reading a live database - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reading a live database
Date
Msg-id 24544.1032043995@sss.pgh.pa.us
Whole thread Raw
In response to Reading a live database  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: Reading a live database
List pgsql-hackers
"D'Arcy J.M. Cain" <darcy@druid.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


pgsql-hackers by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Reading a live database
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Reading a live database