Thread: Move PG installation to a new computer

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/testinstallation 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
theinstaller 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
datadiras 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

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.

Yours,
Laurenz Albe

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