PostgreSQL DBMS

[Thomas Arnbjerg]

I'm trying to configure a PostgreSQL repository.

1) 32 bit ODBC driver is installed (version 13.x)
2) ODBC datasource configured according to https://sparxsystems.com/enterprise_architect_user_guide/15.2/model_repositories/setupapostgresqlodbcdriver.html
Test connection succeeds.
3) The PostgreSQL database has been created on a remote Debian 11 and EASchema*.sql has been run. The tables are present in the database as seen in pgAdmin running on the same machine as EA. A user has been created for EA and permissions on all EA tables look correct in pgAdmin.

When I try to transfer an eapx file to the new repository i get the error 'All Enterprise architect tables in the target repository are missing...'

Any suggestions on how to troubleshoot this?
Thx
Thomas

[qwerty]

Maybe some authorization issue (just guessing). Try accessing the DB as admin.

q.

[Thomas Arnbjerg]

Found the root cause 40 cm in front of the screen. I used the wrong version of the schema file.

[Geert Bellekens]

Found the root cause 40 cm in front of the screen. I used the wrong version of the schema file.

Ah, the famous PEBCAC problem 

Geert