Re: stupid question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rhkelly <rhkelly(at)myrealbox(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: stupid question
Date: 2004-01-01 18:15:08
Message-ID: 21914.1072980908@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

rhkelly <rhkelly(at)myrealbox(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-01-01 18:36:45 Re: output of vacuumdb after upgrade to 7.4.1
Previous Message rhkelly 2004-01-01 17:37:42 Re: stupid question