Skip site navigation (1) Skip section navigation (2)

Re: stupid question

From: rhkelly <rhkelly(at)myrealbox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: stupid question
Date: 2004-01-01 17:37:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 LaneDate: 2004-01-01 18:15:08
Subject: Re: stupid question
Previous:From: Olaf FergerDate: 2004-01-01 16:56:37
Subject: output of vacuumdb after upgrade to 7.4.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group