98 reputation
9
bio website
location
age
visits member for 2 years, 11 months
seen 1 min ago

22h
revised Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
added 424 characters in body
2d
revised Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
added 439 characters in body
Apr
23
revised Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
added 118 characters in body
Apr
23
revised Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
added 928 characters in body
Apr
23
comment Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
Thank you @Paul Ramsey for those hints. I'm adding an update to my question.
Apr
23
asked Can't connect to foreign SQL Server table from PosgreSQL using OGR_FDW
Apr
8
answered QGIS Web Client
Mar
9
awarded  Commentator
Mar
9
comment QGIS Server does not publish PostGIS, Oracle or SQLITE Layer
Have you tried the suggestions in this post? [Connect to PosGIS db using QGIS when not on localhost][1] [1]: gis.stackexchange.com/questions/58446/…
Feb
25
answered QGIS web client email link URL problems on windows
Feb
25
revised QGIS web client email link URL problems on windows
added 314 characters in body
Feb
25
revised QGIS web client email link URL problems on windows
added 872 characters in body
Feb
25
asked QGIS web client email link URL problems on windows
Nov
3
awarded  Popular Question
Oct
23
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?