Object like pg_class.relkind = 's' or 'c' have on-disk file?

From: Katsuhiko Okano <k_okano(at)po(dot)ntts(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: Object like pg_class.relkind = 's' or 'c' have on-disk file?
Date: 2005-03-17 01:34:34
Message-ID: 4238DEAA.5010506@po.ntts.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.
I'm writing backup guide and script.

I will look up on-disk-filename should be backuped
in a pg_class, like:
>SELECT oid,relfilenode,relname,relkind FROM pg_class;
it return like:
> 17173 | 17173 | sql_packages | r
> 17182 | 17182 | pg_toast_17178_index | i
> 17180 | 17180 | pg_toast_17178 | t
> 376 | 0 | pg_xactlock | s

I'll include backup set relkind='r' or 'i' or 'S' or 'v' or 't'.
but PostgreSQL 8.0.1 Documentation "41.9. pg_class" say
>c = composite type, s = special

1)relkind = 's' is always have not on-disk file?

2)when exist relkind='s' object except pg_xactlock?
user(administrator) can create it?

3)relkind = 'c' is always have not on-disk file?
(I create TYPE. but no file exist.)
I will only include pg_type relation in backup set. is it OK ?

4)any other advice to backup? :-)

Regards,
--
----------------------------------------
Katsuhiko Okano
k_okano _at_ po.ntts.co.jp
NTT Software Corp. (division "NBRO-PT6")

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vern 2005-03-17 01:52:11 New PostGreSQL Newsgroup - VOTE TO BEGIN
Previous Message Andrew B. Lundgren 2005-03-16 23:45:45 search_path, schemas and functions...