Re: Help with data transfer please

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: 'pgsql-general' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with data transfer please
Date: 2002-06-10 20:40:29
Message-ID: 20020610164029.O4880@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 10, 2002 at 04:30:26PM -0400, terry(at)greatgulfhomes(dot)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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-06-10 20:46:06 Re: logging to a file
Previous Message Tom Lane 2002-06-10 20:38:20 Re: [SQL] VIEWs and FOREIGN keys