Re: Restore Nabble Archive - PostgreSQL

Posted by NotGael on Sep 14, 2021; 12:30pm
URL: https://support.nabble.com/Restore-Nabble-Archive-PostgreSQL-tp7611741p7611753.html

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;