dat names generated by pg_dump

Поиск
Список
Период
Сортировка
От Ron
Тема dat names generated by pg_dump
Дата
Msg-id 0ddc55d3-d7b7-a765-5548-0d847b41d941@gmail.com
обсуждение исходный текст
Ответы Re: dat names generated by pg_dump
Re: dat names generated by pg_dump
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: WARNING: could not flush dirty data: Function not implemented
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: dat names generated by pg_dump