Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] - Need Clarification about filenodes under base database directory - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] - Need Clarification about filenodes under base database directory
Date
Msg-id 16429.1490276878@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] - Need Clarification about filenodes under base database directory  (Panneer Selvam <panneerselvamrmd@gmail.com>)
List pgsql-admin
Tree view 
Panneer Selvam <panneerselvamrmd@gmail.com> writes:
> We have a database with no active relations on it. ( I.e. No tables or
> Indexes exist as of now ).
> But when we look at our base directory for this database, it's having many
> relations pointing pg_type & pg_toast.

Some of the system catalogs have toast tables attached ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "michael@sqlexec.com"
Date:
Subject: Re: [ADMIN] pg_dump ERROR: missing chunk number 0 for toast value
Next
From: srilinux
Date:
Subject: Re: [ADMIN] unable to find data folder postgres9.4