I think this is the best way to do it if you want to keep two systems. Whatever machine is running your postgresql DB on can just run an anvil uplink that can only be accessed through a server module that checks credentials before allowing access.
I am guessing you would have to write anvil data table code anyway for CRUD, so again if you want to keep two systems so you have the power of full postgres that is the easiest route imo.
If on the other hand…
You want to follow this idea of going to anvil and never looking back,
I just created this last week, it allows you to load your data from CSV files while picking the anvil column types you would like the data converted to:
It is possible to create linked columns with anvils data tables but others here use that feature much more than I do…