Restore Nabble Archive - PostgreSQL

[NotGael]

Hi guys,

I'm looking for a way to restore my downloaded Nabble Archive into a local postgres database.
But the export doesn't contain any XML like explained in the help section : Can I export my forum to a standard format?
Instead the archive contains SQL files for the shemas, views, sequences, indexes, tables and constraints.
(Thats the part I'm totally OK with)
But all tables are saved as binary files that I failed to get data from.

Can you enlight me on how to properly read these files. For me to be able to export them in postgres
pg_restore hasn't worked for me.

Thanks

Gaël

[Israel <Nabble>]

What we can do is to move your forum to our server but you should get rid of the spammers.
When we deleted the forum it was dominated by spammers.

[NotGael]

I don't really know about the spammers or understand what you are talking about.

It's the my first time here and with the nabble service. I work for a company that is actually using your services ton archive a big Mail List.

We don't desire to realocate our server because the server is hosted and working for the moment.
We just want to get all the data in a format we can use for a future migration into another postgreSQL database. And I haven't found how to import the data from the binary files yet. Can you explain me how to do it or can you give me a hint on the method you have used to export the data.

Gaël

[NotGael]

Found the solution

Using pgsql command copy in binary this was bugging on pgAdmin 4 the soft wasn't using the BINARY option as I selected. And default option was text. But using the terminal and the right option everything is working.

copy public.table_name (table_column_1_name, table_column_2_name, ....) FROM '/your_path/backup/schemas/schema_name/tables/table_name' BINARY;