I followed this post:pgRouting 2.0 for Windows quick guide, and I want to use DB manager to load the test data into my PostgreSQL database.
I used url to get the test data:
I have set up the connection to my PostgreSQL 9.2, like this:
and the connection is fine, but as I fire up my DB manager, trying to connect to PostGIS, I got those errors:(errors got as I double clicked "PostgreSQL 9.2")
執行Python程式碼時發生錯誤:
Traceback (most recent call last): File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_model.py", line 404, in rowCount self._refreshIndex( parent, True ) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_model.py", line 456, in _refreshIndex if item.populate(): File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_model.py", line 151, in populate if not connection.connect(): File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\plugin.py", line 100, in connect return self.connectToUri(uri) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\plugin.py", line 93, in connectToUri self.db = self.databasesFactory( self, uri ) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\plugin.py", line 67, in databasesFactory return PGDatabase(connection, uri) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\plugin.py", line 134, in init Database.init(self, connection, uri) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\plugin.py", line 172, in init self.connector = self.connectorsFactory( uri ) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\plugin.py", line 137, in connectorsFactory return PostGisDBConnector(uri) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\connector.py", line 57, in init raise ConnectionError(e) File "C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\db_manager\db_plugins\plugin.py", line 40, in init msg = unicode( msg, 'utf-8' ) UnicodeDecodeError: 'utf8' codec can't decode byte 0xc4 in position 0: invalid continuation byte
Python 版本: 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)]
QGIS 版本: 2.0.1-Dufour Dufour, d94c044
Python 路徑: ['C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins\processing', 'C:/PROGRA~1/QGISDU~1/apps/qgis/./python', 'C:\Users\Heinz/.qgis2/python', 'C:\Users\Heinz/.qgis2/python/plugins', 'C:/PROGRA~1/QGISDU~1/apps/qgis/./python/plugins', 'C:\PROGRA~1\QGISDU~1\bin\python27.zip', 'C:\PROGRA~1\QGISDU~1\apps\Python27\DLLs', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\plat-win', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\lib-tk', 'C:\PROGRA~1\QGISDU~1\bin', 'C:\PROGRA~1\QGISDU~1\apps\Python27', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\PIL', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\win32', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\win32\lib', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\Pythonwin', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\Shapely-1.2.18-py2.7-win-amd64.egg', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\six-1.3.0-py2.7.egg', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\wx-2.8-msw-unicode', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\xlrd-0.9.2-py2.7.egg', 'C:\PROGRA~1\QGISDU~1\apps\Python27\lib\site-packages\xlwt-0.7.5-py2.7.egg', 'C:\PROGRA~1\QGISDU~1\apps\qgis\python\plugins\fTools\tools']
Did I make some mistake in my process?
I am working under Windows 8.1, QGIS 2.0, PostgreSQL 9.2