Remote PSQL DB on macOS

[andreknx]

I'm trying to connect to an remote PSQL database with xca on my MacBook (M1, macOS 15.2), but so far no success.

When I open xca and do File -> Open Remote DataBase, I can just select Open Database Connectivity (ODBC). The Documentation says I need to install Postgres.app, which I did but it did not change anything. I tried both installing xca via Homebrew and downloading from https://www.hohnstaedt.de/xca/index.php/download. I also tried getting PSQL to work with ODBC, but no success here either.

What is the recommended way to to connect to a Postgres database in xca on an Apple Silicon Mac?

[chris2511]

XCA expects /Applications/Postgres.app/Contents/Versions/14/lib/libpq.5.dylib

$ otool -L xca-2.8.0.app/Contents/PlugIns/sqldrivers/libqsqlpsql.dylib
xca-2.8.0.app/Contents/PlugIns/sqldrivers/libqsqlpsql.dylib (architecture x86_64):
	/Applications/Postgres.app/Contents/Versions/14/lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.14.0)

xca-2.8.0.app/Contents/PlugIns/sqldrivers/libqsqlpsql.dylib (architecture arm64):
	/Applications/Postgres.app/Contents/Versions/14/lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.14.0)

[andreknx]

Thank you for the quick help. You should probably update the documentation so it states that only version 14 is working. I downloaded the latest version (17) which did not work even though it also includes libpq.5.dylib (I guess the 14 is hardcoded)

[chris2511]

Yes, the 14 is hard coded in the QT SQL driver