[Qgis-user] DB Manager - setting up a PostGIS connection, building SQL queries

[Max Pyziur]

Greetings,

I've been using Q-GIS for under a year. My first system was built on
Fedora 17, Postgresql 9.1.x, PostGIS 1.5.x, and Q-GIS Lisboa (1.8.x). It
was on Dell Inspiron 600m, a machine that was reliable, but somewhat slow.

I've acquired a Dell D630 Latitude laptop w/ a dual-core processor. The
software is a fresh install of Fedora 18; the technology stack starts w/
Postgresql 9.2.2.

Postgresql 9.2.x will not work with  releases of PostGIS prior to 2.0;
Fedora 18 did not ship w/ PostGIS 2.0, but rather 1.5.3. PostGIS
2.0-related RPMs are pending approval for release.

So, it's taken a while to migrate the large amount of spatial data that
I've acquired and built in a short span of time.

Today's success was upgrading the PostGIS data from 1.5.3 to 2.0.
According to the PostGIS documentation this requires a "hard upgrade," and
the postgis_restore.pl script is indispensable for this process.

All data is now visible using Postgresql's psql monitor.

The current set of tasks relate to making Q-GIS connect properly to
PostgreSQL/PostGIS. Loading an old project that functioned correctly on
the F17 Dell Inspiron 600M is not problem. It functions as it should and
(obviously) loads much more quickly.

Using DB Manager to connect to a PostGIS-enabled database is not possible
(so far). I've done the following from the menus:
View -> Add PostGIS layer and have successfully added a new PostGIS
connection. However, that connection is not visible when using DB Manager,
and produces the following error:
An error has occured while executing Python code:

Traceback (most recent call last):
  File "/usr/share/qgis/python/plugins/db_manager/db_manager.py", line 68,
in displayDbPluginErrors
    self.statusBar.showMessage( msg, 5000 )
RuntimeError: wrapped C/C++ object of type QStatusBar has been deleted

Python version:
2.7.3 (default, Aug  9 2012, 17:23:57)
[GCC 4.7.1 20120720 (Red Hat 4.7.1-5)]


QGIS version:
1.8.0-Lisboa Lisboa, exported

Python path: ['/usr/share/qgis/python', '/home/pyz/.qgis//python',
'/home/pyz/.qgis//python/plugins', '/usr/share/qgis/python/plugins',
'/usr/lib64/python27.zip', '/usr/lib64/python2.7',
'/usr/lib64/python2.7/plat-linux2', '/usr/lib64/python2.7/lib-tk',
'/usr/lib64/python2.7/lib-old', '/usr/lib64/python2.7/lib-dynload',
'/usr/lib64/python2.7/site-packages',
'/usr/lib64/python2.7/site-packages/PIL',
'/usr/lib64/python2.7/site-packages/geos',
'/usr/lib64/python2.7/site-packages/gtk-2.0',
'/usr/lib64/python2.7/site-packages/wx-2.8-gtk2-unicode',
'/usr/lib/python2.7/site-packages',
'/usr/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info',
'/usr/share/qgis/python/plugins/fTools/tools',
'/home/pyz/projects/PostGIS/Railroads']


Any help in correcting this would be greatly appreciated.

Much thanks,

Max Pyziur
pyz at brama.com