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")
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... |