Re: Which files belong to which database?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Which files belong to which database?
Date: 2003-09-10 14:28:43
Message-ID: 20030910072538.F64012-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Wed, 10 Sep 2003, Oliver Fromme wrote:

> Is there a way to find out which files in $PGDATA belong
> to which database? I need that information for accounting
> purposes (users are billed per Gbyte of data). In mysql

I believe the structure in general is:
base/
base/<database oid>
base/<database oid>/<object relfilenoid>

In contrib there's a program, oid2name, which will show the name/number
mappings.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bryan Irvine 2003-09-10 15:24:06 how many records
Previous Message szucs 2003-09-10 13:32:25 Re: Search for data in a similar field in a related table, too