Re: Access PGDATA from different servers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Minghann Ho <mho(at)mcs(dot)vuw(dot)ac(dot)nz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Access PGDATA from different servers
Date: 2003-01-22 21:58:00
Message-ID: 24557.1043272680@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Minghann Ho <mho(at)mcs(dot)vuw(dot)ac(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message shreedhar 2003-01-23 04:20:15 How can I make note of time taken by each query to execute in Triggers
Previous Message Tom Lane 2003-01-22 21:55:53 Re: Problems with authentication