| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Thorsten Schöning <tschoening(at)am-soft(dot)de>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: upgrade path from PG 8.3 to PG 9.5 |
| Date: | 2017-03-22 03:12:48 |
| Message-ID: | 446.1490152368@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tue, Mar 21, 2017 at 9:40 AM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>> Yes. Using the older pg_dump may result in dumps that can't be restored
>> into the newer version of PG because things like keywords have been
>> added and must now be quoted. There are possibly other things that have
>> been changed between the old version and the new one which would also
>> require the new pg_dump to be used, but keywords are the big one.
> The proper solution to the keyword/identifier quoting problem is to use
> "--quote-all-identifiers".
... which didn't exist before 9.1 ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-03-22 03:23:41 | Re: |
| Previous Message | Santiago DIEZ | 2017-03-21 22:05:13 |