From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Order in which tables are dumped |
Date: | 2018-07-25 16:17:48 |
Message-ID: | 8120128d-fbf7-35dc-4e46-008e902d713e@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/25/2018 10:43 AM, Vick Khera wrote:
> On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr(at)gmail(dot)com
> <mailto: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.
I'm tracking the progress of a very long backup, and the spreadsheet I using
(and gnu sort, too, and IIRC Postgres' own ORDER BY) sort based on the
current locale (en_US), whereas pg_dump sorts based on the C locale. Thus,
things aren't as I expected.
> 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.
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-07-25 16:32:35 | Re: Permission denied on schema for all users on insert to table with fk |
Previous Message | Adrian Klaver | 2018-07-25 16:16:03 | Re: logical replication snapshots |