I need to transfer db from PostgreSQL 12 to PostgreSQL 9.2.24. I try make backup my db from PostgreSQL 12 and restore on PostgreSQL 9.2.24 but I can't do it because have an error like this:
LINE 1: SELECT pg_catalog.setval('public.schemas_headers_types_id_se...
^
LINE 2: ADD CONSTRAINT user_id PRIMARY KEY (id) INCLUDE (id);
^
Command was: ALTER TABLE ONLY public.users
...
I can't update db version from PostgreSQL 9.2.24 to PostgreSQL 12 because my hosting provider doesn't allow me to do it. How i can't truly transfer my db from PostgreSQL 12 to PostgreSQL 9.2.24?
Copyright Notice:Content Author:「Oleg Ovcharenko」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/61485877/transfer-database-from-postgresql-12-to-postgresql-9-2-24