Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Moving a data base between differnt OS



On Wed, Apr 26, 2006 at 21:33:32 +0200,
  Holger Zwingmann <holger(dot)zwingmann(at)p3-solutions(dot)de> wrote:
> Hi,
> 
> I just realized that is is possible to do a (backup) copy of a database
> by copying the "root folder" within the same OS.

There are some other conditions as well. Postgres needs to be shut down when
you do the copy. The CPU needs to be the same architecture. Postgres should
be built with the same options (some data representations are controlled by
config options). Potentially different compilers (used to build Postgres on
the two systems) could cause problems as well (by changing structure layouts).

> 
> Now, I am wondering if there is a way to copy a data base from one OS to
> another in the same way. Would it possible copy a (small) data base from
> Linux to MS Windows by simply copying a folder?



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group