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