Обсуждение: 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