Re: pg_dump / pg_restore - TOC.dat file

2016-01-26 3:12 GMT-02:00 Clécio Anderson <clecioanderson(at)gmail(dot)com>:

> 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 <http://lattes.cnpq.br/0641375920107155>*
> *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