Move PG installation to a new computer

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Move PG installation to a new computer
Date: 2009-03-20 14:28:55
Message-ID: gq0978$fi4$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm getting a new notebook and want to confirm that my idea on how to move my Postgres installation will work This is a development/test installation and not a production system, so it doesn't need to be 100% fail safe.

Both systems are Windows XP 32bit.

My plan was to install the same PG release (8.3) on the new computer, skip the initdb task during installation, but let the installer create the necessary service pointing to an empty data directory. Using the same OS user account.

Once the installation is finished, copy all files from the old datadir (after shutting down that postmaster) to the new datadir as the PG Windows user, so that access right are setup correctly.

As both machines have the same OS and architecture my assumption is that this should work.
Or am I mistaken?

Thanks
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2009-03-20 15:27:21 Re: Is there a meaningful benchmark?
Previous Message Ben Ali Rachid 2009-03-20 14:19:37 Srf function : missing library on PostgreSQL 8.3.6 on Windows?