Re: Which files belong to which database?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Which files belong to which database?
Дата
Msg-id 20030910072538.F64012-100000@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Which files belong to which database?  (Oliver Fromme <olli@lurza.secnetix.de>)
Список 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.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Jason Hihn
Дата:
Сообщение: Re: Lyris and Postgres
Следующее
От: Bryan Irvine
Дата:
Сообщение: phone number list