data/base file structure

From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "p-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: data/base file structure
Date: 2001-06-04 18:22:56
Message-ID: 00cd01c0ed23$616dd4c0$5dd26383@corp.compucom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

can somebody explain to me, or point to an explanation of, the way, PostGreSQL names databases?I have files like 18732 and 7503034 - and they are big but I have no idea which data lives in what file:

/home/pgsql/data/base/18720/
-rw------- 1 postgres postgres 70385664 May 24 13:55 7503034
-rw------- 1 postgres postgres 10788864 May 24 13:54 8748869
-rw------- 1 postgres postgres 458752 May 24 12:21 8939786
-rw------- 1 postgres postgres 158334976 May 24 13:51 8945104

Best regards,
Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Vecernik 2001-06-04 18:50:01 Re: data/base file structure
Previous Message Lee Kwok Shing 2001-06-04 15:39:43 Re: System hangs when Insert/Update