Re: dump and restore ordered by schema or table name

[Fabrízio de Royes Mello <fabrizio@xxxxxxxxxxxxxx>]

Em ter, 4 de jun de 2019 às 17:16, PegoraroF10 <marcos@xxxxxxxxxx> 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