Re: transfer just the data directories from linux to windows? - Mailing list pgsql-general

From Magnus Hagander
Subject Re: transfer just the data directories from linux to windows?
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA0FD8A@algol.sollentuna.se
Whole thread Raw
In response to transfer just the data directories from linux to windows?  ("Anton Melser" <melser.anton@gmail.com>)
List pgsql-general
> Hi,
> We have some backups from our prod server and I was wondering
> if there would be any problems with just copying the data
> directory to a windows install (same version - 8.1.4) ... any
> pointers?

If both servers are windows servers, and both are running the same
version of pg, then you can just copy the files over. Make sure the
postgresql service is *stopped* when you do the copying. (Clean out
everything in the data directory before you copy them over)
If either of those two are not the same, you can't.

//Magnus

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Restore database from files (not dump files)?
Next
From: Antonios Katsikadamos
Date:
Subject: porducing documentation from postgres