78 reputation
7
bio website
location
age
visits member for 2 years, 5 months
seen Aug 26 at 12:03

1d
awarded  Curious
Jul
16
awarded  Teacher
Jun
5
comment Can't see Postgis layers added to QGIS
Total frustration. I've now tried this: Old working Postgres 9.2 and PostGIS 2.0.3, created a pg_dump backup of it. Then on a new computer, Postgres 9.2 and PostGIS 2.0.4, I tried the above restore using the batch file, and the data seems to be restored, everything looks fine, except I can't see the layers in QGIS when I connect to the database. What could possibly be going wrong? Any ideas?
Jun
4
comment Can't see Postgis layers added to QGIS
@MichaelMiles-Stimson I've see some references that pg_restore can take a parameter allowing you to use a specific version of pg_restore that is the same version that was used to backup the database. However, I can't figure out how to pass parameters into the postgis_restore.pl file to do that. There seems to be some thought on that here [link] trac.osgeo.org/postgis/ticket/2584 but I can't get it to work, and now that I'm downgrading my postgis that won't work.
Jun
4
comment Can't see Postgis layers added to QGIS
@Julian I have not had a chance to try that. I was hoping to avoid it because I need a way to backup and restore everything without having to do any manual style changes in QGIS after a restore. That may end up being the only way, but I have to believe there's something else causing the problem. I'm working right now to go back to installing PostgreSQL 9.2 instead of 9.3, and trying to install PostGIS 2.0 instead of 2.1, and then doing a restore on that to see if that makes any difference.
May
30
comment Can't see Postgis layers added to QGIS
Sorry, right, it's a relation, not a table. I'm just not sure if this is a problem with QGIS or with PostGIS. I don't understand relations or layers_styles. A while back QGIS had a bug that seem similar (hub.qgis.org/issues/7818), but it appears to have been fixed by the version I'm using. When I restored the database, is it possible somehow it doesn't restore this layer style relation? Or is there some command to tell Postgis to use default layer styles?
May
29
revised Can't see Postgis layers added to QGIS
added 58 characters in body
May
29
asked Can't see Postgis layers added to QGIS
Nov
7
awarded  Popular Question
Oct
12
awarded  Popular Question
Aug
25
awarded  Editor
Aug
25
revised Three table postgres sql join query
added 1155 characters in body
Aug
25
awarded  Scholar
Aug
25
accepted Three table postgres sql join query
Aug
22
asked Three table postgres sql join query
Jul
10
comment Building SQL statement in javascript and casting variables as strings
I'm also having the problem that when my incoming shedId is this: PU2_3900_3750 the browser returns this in the error: pu2_3900_3750. (It doesn't see the capital letters, hence the comparison fails). Maybe this is related to my question above, or at least maybe an answer will solve both problems.
Jul
10
asked Building SQL statement in javascript and casting variables as strings
Jun
5
answered Can't read returned geojson
Jun
5
comment Can't read returned geojson
I think I've made some progess: I was able to parse the returned geojson only after I changed my select statement from: var sql = "select st_asgeojson(the_geom), id, area_sqmi "; to var sql = "select st_asgeojson(ST_Force_2D(the_geom)), id, area_sqmi ";
Jun
5
comment Can't read returned geojson
I've been using the firebug console for a while, but console shows the e.responseText similar to the geojson show above. The console log of features says it's null. I assume the failure to read the responseText is due to the z parameter present?