Project

General

Profile

Actions

Feature #2022

closed

Additional database export option (dump)

Added by Moritz Großfurtner 9 months ago. Updated 7 months ago.

Status:
Closed
Priority:
Normal
Category:
Data import/export
Target version:
Start date:
2023-05-22
Estimated time:

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.

Actions #1

Updated by Alexander Watzinger 9 months ago

  • Category set to Data import/export
  • Status changed from New to Assigned
  • Target version set to 7.16.0
Actions #2

Updated by Alexander Watzinger 9 months ago

Good idea, maybe I look into it with Bernhard together.

Actions #3

Updated by Moritz Großfurtner 9 months ago

  • Description updated (diff)
Actions #4

Updated by Bernhard Koschiček-Krombholz 7 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.

Actions #5

Updated by Moritz Großfurtner 7 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.

Actions #6

Updated by Bernhard Koschiček-Krombholz 7 months ago

In the feature branch, you have the possibility to create plain or custom SQL format.

To do:
  • Manual update
  • Tests
Actions #7

Updated by Bernhard Koschiček-Krombholz 7 months ago

  • Description updated (diff)
  • Status changed from In Progress to Closed

Is in develop.

Actions #8

Updated by Alexander Watzinger 7 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.

Actions

Also available in: Atom PDF