Re: [DebianGIS] postgis tests
not exactly.
first of all, i urge you to use the files i've sent you this morning
Jon Saints wrote:
> Here are the steps I used to build and install the new
> postgis1-8.0. Perhaps by comparing what we are doing
> differently we can diagnose some of the remaining
> errors.
>
> Steps:
> 1) make a directory called postgis in my
> ~/debianGIS_dev folder
> 2) wget
> http://postgis.refractions.net/download/postgis-1.0.4.tar.gz
> 3) extract postgis-1.0.4.tar.gz and rename the folder
> to postgis-1.0.0
> 4) enter the postgis-1.0.0 directory
> 5) apply alex's latest patch with command: zcat
> /PATH_TO_PATCH/postgis_1.0.4_1.diff.gz | patch -p1;
> chmod ug+x debian/rules
> 6) run dpkg-buildpackage -rfakeroot -uc -b
> 7) run sudo dpkg -i
> ../libpostgis1-common_1.0.4-1_i386.deb
> ../libpostgis1-pg8.0_1.0.4-1_i386.deb
> 8) run /usr/lib/postgresql/8.0/bin/mktemplate_gis
> --user=jsaints
> 9) createdb DBNAME
> 10) createlang plpgsql aztaca
> 11) load the directory of Mapserver Workshop data;
>>From the workshop/data directory run: for file in `ls
> *.shp`; do /usr/lib/postgresql/8.0/bin/shp2pgsql -I
> $file ${file%.*} | psql -d DBNAME; done
>
> Just wanted to be sure all of us have the same frame
> of reference for debugging.
> Jon
>
> --- Paolo Cavallini <cavallini@faunalia.it> wrote:
>
>
>>The new 8.0 package does not install:
>>===
>>Configuro libpostgis1-pg8.0 (1.0.4-1) ...
>>either postgres is not a dba, or you cannot sudo -u
>>postgres
>>dpkg: errore processando libpostgis1-pg8.0
>>(--install):
>>===
>>removing the old one and reinstalling does not solve
>>the problem.
>>reinstalling the previous 1.0.4-1 is ok.
>>pc
>>
>>At 09:51, venerdì 07 ottobre 2005, Jon Saints has
>>probably written:
>>
>>>With this new patch, I am able to build and
>>
>>install
>>
>>>libpostgis1-pg8.0 without error. Thank you Alex.
>>>
>>>Here is my update on what I have found reguarding
>>>mktemplate_gis:
>>>
>>>After install, the file is located in the folder
>>>/usr/lib/postgresql/8.0/bin. When I run the
>>
>>command
>>
>>>with my user name --user=jsaints I get the
>>
>>following
>>
>>>errors:
>>>
>>>
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:30:
>
>>>NOTICE: type "histogram2d" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:35:
>
>>>NOTICE: argument type histogram2d is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:53:
>
>>>NOTICE: type "spheroid" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:58:
>
>>>NOTICE: argument type spheroid is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:75:
>
>>>NOTICE: type "geometry" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:80:
>
>>>NOTICE: argument type geometry is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:90:
>
>>>NOTICE: return type geometry is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:95:
>
>>>NOTICE: argument type geometry is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:118:
>
>>>NOTICE: type "box3d" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:123:
>
>>>NOTICE: argument type box3d is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:170:
>
>>>NOTICE: type "chip" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:175:
>
>>>NOTICE: argument type chip is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:194:
>
>>>NOTICE: type "box2d" is not yet defined
>>>DETAIL: Creating a shell type definition.
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:199:
>
>>>NOTICE: argument type box2d is only a shell
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:1689:
>
>>>NOTICE: CREATE TABLE / PRIMARY KEY will create
>>>implicit index "spatial_ref_sys_pkey" for table
>>>"spatial_ref_sys"
>>>
>>
> psql:/usr/share/postgresql/8.0/contrib/lwpostgis.sql:1707:
>
>>>NOTICE: CREATE TABLE / PRIMARY KEY will create
>>>implicit index "geometry_columns_pk" for table
>>>"geometry_columns"
>>>ERROR: VACUUM FULL FREEZE is not supported
>>>HINT: Use VACUUM FULL, then VACUUM FREEZE.
>>>
>>>The last error should be easy to fix.
>>>Thanks
>>>Jon
>>>
>>>--- alex bodnaru <alexbodn@012.net.il> wrote:
>>>
>>>>please have it:
>>>>
>>>>Jon Saints wrote:
>>>>
>>>>>>From source, I can build the new postgis
>>
>>package
>>
>>>>just
>>>>
>>>>
>>>>>fine.
>>>>>
>>>>>On install I get this error:
>>>>>Setting up libpostgis1-pg8.0 (1.0.4-1) ...
>>>>>ln:
>>>
>>>
> `/usr/share/postgresql/8.0/contrib/spatial_ref_sys.sql':
>
>>>>>File exists
>>>>>dpkg: error processing libpostgis1-pg8.0
>>>>
>>>>(--install):
>>>>
>>>>> subprocess post-installation script returned
>>>>
>>>>error
>>>>
>>>>
>>>>>exit status 1
>>>>>Errors were encountered while processing:
>>>>> libpostgis1-pg8.0
>>>>>
>>>>>Havent been able to track it down yet. Also I
>>
>>am
>>
>>>>still
>>>>
>>>>
>>>>>looking into the mktemplate_gis failures.
>>>>>
>>>>>Jon
>>>>>
>>>>>--- Paolo Cavallini <cavallini@faunalia.it>
>>
>>wrote:
>>
>>>>>>Hi all.
>>>>>>Importing a shapefile into pg80 with shp2pgsql
>>
>>was
>>
>>>>>>successful.
>>>>>>Troubles installing the new postgis packages
>>
>>on a
>>
>>>>>>pg74+pgis1 installation,
>>>>>>because of conflicts with the previous
>>>>>>libpostgis1-pg74 (the msgs are in
>>>>>>Italian, but I think they're easy to
>>
>>understand).
>>
>>>>>>All the best.
>>>>>>pc
>>>>>>===================
>>>>>>Selezionato il pacchetto libpostgis1-common,
>>
>>che
>>
>>>>non
>>>>
>>>>
>>>>>>lo era.
>>>>>>(Lettura del database ... 167055 file e
>>
>>directory
>>
>>>>>>attualmente installati.)
>>>>>>Spacchetto libpostgis1-common (da
>>>>>>libpostgis1-common_1.0.4-1_i386.deb) ...
>>>>>>dpkg: errore processando
>>>>>>libpostgis1-common_1.0.4-1_i386.deb
>>
>>(--install):
>>
>>>>>>tentata sovrascrittura di
>>>>>>`/usr/share/man/man1/createdb.postgis.1.gz',
>>
>>che
>>
>>>>si
>>>>
>>>>
>>>>>>trova anche nel pacchetto libpostgis1-pg74
>>>>>>Selezionato il pacchetto libpostgis1-pg7.4,
>>
>>che
>>
>>>>non
>>>>
>>>>
>>>>>>lo era.
>>>>>>Spacchetto libpostgis1-pg7.4 (da
>>>>>>libpostgis1-pg7.4_1.0.4-1_i386.deb) ...
>>>>>>dpkg: problemi con le dipendenze impediscono
>>
>>la
>>
>>>>>>configurazione di
>>>>>>libpostgis1-pg7.4:
>>>>>>libpostgis1-pg7.4 dipende da
>>
>>libpostgis1-common
>>
>>>>(=
>>>>
>>>>
>>>>>>1.0.4-1); comunque:
>>>>>> Il pacchetto libpostgis1-common non è
>>>>
>>>>installato.
>>>>
>>>>
>>>>>>libpostgis1-pg7.4 dipende da postgresql-7.4;
>>>>>>comunque:
>>>>>> Il pacchetto postgresql-7.4 non è
>>
>>installato.
>>
>>>>>>libpostgis1-pg7.4 dipende da
>>>>>>postgresql-contrib-7.4; comunque:
>>>>>> Il pacchetto postgresql-contrib-7.4 non è
>>>>>>installato.
>>>>>>dpkg: errore processando libpostgis1-pg7.4
>>>>>>(--install):
>>>>>>problemi con le dipendenze - lasciato non
>>>>>>configurato
>>>>>>Sono occorsi degli errori processando:
>>>>>>libpostgis1-common_1.0.4-1_i386.deb
>>>>>>libpostgis1-pg7.4
>>>>>>
>>>>>>--
>>>>>>Paolo Cavallini
>>>>>>cavallini@faunalia.it cavallini@jabber.org
>>>>>>www.faunalia.it
>>>>>>Piazza Garibaldi 5 - 56025 Pontedera (PI),
>>
>>Italy
>>
>>>>>>Tel: (+39)348-3801953
>>>>>>
>>>>
>>>>_______________________________________________
>>>>
>>>>>>Pkg-grass-general mailing list
>>>>>>Pkg-grass-general@lists.alioth.debian.org
>>>
>>>
> http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-general
>
>>_______________________________________________
>>
>>>>>Pkg-grass-general mailing list
>>>>>Pkg-grass-general@lists.alioth.debian.org
>>>
>>>
> http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-general
>
>>>
>>>
>>>
>>>_______________________________________________
>>>Pkg-grass-general mailing list
>>>Pkg-grass-general@lists.alioth.debian.org
>>>
>>
> http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-general
>
>>--
>>Paolo Cavallini
>>cavallini@faunalia.it cavallini@jabber.org
>>www.faunalia.it
>>Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy
>>Tel: (+39)348-3801953
>>
>
>
>
> _______________________________________________
> Pkg-grass-general mailing list
> Pkg-grass-general@lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-general
>
Reply to: