Hi, If you want the nightlies ( which I don't recommend for production) you should be using these (and only these)
deb http://qgis.org/ubuntugis-nightly precise main deb-src http://qgis.org/ubuntugis-nightly precise main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu precise main For a more stable, but still recent, use ubuntugis-unstable (only) < remove other repos, and remove anything related to qgis (including gdal) sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable sudo apt-get update sudo apt-get install qgis On Wed, Aug 29, 2012 at 5:25 PM, Brian Fitzgerald <bkf...@gmail.com> wrote: > Scratch previous email... I just went to QGIS -> about and found that QGIS > is "Compiled against GDAL/OGR 1.7.3" even though I installed the 1.9 GDAL > libaries before I install QGIS. Now what? > > > > > > > On Wed, Aug 29, 2012 at 4:22 PM, Brian Fitzgerald <bkf...@gmail.com> wrote: >> >> How do I figure out what version of GDAL my QGIS is using... I reinstalled >> everything (QGIS nightlies, gdal from the unstable-gis ppas, postgres and >> postgis) and am running into the same problem. I checked in Synaptic and >> see both 1.7 and 1.9 gdal libraries installed. >> >> Thx for all your help! >> >> - Brian >> >> >> >> >> On Tue, Aug 28, 2012 at 3:29 PM, Mauricio de Paulo >> <mauricio....@gmail.com> wrote: >>> >>> Hi, Brian and Etienne. >>> Well, GDAL 1.7.3 was one of the first efforts to read postgis raster, >>> back in the release candidate days. A few months before the release of >>> postgis 2.0 there was a major change in the raster storage and some code was >>> discontinued. GDAL 1.9.0 was the first release after postgis 2.0 was >>> released so it's the first version that is compatible. >>> >>> Fortunately, vector data is a mature standard inside postgis and didn't >>> suffer any major changes that could break previous working code. >>> >>> Even though we were all notified by these changes, some of our previous >>> work doesn't work with the current version. It was a huge improvement in >>> raster storage and metadata retrieval, so we have to cope with it. >>> >>> I'm releasing the new plugin version with the weak loader tonight. It >>> should be enough to upload one untiled raster with no overviews to the >>> database. >>> >>> I'm using ubuntugis' repositories. The gdal package available on it is >>> version 1.9.1 so you might want to try those binaries, since they work >>> pretty well. >>> >>> All the best, >>> >>> Mauricio C. M. de Paulo >>> Engenheiro Cartógrafo >>> Mestrando em Sensoriamento Remoto (INPE) >>> >>> On 08/28/2012 04:17 PM, Brian Fitzgerald wrote: >>> >>> I'm showing GDAL version 1.7.3-6 in Synaptic... so that could be my >>> problem... but wouldn't I also be experiencing loading postgis 2.0 vectors? >>> >>> - Brian >>> >>> On Tue, Aug 28, 2012 at 3:01 PM, Mauricio de Paulo >>> <mauricio....@gmail.com> wrote: >>>> >>>> Hi Brian, >>>> I downloaded the sample data and imported to my database and it seems to >>>> work pretty well. I'm using QGIS 1.8, postgis 2.0, postgres 9.1.5, gdal >>>> 1.9.1 on ubuntu 12.04. >>>> >>>> Sorry for my ignorance but what GDAL version is being released with >>>> linux mint? I couldn't find anywhere online. >>>> >>>> The plugin heavily relies on GDAL to perform the visualization so you >>>> need the latest GDAL available to get a decent performance. >>>> >>>> From my first tests I can say that GDAL 1.9.1 has greatly improved >>>> performance and the next versions should improve even further. The fastest >>>> visualization that I have achieved with version 1.9.1 is with single tiled >>>> raster files. Unfortunately I wasn't able to get GDAL to use overviews so >>>> far, but Jorge (GDAL's postgis raster developper) is researching on this >>>> subject. >>>> >>>> GDAL versions bellow 1.9 should not be able to read postgis 2.0. >>>> >>>> Unfortunately, since postgis 2.0 release, the python loader was >>>> discontinued in postgis source. Recently I have started to make the >>>> necessary changes starting from the old code to get it to work. I don't >>>> know >>>> if this is going to be a good solution but it seems possible. I'm trying to >>>> avoid the platform-dependent compilation that postgis' raster loader has in >>>> version 2.0 now that it's being entirely written in C. In the future I >>>> should probably release a simple uploader with the plugin, without all >>>> those >>>> options until I'm certain that everything is working according to the >>>> standard. >>>> >>>> I'm copying this mail to the list to allow other users to find this >>>> thread later. >>>> >>>> Mauricio C. M. de Paulo >>>> Engenheiro Cartógrafo >>>> Mestrando em Sensoriamento Remoto (INPE) >>>> >>>> On 08/28/2012 03:56 PM, Brian Fitzgerald wrote: >>>> >>>> PS - Im also unable to "load" raster data into PostGIS using the >>>> plugin... the icon is greyed out for some reason. >>>> >>>> - Brian >>>> >>>> >>>> >>>> >>>> On Tue, Aug 28, 2012 at 2:20 PM, Brian Fitzgerald <bkf...@gmail.com> >>>> wrote: >>>>> >>>>> Sure. >>>>> >>>>> I'm running Ubuntu Mint 13 Cinnamon with Postgres 1.9.5, Postgis 2.0. >>>>> and QGIS 1.9.0 >>>>> >>>>> I followed this install tutorial: >>>>> >>>>> http://linfiniti.com/2012/05/installing-postgis-2-0-on-ubuntu/ >>>>> >>>>> I loaded the sample vector shapefile into my new 'training' database >>>>> and opened it in QGIS with no problem. >>>>> >>>>> I loaded the sample raster data using the command in the tutorial, it >>>>> loaded with no problems. I ran the test query in the tutorial, no >>>>> problem. >>>>> I went into QGIS to load the raster and got an error that referred to some >>>>> missing python dependencies (i think it was the python-psycopg libs)... >>>>> so I >>>>> went to Synaptic and loaded the following: >>>>> >>>>> Installed the following packages: >>>>> libjs-sphinxdoc (1.1.3+dfsg-2ubuntu2.1) >>>>> libjs-underscore (1.1.6-1ubuntu2) >>>>> python-dbg (2.7.3-0ubuntu2) >>>>> python-psycopg2 (2.4.5-1) >>>>> python-psycopg2-dbg (2.4.5-1) >>>>> python-psycopg2-doc (2.4.5-1) >>>>> python2.7-dbg (2.7.3-0ubuntu3.1) >>>>> python3 (3.2.3-0ubuntu1) >>>>> python3-dbg (3.2.3-0ubuntu1) >>>>> python3-minimal (3.2.3-0ubuntu1) >>>>> python3-psycopg2 (2.4.5-1) >>>>> python3-psycopg2-dbg (2.4.5-1) >>>>> python3.2 (3.2.3-0ubuntu3) >>>>> python3.2-dbg (3.2.3-0ubuntu3) >>>>> python3.2-minimal (3.2.3-0ubuntu3) >>>>> >>>>> I then came back to QGIS to open the raster and no longer get the >>>>> python error... this time it brings up the "Load PostGIS Raster Layer" >>>>> just >>>>> fine and displays my sample raster. I click on the raster name in the >>>>> table >>>>> and it puts it down in the "Table Name" input box. I then click on OK and >>>>> get a window that pops up saying "Could Not Load Layer". I click ok to >>>>> this >>>>> and another window comes up that says: "Could not load PG: >>>>> dbname=training >>>>> host=localhost user=postgres password=xxxxxx port=5432 schema=public >>>>> table=srtm_4326 mode=2". When I click ok to this, the window diappears >>>>> and >>>>> nothing happens. >>>>> >>>>> I also tried one of our ortho geotiffs using the following command and >>>>> get the same results: >>>>> >>>>> postgres@minty /home/rcgeoadmin/Temp $ raster2pgsql -s 4326 >>>>> /home/rcgeoadmin/Temp/979903.tif | psql training >>>>> Processing 1/1: /home/rcgeoadmin/Temp/979903.tif >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> Warning 1: TIFFReadDirectory:Unknown field with tag 33919 (0x847f) >>>>> encountered >>>>> BEGIN >>>>> NOTICE: CREATE TABLE will create implicit sequence "979903_rid_seq" >>>>> for serial column "979903.rid" >>>>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>>>> "979903_pkey" for table "979903" >>>>> CREATE TABLE >>>>> INSERT 0 1 >>>>> COMMIT >>>>> >>>>> >>>>> - Brian >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Aug 28, 2012 at 8:24 AM, Mauricio de Paulo >>>>> <mauricio....@gmail.com> wrote: >>>>>> >>>>>> Hi, Brian. >>>>>> Could you please elaborate a little more about what were you trying to >>>>>> do and what raster configuration you were using? Is it tiled or untiled? >>>>>> One >>>>>> single raster file in the table? Did you build overviews? >>>>>> All the best, >>>>>> >>>>>> Mauricio C. M. de Paulo >>>>>> >>>>>> On 08/27/2012 07:00 PM, Brian Fitzgerald wrote: >>>>>> >>>>>> ---------- Forwarded message ---------- >>>>>> From: "Brian Fitzgerald" <bkf...@gmail.com> >>>>>> Date: Aug 27, 2012 4:57 PM >>>>>> Subject: wktraster with Postgis 2.0 in QGIS 1.9 on Linux Mint Maya >>>>>> To: <wonder...@gmail.com> >>>>>> >>>>>> I'm having problems loading a Postgis 2.0 raster layer into QGIS 1.9 >>>>>> using your wktraster extension. >>>>>> >>>>>> The menu comes up, but I get a "could not load layer" >>>>>> >>>>>> Then a window that says: >>>>>> >>>>>> "Could not load PG: dbname=training host=localhost user=postgres >>>>>> password=topology4 port=5432 table= mode=2" >>>>>> >>>>>> Any ideas? >>>>>> >>>>>> -- >>>>>> -------------------------------------- >>>>>> Brian Fitzgerald, PMP, GISP >>>>>> bkf...@gmail.com >>>>>> 803.426.3469 >>>>>> --------------------------------------- >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -------------------------------------- >>>>> Brian Fitzgerald, PMP, GISP >>>>> bkf...@gmail.com >>>>> 803.426.3469 >>>>> --------------------------------------- >>>> >>>> >>>> >>>> >>>> -- >>>> -------------------------------------- >>>> Brian Fitzgerald, PMP, GISP >>>> bkf...@gmail.com >>>> 803.426.3469 >>>> --------------------------------------- >>>> >>>> >>> >>> >>> >>> -- >>> -------------------------------------- >>> Brian Fitzgerald, PMP, GISP >>> bkf...@gmail.com >>> 803.426.3469 >>> --------------------------------------- >>> >>> >> >> >> >> -- >> -------------------------------------- >> Brian Fitzgerald, PMP, GISP >> bkf...@gmail.com >> 803.426.3469 >> --------------------------------------- > > > > > -- > -------------------------------------- > Brian Fitzgerald, PMP, GISP > bkf...@gmail.com > 803.426.3469 > --------------------------------------- _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user