Feature #2022
closed
Additional database export option (dump)
Description
As the default SQL export causes issues in Windows due to different line endings, an easy option for a database export would be appreciated.
Update
An additional export option (dump) was added which is using the -Fc parameters of the pg_dump command.
Updated by Alexander Watzinger 11 months ago
- Category set to Data import/export
- Status changed from New to Assigned
- Target version set to 7.16.0
Updated by Alexander Watzinger 11 months ago
Good idea, maybe I look into it with Bernhard together.
Updated by Bernhard Koschiček-Krombholz 9 months ago
- Description updated (diff)
- Status changed from Assigned to In Progress
Good idea. I see 3 different option to implement it in the UI:
- Check which OS the user uses and export for this OS (worst option)
- Make two export buttons (posix and win)
- Include both versions in 7z file
OR we go away from plain text export to custom -Fc which can be restored with pg_restore.
Updated by Moritz Großfurtner 9 months ago
Going away from plain text might be a good idea but also sounds quite time consuming so I'm not sure if that's the way to go at this moment.
Personally I like the idea of two buttons so that users can choose what they get.
Updated by Bernhard Koschiček-Krombholz 9 months ago
In the feature branch, you have the possibility to create plain or custom SQL format.
To do:- Manual update
- Tests
Updated by Bernhard Koschiček-Krombholz 9 months ago
- Description updated (diff)
- Status changed from In Progress to Closed
Is in develop.
Updated by Alexander Watzinger 9 months ago
- Subject changed from Add export option for windows compatible database dump to Additional database export option (dump)
- Description updated (diff)
Thanks for adding the new export function. I took the liberty to rename some params/filenames to reflect the file type but works great otherwise.