Re: pg_dump / pg_restore - TOC.dat file

[Felipe Santos <felipepts@xxxxxxxxx>]

2016-01-26 3:12 GMT-02:00 Clécio Anderson <clecioanderson@xxxxxxxxx>:

Hi guys!

Does anyone knows the meaning of each collumn in TOC.dat file generated by pg_dump?

For example:

;

; Archive created at Thu Jan 21 18:36:25 2016

;     dbname: mydb

;     TOC Entries: 7528

;     Compression: -1

;     Dump Version: 1.12-0

;     Format: DIRECTORY

;     Integer: 4 bytes

;     Offset: 8 bytes

;     Dumped from database version: 9.3.5

;     Dumped by pg_dump version: 9.3.5

;

;

; Selected TOC Entries:

;

11471; 1262 36497111 DATABASE - mydb postgres

7; 2615 36497112 SCHEMA - acl postgres

11472; 0 0 ACL - acl postgres

179; 1259 36497634 TABLE acl tb_log postgres

11514; 0 0 ACL acl tb_log postgres

180; 1259 36497638 TABLE acl tb_paper postgres

11515; 0 0 ACL acl tb_paper postgres

181; 1259 36497643 TABLE acl tb_paper_group postgres

11516; 0 0 ACL acl tb_paper_group postgres

182; 1259 36497646 TABLE acl tb_permission postgres

11517; 0 0 ACL acl tb_permission postgres

At the first line for example.. 

11471; 1262 36497111 DATABASE - mydb postgres

What each collumn means? What 11471 means? or 1262 or 36497111.... and so on..

Thanks in advance for your help and time!

--

Tecnólogo em Redes de Computadores
Currículo Lattes

MCTS | MCITP | LPIC-2 | ITIL Foundation

11471; 1262 36497111 DATABASE - mydb postgres

11471 - ?

1262 - ?

36497111 - Object ID

DATABASE - Object Type

mydb - Object Name

postgres - Object Owner