RE: Django and PostgreSQL update

[dupakoor kannan]

Hello everyone,

I have a small database. Django version currently 2.2, postgres 9.2.24. I forgot to note the psycopg2 older version. It was working fine. I have updated django to 2.2.26 and psycopg2==2.8.3. Also, I made changes in my model and migrated. I come across this error during migration.

psycopg2.errors.SyntaxError: syntax error at or near "WITH ORDINALITY"

I searched google and found this post https://stackoverflow.com/questions/61774741/psycopg2-errors-syntaxerror-syntax-error-at-or-near-on it suggests to upgrade the postgres version also. My question is

1) If I upgrade the postgres in the server will it affect data (other databases) in the postgres. I don't want to lose other databases. Any suggestions?

Thanks

Kannan

[Oussama Ben Rejeb]

u can do a data dump before, but i think that there is no problem to update it