Move PG installation to a new computer

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Move PG installation to a new computer
Дата
Msg-id gq0978$fi4$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: Move PG installation to a new computer  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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/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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ben Ali Rachid
Дата:
Сообщение: Srf function : missing library on PostgreSQL 8.3.6 on Windows?
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: What are the benefits of using a clustered index?