I have two issues am I am wondering if they are related.
1: I can't get plugins to enable in pgAdmin III I have two PostgreSQL 9.5 instances. In one, the pgAdmin III plugin "PostGIS Shapefile DBF Loader 2.2" works when I highlight my database. In the other instance that plugin menu choice is greyed out. I've been comparing the two instances and I can't figure out what is different. In both cases I am connected to Postgres as a user who is not the owner of the database. PostGIS is installed in both. For the plugin, what are the requirements for it to be active (not greyed out)?
Additional info 3/28/2017: Note: my PostgreSQL is on Linux and my pgAdmin III is on Windows 7. I can successfully run the shapefile loader shp2pgsql-gui.exe found in Program Files> PostgreSQL > 9.5 > bin > postgisgui. I can verify that the shapefile has loaded well by viewing it in QGIS. The PostGIS Shapefile DBF Loader 2.2 and the PSQL Console are both greyed out when I select the database. I am connecting as afreeman which is a superuser. I also tried connecting as enterprisedb which is a superuser and owner of the public schema. My "PG bin path" as seen in Options/Browser/Binary paths is C:/Program Files/PostgreSQL/9.5/bin
2: I can't see a listing of geospatial layers in QGIS My QGIS will connect to one PostGIS instance but not list layers in any schemas. I was able to load shapefiles using the QGIS DBManager into schemas afreeman or public and I can drag those layers into QGIS map and they draw OK. However, choose Layer menu, Add Layer, Add PostGIS layer and connecting to the PostGIS database doesn't list anything. I can do this successfully with a different PostGIS instance. Same version (9.5). One difference though as that in the successful db the public schema is owned by postgres. In the unsuccessful one the public schema is owned by enterprisedb.
Does it matter?
Why would a test by successful but no layers appear?
Additional info 3/28/2017: show search_path; gives me: "$user", public, topology
afreeman is a superuser. I'm running PostGIS 2.1 However, I've also tried connecting as enterprisedb which is the owner of the public schema, same issue with not seeing layers. When I connect as enterprisedb or afreeman and test the connection that is successful. Just no layers in the list. Ran the SQL offered below but no effect. PostGIS is installed in the public schema.