SET5 set_config ------------ (1 row) SET4 CREATE TABLE ERROR: syntax error at or near "AS" LINE 2: AS integer ^ Import error: exit status 3

Asked Feb 26 '19 at 03:56

Active Feb 26 '19 at 04:17

Viewed 83 times

I have been trying to import .sql file created from pg_dump into google's cloudsql. But I keep getting this error message:

 SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET CREATE TABLE ERROR: syntax error at or near "AS" LINE 2: AS integer ^ Import error: exit status 3

Before this problem, I got stuck at EXTENSION COMMENT issue, so I did pg_dump -U [USERNAME] --format=plain --no-owner --no-acl [DATABASE_NAME] \ | sed -E 's/(DROP|CREATE|COMMENT ON) EXTENSION/-- \1 EXTENSION/g' > [SQL_FILE].sql as Google's documentation recommends.

Any suggestion?

edited Feb 26 '19 at 04:17

asked Feb 26 '19 at 03:56

7029279

You are trying to restore a dump from v10 or later into an older version of PostgreSQL. – Laurenz Albe Feb 26 '19 at 04:49
Oh, yes, that's exactly the issue. Thank you so much for your help. – 7029279 Feb 26 '19 at 04:51
Laurenz Albe, if you are kind enough, is there any way to install the older version of postgres sq without breaking dependencies? – 7029279 Feb 26 '19 at 04:58
You'd have to ask Google if they are offering older versions. But why don't you upgrade the database before migrating it? – Laurenz Albe Feb 26 '19 at 05:24

SET*5 set_config ------------ (1 row) SET*4 CREATE TABLE ERROR: syntax error at or near "AS" LINE 2: AS integer ^ Import error: exit status 3

0 Answers0

SET5 set_config ------------ (1 row) SET4 CREATE TABLE ERROR: syntax error at or near "AS" LINE 2: AS integer ^ Import error: exit status 3