[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Order in which tables are dumped
From: Ron <ronljohnsonjr () gmail ! com>
Date: 2018-07-25 16:17:48
Message-ID: 8120128d-fbf7-35dc-4e46-008e902d713e () gmail ! com
[Download RAW message or body]
On 07/25/2018 10:43 AM, Vick Khera wrote:
> On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr@gmail.com
> <mailto:ronljohnsonjr@gmail.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.
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 07/25/2018 10:43 AM, Vick Khera wrote:<br>
<blockquote type="cite"
cite="mid:CALd+dcde1jbrv8CZzjW40fd0KjeSYtwOG84gpk7mAf-Fy=0H7w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">On Wed, Jul 25, 2018 at 11:15 AM, Ron <span
dir="ltr"><<a href="mailto:ronljohnsonjr@gmail.com"
target="_blank" moz-do-not-send="true">ronljohnsonjr@gmail.com</a>></span>
wrote:<br>
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi,<br>
<br>
v8.4 if it matters.<br>
<br>
It looked like the tables were being backed up in
alphanumeric order, but now I see that table "docformat"
is being dumped <b>after</b> "doc_image".<br>
<br>
Are there some other rules besides alphabetical sorting?</div>
</blockquote>
<div><br>
</div>
<div>Is there some concern about the order? Lower case f
comes after _ in ascii.</div>
</div>
</div>
</div>
</blockquote>
<br>
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.<br>
<br>
<blockquote type="cite"
cite="mid:CALd+dcde1jbrv8CZzjW40fd0KjeSYtwOG84gpk7mAf-Fy=0H7w@mail.gmail.com">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div>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. </div>
</div>
</div>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Angular momentum makes the world go 'round.</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic