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
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 |