Re: dump and restore ordered by schema or table name

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: dump and restore ordered by schema or table name
Дата
Msg-id CAPfkCSAdCZMfWCtt9Qk4JoTdrjfii3MWterzNdcAVaPr7jn_7w@mail.gmail.com
обсуждение исходный текст
Ответ на dump and restore ordered by schema or table name  (PegoraroF10 <marcos@f10.com.br>)
Список pgsql-general
Дерево обсуждения


Em ter, 4 de jun de 2019 às 17:16, PegoraroF10 <marcos@f10.com.br> escreveu:
Our database has 180 schemas with 100 tables each, with majority of them
being small tables. Then, when we do a dump or restore we don´t know how
much time it´ll spend to do that job.

So, there is an option to dump or restore ordered alphabetically ? It could
be by schema or table, do we have it ?


Did you check the -l and -L options? It can help you.

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: PegoraroF10
Дата:
Сообщение: dump and restore ordered by schema or table name
Следующее
От: Dmitry O Litvintsev
Дата:
Сообщение: postgresql11-devel RPM is missing from "Direct RPM downloads"