Re: Question to safe way for minor update

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Thomas Papke" <tp(at)thopap(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Question to safe way for minor update
Date: 2007-02-13 23:34:14
Message-ID: 200702140034.16406.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thomas Papke wrote:
> AN other question: Are the postgres datafiles (not the dump) platform
> independ?

No.

> So is it possible to just copy the datafiles from linux to
> a windows machine if they are running the same postgres version?

There is no guarantee or direct check against this, but anecdotal
evidence suggests that this combination will not work. In general, the
data file compatibility is determined by some combination of
architecture and compiler settings.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-02-14 01:12:35 Re: Postgresql Upgrade 7.4 to 8.2
Previous Message Michael Downey 2007-02-13 23:28:02 Not able to install PostgreSQL on WIndows using and administrative user