Re: Copying data files to new hardware?
| От | Jaime Casanova |
|---|---|
| Тема | Re: Copying data files to new hardware? |
| Дата | |
| Msg-id | AANLkTineQdKs0fBEh0t3BNFDR1QUV9g0eJvSAokeyHb=@mail.gmail.com обсуждение исходный текст |
| Ответ на | Copying data files to new hardware? (EDH <evandhoffman@gmail.com>) |
| Ответы |
Re: [ADMIN] Copying data files to new hardware?
|
| Список | pgsql-general |
On Wed, Oct 13, 2010 at 11:03 AM, EDH <evandhoffman@gmail.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
В списке pgsql-general по дате отправления: