Обсуждение: Access PGDATA from different servers
Hi
One question about Postgresql admin:
On "A server", I use "initdb" to create a database cluster PGDATA on a "file
server".
Can I logon to other server, say "B Server" and start Postmaster using the
database cluster PGDATA which I created from "A Server".
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.
Please can someone give me a hint.
Thanks.
Hans
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