Re: Help with data transfer please

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Help with data transfer please
Дата
Msg-id 20020610164029.O4880@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: Help with data transfer please  (terry@greatgulfhomes.com)
Ответы Re: Help with data transfer please  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, Jun 10, 2002 at 04:30:26PM -0400, terry@greatgulfhomes.com wrote:
> It is my understanding that copying the files that reside in the data
> directory are not sufficient for a backup/restore, (because there are file
> pointers within the data files I believe, pointers which are no longer valid
> on a different server because different blocks get assigned to different
> files).  Therefore it follows that an rsync would not be sufficient to keep
> the database in sync.

Hmm.  That sounds plausible.  But you can tar up a data directory,
and restore it later on a different physical device, and it will
work.  Or, at least, it has worked for me.  This, only if the
postmaster is shut down.  But maybe my case was just a fluke.
Someone who knows should weigh in.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] VIEWs and FOREIGN keys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: logging to a file