| From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
|---|---|
| To: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dump and restore ordered by schema or table name |
| Date: | 2019-06-04 20:28:56 |
| Message-ID: | CAPfkCSAdCZMfWCtt9Qk4JoTdrjfii3MWterzNdcAVaPr7jn_7w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Em ter, 4 de jun de 2019 às 17:16, PegoraroF10 <marcos(at)f10(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry O Litvintsev | 2019-06-04 21:49:17 | postgresql11-devel RPM is missing from "Direct RPM downloads" |
| Previous Message | PegoraroF10 | 2019-06-04 20:15:46 | dump and restore ordered by schema or table name |