| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | dat names generated by pg_dump |
| Date: | 2018-09-03 00:40:16 |
| Message-ID: | 0ddc55d3-d7b7-a765-5548-0d847b41d941@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-09-03 01:41:50 | Re: dat names generated by pg_dump |
| Previous Message | Andres Freund | 2018-09-02 23:31:18 | Re: WARNING: could not flush dirty data: Function not implemented |