Re: Move PG installation to a new computer

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Move PG installation to a new computer
Date: 2009-03-24 10:00:11
Message-ID: gqaavc$s2q$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albe Laurenz, 24.03.2009 10:34:
> Thomas Kellerer wrote:
>> 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?
>
> Yes, that should work.

Great, thanks for the answer.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zühlsdorff 2009-03-24 10:01:08 Re: Fulltext: problem with english words in german text
Previous Message Jasen Betts 2009-03-24 09:53:04 Re: Accent insensitive search?