| From: | rhkelly <rhkelly(at)myrealbox(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: stupid question |
| Date: | 2003-12-31 22:09:07 |
| Message-ID: | 3FF34903.7080500@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> On Fri, 26 Dec 2003, Bryan Irvine 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?
>
>
> nope ... depending on what version of postgresql you are running, the
> newer ones store it in ${PGDATA}/base/<OID>, under which, there are
> indivicudal files for system tables, indices and tables themselves ...
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.?
TIA.
Roger
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2003-12-31 23:25:59 | Re: mysql_field_name equivalent |
| Previous Message | Sergio L. Garza M. | 2003-12-31 21:59:46 | "Unknown DBI error" when trying to view data on some tables... |