dump and restore ordered by schema or table name

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: dump and restore ordered by schema or table name
Date: 2019-06-04 20:15:46
Message-ID: 1559679346260-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2019-06-04 20:28:56 Re: dump and restore ordered by schema or table name
Previous Message Francisco Olarte 2019-06-04 19:12:37 Re: Two small questions re/ COPY CSV data into table