| From: | Jeff Trout <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question: migrate |
| Date: | 2005-05-27 16:52:23 |
| Message-ID: | FA99CE4F-0F3E-471E-A981-883DCCD823C7@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2005-05-27 16:55:44 | Re: solaris 10 vs Linux Debian on SUN Fire v40z |
| Previous Message | Hrishikesh Deshmukh | 2005-05-27 16:10:17 | Question: migrate |