Jeff Davis wrote:
On Tue, 2008-12-02 at 16:21 +0200, Heikki Linnakangas wrote:

initdb on one platform, copy the data directory over to the other
system, and try to start postmaster. It will complain if the on-disk
format is not compatible.

You can also run pg_controlinfo on both systems, and compare the
results. If the "Maximum data alignment", and all the values below it in
the pg_controlinfo output match, the formats are compatible.
I don't think these things will work for all differences that could be
problematic. For instance, a GNU system has a different collation for
the en_US locale than an OS X system. This means that the indexes built
using en_US on one system can't be moved to the other.

How would either of these tests be able to determine that the systems
are incompatible?
wow...that's a little scary. Sounds like there is no trustworthy test I
can run. Other than the case of collation differences, are there any
other kinds of problems that would not be detected by even a postmaster
restart?


/

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 8 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedDec 2, '08 at 12:02p
activeDec 3, '08 at 12:03a
posts8
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase