Re: Moving Postgres Database - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Moving Postgres Database
Date
Msg-id 20060601030820.GA24219@wolff.to
Whole thread Raw
In response to Moving Postgres Database  ("Edward Coyle" <ecoyle@intellecare.com>)
List pgsql-general
On Wed, May 31, 2006 at 15:34:46 -0500,
  Edward Coyle <ecoyle@intellecare.com> 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?

If the database is shut down when you do this any the systems are running
the same versions of postgres on hardware of the same archteciture type
this should work.

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Moving Postgres Database
Next
From: Chris
Date:
Subject: Re: Moving Postgres Database