Re: dat names generated by pg_dump

On 09/02/2018 08:41 PM, Adrian Klaver wrote:
> On 09/02/2018 05:40 PM, Ron wrote:
>> Hi,
>>
>> I can associate these dat names with their source tables through a bunch
>> of bash and vim manual operations, but I was wondering if there's any
>> automated method (maybe some SQL query of some catalog table; pg_class
>> didn't seem to have the relevant data) of making the association.
>
> Some background would be helpful:
>
> 1) What is producing the *.dat files?

pg_dump, as described in the Subject.

>
> 2) What is their structure?

They're pg_dump files.

>
> 3) What do the numbers refer to?

That's what I'm asking the list.

>
>>
>> If relevant, the source database is v8.4, but the backup was done by 9.6
>> on a separate server.
>>
>> $ ls -1 CDSLBXW/*dat | head
>> CDSLBXW/8412.dat
>> CDSLBXW/8414.dat
>> CDSLBXW/8416.dat
>> CDSLBXW/8418.dat
>> CDSLBXW/8420.dat
>> CDSLBXW/8422.dat
>> CDSLBXW/8423.dat
>> CDSLBXW/8425.dat
>> CDSLBXW/8427.dat
>> CDSLBXW/8428.dat
>>
>> Thanks
>>
>
>

--
Angular momentum makes the world go 'round.