Re: stupid question - Mailing list pgsql-novice

From Tom Lane
Subject Re: stupid question
Date
Msg-id 21914.1072980908@sss.pgh.pa.us
Whole thread Raw
In response to Re: stupid question  (rhkelly <rhkelly@myrealbox.com>)
Responses Re: stupid question
List pgsql-novice
rhkelly <rhkelly@myrealbox.com> writes:
> Michael Glaesemann wrote:
>>> 2) what are the safe filesystem operations on those files
>>> (individual file backup/recovery, moving of files
>>> between different postgress computers/installations etc.?
>>
>> Not to be contrary, but why would you want to know this?

> So that I can put the system into some 'partial/previous'
> state in a manner which Postgress itself does not support

You can't.  The connections between data files, xlog, and clog
are sufficiently critical that you cannot hope to take some files
out of an installation and put them into another one (nor into
an earlier or later state of the same installation).

            regards, tom lane

pgsql-novice by date:

Previous
From: rhkelly
Date:
Subject: Re: stupid question
Next
From: Tom Lane
Date:
Subject: Re: output of vacuumdb after upgrade to 7.4.1