Re: Order in which tables are dumped

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Order in which tables are dumped
Date: 2018-07-25 15:43:35
Message-ID: CALd+dcde1jbrv8CZzjW40fd0KjeSYtwOG84gpk7mAf-Fy=0H7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> Hi,
>
> v8.4 if it matters.
>
> It looked like the tables were being backed up in alphanumeric order, but
> now I see that table "docformat" is being dumped *after* "doc_image".
>
> Are there some other rules besides alphabetical sorting?
>

Is there some concern about the order? Lower case f comes after _ in ascii.

The only time it could possibly matter is on restore when there are
references for foreign keys, but on a restore those are all done after the
data is restored.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-07-25 15:44:55 Re: Order in which tables are dumped
Previous Message Dimitri Maziuk 2018-07-25 15:40:50 Re: logical replication snapshots