Re: Question: migrate

On May 27, 2005, at 12:10 PM, Hrishikesh Deshmukh wrote:

> Hi All,
>
> I have a huge database working on a debian linux machine, this machine
> is going to get a hard drive wipe and new OS. I have another debian
> linux machine (exact hardware + software). Is there a way to get
> database "migrated" from machine 1 to machine 2 without much work?
>

2 methods

1. since it is the same kind of hardware you can shut down PG on
machine1 and tar up $PGDATA move to machine2, untar and fire up PG.

2. pg_dump on machine 1, copy the dump, load up on machine2. (this
will take longer)

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/