Re: pg_attribute file in PostgreSQL 9.0 - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: pg_attribute file in PostgreSQL 9.0
Date
Msg-id 201203071553.05895.achill@smadev.internal.net
Whole thread Raw
In response to pg_attribute file in PostgreSQL 9.0  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin
On Τετ 07 Μαρ 2012 15:14:33 Lukasz Brodziak wrote:
> Hello,
>
> I have a question regarding pg_attribute. In which file it is stored
> because the relfilenode for it shows 0 and file 1249 isn't present in
> the folder.

in my system:

dynacom=# SELECT pg_relation_filepath('public.vessels'::regclass);
 pg_relation_filepath
----------------------
 base/539545/63242177
(1 row)

for system catalog tables you will have this relfilenode = 0

--
Achilleas Mantzios
IT DEPT

pgsql-admin by date:

Previous
From: Martin von Oertzen
Date:
Subject: archive_command and streaming replication
Next
From: David Kerr
Date:
Subject: Re: Looking for help on backing up a large database (500GB+) with LOBs