| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | EDH <evandhoffman(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Copying data files to new hardware? |
| Date: | 2010-10-13 16:41:55 |
| Message-ID: | AANLkTineQdKs0fBEh0t3BNFDR1QUV9g0eJvSAokeyHb=@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Wed, Oct 13, 2010 at 11:03 AM, EDH <evandhoffman(at)gmail(dot)com> wrote:
[...]
>
> What I'd like to know is: if I install the latest 8.2.x release - I
> see 8.2.18 RPMs are available - can I do a straight copy of the
> contents of /var/lib/pgsql/data/ to the new server and start it up?
> Or is dump & restore the only real way to do this?
>
it's safe to just install any version of 8.2.x, copy the whole data
directory (plus any tablespace's directories you could have) and start
again... probably you want to REINDEX your indexes (read the release
notes to see what specific kind of indexes you need to reindex)
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ozer, Pam | 2010-10-13 16:48:29 | Cannot connect to database |
| Previous Message | EDH | 2010-10-13 16:03:17 | Copying data files to new hardware? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Hirt | 2010-10-13 16:49:53 | Re: Copying data files to new hardware? |
| Previous Message | Joshua D. Drake | 2010-10-13 16:18:14 | Re: pitr question |