Re: Moving Postgres Database

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Edward Coyle <ecoyle(at)intellecare(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving Postgres Database
Date: 2006-06-01 03:08:20
Message-ID: 20060601030820.GA24219@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 31, 2006 at 15:34:46 -0500,
Edward Coyle <ecoyle(at)intellecare(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-06-01 03:19:05 Re: Moving Postgres Database
Previous Message Jim Nasby 2006-06-01 02:48:19 Re: Moving Postgres Database