Re: Moving Postgres Database

Jim Nasby wrote:
> On May 31, 2006, at 9:18 PM, Chris wrote:
>> Edward Coyle wrote:
>>> I want to move a windows server 2003 based postgres database from one
>>> server to another server, can I just copy and paste the base folder
>>> or do I have to do a backup and restore? If so what options work best
>>> for creating a file to move?
>>
>> I think if you shut down postgresql on both systems then you can
>> copy/paste the folder structure.
>>
>> However they must be exactly the same versions - ie you can't do this
>> if one system is 8.0.1 and one is 8.1 or even if one is 8.0.1 and one
>> is 8.0.4.
>
> Actually, as long as you're not changing major versions (ie: 8.0.x to
> 8.1.x) you'll be fine.

I wasn't sure if changes like 8.1.x to 8.1.4 would cause a problem here:

http://developer.postgresql.org/docs/postgres/release-8-1-4.html

A dump/restore is not required for those running 8.1.X. However, if you
are upgrading from a version earlier than 8.1.2, see the release notes
for 8.1.2.

(I thought I saw something about an internal change somewhere along
8.1.x versions, this might be it).

--
Postgresql & php tutorials
http://www.designmagick.com/