Postgres Pro
Downloads
Home   >   mailing lists

Thread: dump and restore ordered by schema or table name

dump and restore ordered by schema or table name

From
PegoraroF10
Date:
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 ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: dump and restore ordered by schema or table name

From
Fabrízio de Royes Mello
Date:


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