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*
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 |