Posted by Sven Gothel on Feb 13, 2020; 12:23pm
URL: https://forum.jogamp.org/Considering-Mailman-tp4040355p4040369.html

On 2/13/20 12:47 PM, gouessej [via jogamp] wrote:
> Hello
>
> Is it just a plain Postgresql SQL dump?
> https://www.postgresql.org/docs/12/backup-dump.html

yes, you (as an admin) can get the backup zip
and it looks like PQ SQL dump .. hmm.

+++

sven@risa:/usr/local/projects/JogAmp/admin/forum-nabble$ unzip -l
site_762907_1040770263.zip
Archive:  site_762907_1040770263.zip
  Length      Date    Time    Name
---------  ---------- -----   ----
        0  2020-02-11 03:26   pg_backup/
       46  2020-02-11 03:26   pg_backup/schemas.sql
        0  2020-02-11 03:26   pg_backup/schemas/
        0  2020-02-11 03:26   pg_backup/schemas/s762907/
      368  2020-02-11 03:26   pg_backup/schemas/s762907/sequences.sql
     3679  2020-02-11 03:26   pg_backup/schemas/s762907/tables.sql
        0  2020-02-11 03:26   pg_backup/schemas/s762907/tables/
      348  2020-02-11 03:26   pg_backup/schemas/s762907/tables/configuration
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/file_site
       53  2020-02-11 03:26   pg_backup/schemas/s762907/tables/module
      609  2020-02-11 03:26   pg_backup/schemas/s762907/tables/registration
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/site_property
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/tweak
       39  2020-02-11 03:26   pg_backup/schemas/s762907/tables/version
  1867514  2020-02-11 03:26   pg_backup/schemas/s762907/tables/file_avatar
   786319  2020-02-11 03:26   pg_backup/schemas/s762907/tables/file_temp
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/paid
129160962  2020-02-11 03:26   pg_backup/schemas/s762907/tables/file_node
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/mailing_list
      595  2020-02-11 03:26   pg_backup/schemas/s762907/tables/node_property
       21  2020-02-11 03:26   pg_backup/schemas/s762907/tables/user_property
       81  2020-02-11 03:26   pg_backup/schemas/s762907/tables/site
    32865  2020-02-11 03:26   pg_backup/schemas/s762907/tables/subscription
     9374  2020-02-11 03:26   pg_backup/schemas/s762907/tables/tag
    54867  2020-02-11 03:26   pg_backup/schemas/s762907/tables/view_count
   516303  2020-02-11 03:26   pg_backup/schemas/s762907/tables/visited
 42176453  2020-02-11 03:26   pg_backup/schemas/s762907/tables/node_msg
   234026  2020-02-11 03:26   pg_backup/schemas/s762907/tables/user_
  4841209  2020-02-11 03:26   pg_backup/schemas/s762907/tables/node
        0  2020-02-11 03:26   pg_backup/schemas/s762907/views.sql
     1687  2020-02-11 03:26   pg_backup/schemas/s762907/indexes.sql
     4094  2020-02-11 03:26   pg_backup/schemas/s762907/constraints.sql
---------                     -------
179691617                     32 files

+++

'file_node' looks like a binary blob to me.

>
> Which email format would you like to target? eml (mostly plain text) or mbox?

Anything email, best eml (plain text) can be handled easily.
Either inject manually to a sendmail or dovecot-tool or otherwise.

If we would get this task slowly rolling, I would analyze this in more detail
for the actual product we would use (Mailman, ..).

>
> Personally, I would restore the database with the SQL dump file and use JDBC
> (JPA is probably overkill here).

If possible, sure.
I glanced at the Nabble source code, which has some Export class/tool build in.

Sure, this task sadly would take some time :-/
But gladly it is somewhat possible, reason we always moved it to the future :)

~Sven