pg_restore /data1/exports/musicdb_Fc.dmp -l
List the content of a "directory format" export file created by pg_dump by specifying the -l flag. Note that the path should point to the directory in which the toc.dat file resides, in my case /data1/exports/mydir:
pg_restore /data1/exports/mydir/ -l
In both cases, output will be something akin to
; ; Archive created at 2021-09-16 12:51:17 CEST ; dbname: musicdb ; TOC Entries: 29 ; Compression: -1 ; Dump Version: 1.13-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 11.12 ; Dumped by pg_dump version: 11.12 ; ; ; Selected TOC Entries: ; 10; 2615 45112854 SCHEMA - music postgres 3764; 0 0 ACL - SCHEMA music postgres 202; 1259 45112865 TABLE music albums music 203; 1259 45112868 TABLE music albums_1974 music 204; 1259 45112871 TABLE music albums_1979 music 201; 1259 45112863 SEQUENCE music albums_album_id_seq music 205; 1259 45112874 TABLE music albums_default music 207; 1259 45112879 TABLE music artists music 206; 1259 45112877 SEQUENCE music artists_artist_id_seq music 209; 1259 45112884 TABLE music bands music 208; 1259 45112882 SEQUENCE music bands_band_id_seq music 200; 1259 45112858 TABLE music songs music 199; 1259 45112856 SEQUENCE music songs_song_id_seq music 3750; 0 45112868 TABLE DATA music albums_1974 music 3751; 0 45112871 TABLE DATA music albums_1979 music 3752; 0 45112874 TABLE DATA music albums_default music 3754; 0 45112879 TABLE DATA music artists music 3756; 0 45112884 TABLE DATA music bands music 3748; 0 45112858 TABLE DATA music songs music 3765; 0 0 SEQUENCE SET music albums_album_id_seq music 3766; 0 0 SEQUENCE SET music artists_artist_id_seq music 3767; 0 0 SEQUENCE SET music bands_band_id_seq music 3768; 0 0 SEQUENCE SET music songs_song_id_seq music 3620; 2606 45112862 CONSTRAINT music songs songs_pkey music
No comments:
Post a Comment