Re: Reloading data

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reloading data
Дата
Msg-id 683.1062896739@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Reloading data  (Damon Courtney <damon@your.unreality.com>)
Список pgsql-novice
Damon Courtney <damon@your.unreality.com> writes:
>     Is there some easy way I can take an old PGDATA directory and load
> it into a new instance of Postgres?  My server was rebuilt, and I didn't
> get a chance to dump the database to restore it in the new server.

Only if it's the samw Postgres version, and you want to replace the
whole installation (entire contents of PGDATA).

>     Will copying the old data directory into the new server really screw
> things up?  Is there some method by which I can somehow "import" data from
> those old data files into the new server?

It sounds like you want to merge with stuff you already have in the new
server, rather than just blow it away and replace the installation with
the old PGDATA contents.  I'd suggest that you fire up a postmaster of
the appropriate version in the old PGDATA directory, run pg_dumpall, and
load the dump file into the new server.

            regards, tom lane

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Reloading data
Следующее
От: "Smitha V. Babu"
Дата:
Сообщение: