Green-Angry-Bird opened a new issue #10301: URL: https://github.com/apache/druid/issues/10301
Needing to do a migration from Derby to Postgres I found two issues with the export-metadata instructions ### Affected Version latest (0.18.1) https://druid.apache.org/docs/latest/operations/export-metadata.html ### Description The export-metadata tool is broken. The exported CSV does not properly delimit backslashes. The workaround is to replace all "\" in the file with "\\" before import to Postgres can be done. The import process is flawed and will break supervisors. The `druid_supervisors_id_seq` needs to be updated after the COPY commands (since COPY does not update sequences). The one-line to accomplish this (after the COPY commands) should be: ``` SELECT setval('druid_supervisors_id_seq', (SELECT MAX(id) FROM druid_supervisors)); ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
