Re: [DebianGIS] postgis tests
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
>
Reply to: