Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 31E5B9FB727 for ; Tue, 13 Feb 2007 19:32:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 29870-06 for ; Tue, 13 Feb 2007 19:32:49 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 1C9A69FB6A7 for ; Tue, 13 Feb 2007 19:32:52 -0400 (AST) Received: (qmail invoked by alias); 13 Feb 2007 23:32:51 -0000 X-Provags-ID: V01U2FsdGVkX18ZoZQlHqEZZb6t3ZZychn4ikKSXdGkvMsHXHXjw4 Auag== From: Peter Eisentraut To: "Thomas Papke" Subject: Re: Question to safe way for minor update Date: Wed, 14 Feb 2007 00:34:14 +0100 User-Agent: KMail/1.9.5 Cc: pgsql-admin@postgresql.org References: <1001305.61140.62.214.193.211.1171388243.squirrel@webmailer.hosteurope.de> <200702132111.23707.peter_e@gmx.net> <1001305.64504.62.214.193.211.1171400897.squirrel@webmailer.hosteurope.de> In-Reply-To: <1001305.64504.62.214.193.211.1171400897.squirrel@webmailer.hosteurope.de> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200702140034.16406.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/186 X-Sequence-Number: 24651 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/