Обсуждение: Access PGDATA from different servers

Поиск
Список
Период
Сортировка

Access PGDATA from different servers

От
Minghann Ho
Дата:
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





Re: Access PGDATA from different servers

От
Tom Lane
Дата:
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