DB Manager can't connect to PostgreSQL, but "Add PostGIS Layer" can.
My eventual goal is to save created layers to PostGIS. I assume I can do this using the DBManager Tool. I can alternatively use
shp2pgsql, but I was hoping QGIS would make workflows between shapefiles and PostGIS a bit easier.
This behavior seems odd. Why can it connect one way and not the other?
Side Note: Why does DBManager display my password back to me?
I can connect easily with psql on command line
- This is a local database
- When I originally connected using 'Add PostGIS Layer', I chose not to save the username and password. I am connecting using my OS user account.
- I'm running OS X 10.9.2, PostGIS 2.1, PostgreSQL 9.3.3, and QGIS 2.2.0
- PostgreSQL, PostGIS and QGIS were all installed using Homebrew. See Homebrew install info below.
brew info qgis-22 qgis-22: stable 2.2.0, HEAD http://www.qgis.org /usr/local/Cellar/qgis-22/2.2.0 (14074 files, 493M) * Built from source with: --with-grass, --with-api-docs, --with-postgis From: https://github.com/dakcarto/homebrew-osgeo4mac/commits/master/Formula/qgis-22.rb ==> Dependencies Build: cmake ✔, bison ✔ Required: qt ✔, pyqt ✔, qscintilla2 ✔, qwt ✔, qwtpolar ✔, gsl ✔, sqlite ✔, expat ✔, proj ✔, spatialindex ✔, fcgi ✔, gdal ✔, pyspatialite ✔ Recommended: postgresql ✔, gpsbabel ✔ Optional: postgis ✔, grass ✔, qt-mysql ✘, orfeo ✘, r ✘, saga-gis ✘ brew info postgis postgis: stable 2.1.1, HEAD http://postgis.net /usr/local/Cellar/postgis/2.1.1 (44 files, 8.3M) * Built from source From: https://github.com/Homebrew/homebrew/commits/master/Library/Formula/postgis.rb ==> Dependencies Build: autoconf ✔, automake ✔, libtool ✔, gpp ✔ Required: postgresql ✔, proj ✔, geos ✔, json-c ✔, gdal ✔ brew info postgresql postgresql: stable 9.3.3 (bottled) http://www.postgresql.org/ Conflicts with: postgres-xc /usr/local/Cellar/postgresql/9.3.2 (2968 files, 66M) Poured from bottle /usr/local/Cellar/postgresql/9.3.3 (2967 files, 65M) * Poured from bottle From: https://github.com/Homebrew/homebrew/commits/master/Library/Formula/postgresql.rb ==> Dependencies Required: readline ✔ Recommended: ossp-uuid ✔