Postgres Pro
Downloads
Home   >   mailing lists

Re: dump and restore ordered by schema or table name - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: dump and restore ordered by schema or table name
Date
Msg-id CAPfkCSAdCZMfWCtt9Qk4JoTdrjfii3MWterzNdcAVaPr7jn_7w@mail.gmail.com
Whole thread Raw
In response to dump and restore ordered by schema or table name  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Tree view


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 by date:

Previous
From: PegoraroF10
Date:
Subject: dump and restore ordered by schema or table name
Next
From: Dmitry O Litvintsev
Date:
Subject: postgresql11-devel RPM is missing from "Direct RPM downloads"