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

[Max Pyziur]

No sooner than having composed this message, then I found the problem.

I still needed to install python-psycog* rpms.

Doing that and restarting QGIS got DB Manager to function correctly.

Max Pyziur
pyz at brama.com


On Mon, 4 Feb 2013, Max Pyziur wrote:

> 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
>