Converting standard_conforming_strings from off to on when importing Postgres dump
3
votes
1
answer
1610
views
I've got a Postgres 8.1 instance which has
standard_conforming_strings
set to off
(== handles slashes as escape characters). Recent Postgres versions have this setting on
by default (for good reasons).
When importing a dump from 8.1 to 9.x, then I can set this setting to off
in the 9.x DB but I don't want to, I'd prefer converting the dump into the proper format. This is a ~100GB dump.
How could I do that? Can I simply turn this setting 'on' in the 8.1 version? (Will that affect exporting existing data? Will/can that corrupt or modify existing data?)
What doesn't work: simply importing data produced by 8.1 to 9.x without setting standard_conforming_strings to off
in the 9.x DB; the result is corrupted data.
Asked by Mate Varga
(139 rep)
Mar 19, 2016, 07:37 PM
Last activity: Apr 3, 2016, 09:15 AM
Last activity: Apr 3, 2016, 09:15 AM