| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Thomas Kellerer *EXTERN*" <spam_eater(at)gmx(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Move PG installation to a new computer |
| Date: | 2009-03-24 09:34:06 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202FF64FB@exadv11.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2009-03-24 09:35:59 | Re: Single missing WAL in long sequence.. |
| Previous Message | Albe Laurenz | 2009-03-24 09:31:30 | Re: [GENERAL] Accessing large objects |