pg_dump / pg_restore - TOC.dat file

From: Clécio Anderson <clecioanderson(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump / pg_restore - TOC.dat file
Date: 2016-01-26 05:12:45
Message-ID: CAE9pMZZc2r8uu_tc0+KV1=m9m8Nm_KbvuS-TE82e3z61kB+cGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Felipe Santos 2016-01-26 10:02:11 Re: pg_dump / pg_restore - TOC.dat file
Previous Message Gunnar "Nick" Bluth 2016-01-25 17:48:34 Re: Postgresql 9.3 Postgis 2.1