pg_dump / pg_restore - TOC.dat file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux