| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Holger Zwingmann <holger(dot)zwingmann(at)p3-solutions(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Moving a data base between differnt OS |
| Date: | 2006-04-26 20:24:19 |
| Message-ID: | 20060426202419.GA31224@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2006-04-26 20:29:29 | Re: Clustered table order is not preserved on insert |
| Previous Message | Jim Buttafuoco | 2006-04-26 20:14:37 | Re: Clustered table order is not preserved on insert |