Michael Glaesemann wrote:
> Hello, fellow myrealbox user!
> ...rhkelly wrote:
>>>> Maybe this sounds stupid, but, where is the actual database file?
>>>> I'm sure there's a file that is the actual DB, but what/where?
>> Is there a Postgress documentation section somewhere that
>> would tell me the following:
>> 1) the exact correspondence of the files and tables, indices etc.
>> 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?
Thanks for your comments Michael; to answer your question:
So that I can put the system into some 'partial/previous'
state in a manner which Postgress itself does not support
and with a high degree of confidence that my actions had
the desired effect (and no catastrophic side-effects :).
I felt it would be a misappropriation of the attention and
patience of the list to get into details; I only humbly
asked for help with the documentation in a thread that was
'on topic' ;) i.e., something I thought *ought to be*
documented (and - at least as fas as item '1' above is
concerned - for puposes other than mine!), but was unable
to find. I'll keep looking.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-01-01 18:15:08|
|Subject: Re: stupid question |
|Previous:||From: Olaf Ferger||Date: 2004-01-01 16:56:37|
|Subject: output of vacuumdb after upgrade to 7.4.1|