Re: Access PGDATA from different servers - Mailing list pgsql-admin

From Tom Lane
Subject Re: Access PGDATA from different servers
Date
Msg-id 24557.1043272680@sss.pgh.pa.us
Whole thread Raw
In response to Access PGDATA from different servers  (Minghann Ho <mho@mcs.vuw.ac.nz>)
List pgsql-admin
Minghann Ho <mho@mcs.vuw.ac.nz> writes:
> Can I logon to other server, say "B Server" and start Postmaster using the
> database cluster PGDATA which I created from "A Server".

Not when they're not the same machine architecture.

> I tried to do this, but got a msg say:
> FATAL 2:  The database cluster was initialized with PG_CONTROL_VERSION
> 1191182336,
>     but the server was compiled with PG_CONTROL_VERSION 71.
>     It looks like you need to initdb.

Looks like the two machines don't even have the same byte endianness.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with authentication
Next
From: "shreedhar"
Date:
Subject: How can I make note of time taken by each query to execute in Triggers