The PostGIS database is remote but I have made changes to the Postgresql config files and can access it remotely via pgadmin.
When I open DBmanager in QGIS I see a note on the bottom that says "postgis:No module named psycopg2." I can't find anyway to connect to the database through the GUI.
I have been able to connect to the database in QGIS using the SPIT plugin, though when I try to import layers it returns the following error: "Problem inserting features from file /path/to/shape/file.shp Invalid table name."
I can get the data from QGIS to the server by ftping the files to the server and then importing them with the shp2pgsql command. I can then download the data back into PostGIS without a problem, so I know the database is working properly.
What I want though is to be able to import QGIS layers to the PostGIS database from within QGIS.
Please forgive my ignorance. I'm learning this stuff as I go. Any clues you can provide will be much appreciated.
I've looked at the answer here: psycopg2 error with QGIS 1.5. I might be missing something, but it didn't help me. That answer explains how to config Windows registry keys, but I'm running QGIS on OSX and the database server is running on Debian (stable), so I don't have registry keys.