Transfer database from PostgreSQL 12 to PostgreSQL 9.2.24
NickName:Oleg Ovcharenko Ask DateTime:2020-04-29T01:08:05

Transfer database from PostgreSQL 12 to PostgreSQL 9.2.24

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

Answers
jjanes 2020-04-28T17:35:07

You would have to edit the dump to remove the INCLUDE (id) (which is a pretty useless use of the INCLUDE feature anyway, to include the same column twice). But who knows how many following on errors you will find?\n\n\n my hosting provider doesn't allow me to do it\n\n\nSeems like the real solution then is find a different hosting provider.",


More about “Transfer database from PostgreSQL 12 to PostgreSQL 9.2.24” related questions

Transfer database from PostgreSQL 12 to PostgreSQL 9.2.24

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:

Show Detail

How to connect to the database from PostgreSQL 12 instead of PostgreSQL 10

Installed PostgreSQL Version 12.1 in Windows 10 (downloaded from this page) But got two servers, as below: (Why PostgreSQL 10 got installed?) In a .NET C# project the below code auto connects to...

Show Detail

Transfer data from redshift to postgresql

I tried searching for it but couldn't find out What is the best way to copy data from Redshift to Postgresql Database ? using Talend job/any other tool/code ,etc anyhow i want to transfer data f...

Show Detail

About PostgreSQL with Django and CPanel

Django doesn't support earlier version of PostgreSQL, but CPanel doesn't support later version of PostgreSQL, running inspectdb makes faults. Somehow ended up with erased models.py I have Django (v...

Show Detail

clousql postgresql 12 to 14 database upgrade

For PostgreSQL database upgrade on the cloudsql do we have to upgrade from 12 to 13 first and then upgrade to 13 to 14? 12 --> 13 -->14 or directly 12 --> 14 Search postgresql official doc...

Show Detail

how can I transfer multiple tables from postgresql database to csv file using pandas?

I have tried to transfer a table from PostgreSQL to csv with pandas and it was success. But when I tried to transfer multiple tables from a database to csv I am getting errors. please explain how to

Show Detail

Not able to start PostgreSQL

Have a CentOS7 Linux machine running (not managed by me; have limited rights to/in it). Have a request to set PostgreSQL up in it. Just installed PostgreSQL from the CentOS repository: sudo yum

Show Detail

Transfer data from SQL Server to PostgreSQL on Linux

What is the best way to transfer the data from SQL Server database on Windows to a PostgreSQL database on Linux? The current SQL Server database there are about 500,000 rows per table, and about 80

Show Detail

PostgreSQL initialized version 12 incompatible with 11.14

I am on OSX 10.12, Rails 6.0.4, gem 'pg', '>= 0.18', '< 2.0' and have lately noticed issues with postgresql on various apps, that remained frozen for a while. A rails template from Github/Le ...

Show Detail

Postgresql 9.2 error with group by which doesn't appear in postgresql 12

I have a postgresql function with 'GROUP BY' which works fine on my local server (postgresql version is 12.6) but gets the famous error 'column "f.fa_docnum" must appear in the GROUP BY c...

Show Detail