[postgis-users] Postgis Installation Error

Wed Apr 6 16:09:33 PDT 2011

On Wed, Apr 6, 2011 at 10:02 PM, vikashvikky <vikashtalanki at gmail.com> wrote:
>
> Hi frnds,
>
>      I am using fedora machine. I want to install postgis on my system. So
> this is what I have done
>
> 1. Installed Postgresql and supporting packages using YUM.
> 2. Created directory /sources to put all the necessary packages for postgis.
> 3. successfully installed geos,libxml & proj using ./config,make,make
> install.
> 4. successfull in make & make install of postgis. But when I give "make
> check" I am getting the following error(I have alreasy started the postgres
> server):
>
> [root at localhost sources]# cd postgis/
> [root at localhost postgis]# ls
> postgis-1.5.0SVN  postgis-1.5.0SVN.tar.gz
> [root at localhost postgis]# cd postgis-1.5.0SVN
> [root at localhost postgis-1.5.0SVN]# make check
> make -C liblwgeom
> make[1]: Entering directory `/sources/postgis/postgis-1.5.0SVN/liblwgeom'
> make[1]: Nothing to be done for `all'.
> make[1]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/liblwgeom'
> make -C postgis
> make[1]: Entering directory `/sources/postgis/postgis-1.5.0SVN/postgis'
> Makefile.pgxs:17: warning: overriding recipe for target `install'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:92: warning: ignoring old recipe
> for target `install'
> Makefile.pgxs:63: warning: overriding recipe for target `installdirs'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:140: warning: ignoring old recipe
> for target `installdirs'
> Makefile.pgxs:82: warning: overriding recipe for target `uninstall'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:164: warning: ignoring old recipe
> for target `uninstall'
> make[1]: Nothing to be done for `all'.
> make[1]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/postgis'
> make -C liblwgeom/cunit check
> make[1]: Entering directory
> `/sources/postgis/postgis-1.5.0SVN/liblwgeom/cunit'
>
> WARNING:
>
> configure was unable to find CUnit which is required for unit testing.
> In order to enable unit testing, you must install CUnit and then re-run
> configure.
>
> make[1]: Leaving directory
> `/sources/postgis/postgis-1.5.0SVN/liblwgeom/cunit'
> make -C regress check
> make[1]: Entering directory `/sources/postgis/postgis-1.5.0SVN/regress'
> make -C ../postgis REGRESS=1
> DESTDIR=/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install install
> make[2]: Entering directory `/sources/postgis/postgis-1.5.0SVN/postgis'
> Makefile.pgxs:17: warning: overriding recipe for target `install'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:92: warning: ignoring old recipe
> for target `install'
> Makefile.pgxs:63: warning: overriding recipe for target `installdirs'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:140: warning: ignoring old recipe
> for target `installdirs'
> Makefile.pgxs:82: warning: overriding recipe for target `uninstall'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:164: warning: ignoring old recipe
> for target `uninstall'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/mkinstalldirs
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/lib'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 755
> postgis-1.5.so
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/lib/postgis-1.5.so'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> ./../spatial_ref_sys.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> postgis.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> uninstall_postgis.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> postgis_upgrade_15_minor.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> postgis_upgrade_14_to_15.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644
> postgis_upgrade_13_to_15.sql
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/share/contrib/postgis-1.5'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 755
> postgis-1.5.so
> '/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/lib/postgis-1.5.so'
> make[2]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/postgis'
> make -C ../loader REGRESS=1
> DESTDIR=/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install install
> make[2]: Entering directory `/sources/postgis/postgis-1.5.0SVN/loader'
> Makefile:108: warning: overriding recipe for target `clean'
> /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk:211: warning: ignoring old recipe
> for target `clean'
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c
> pgsql2shp /sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/bin
> /bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c
> shp2pgsql /sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/bin
> make[2]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/loader'
> sed
> 's,$libdir,/sources/postgis/postgis-1.5.0SVN/regress/00-regress-install/lib,g'
> ../postgis/postgis.sql > postgis.sql
> psql: could not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> Creating spatial db postgis_reg
> createdb: could not connect to database postgres: could not connect to
> server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createlang: could not connect to database postgis_reg: could not connect to
> server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> psql: could not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> dropdb: could not connect to database postgres: could not connect to server:
> No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
>  Something went wrong (no postgis installed in postgis_reg).
>  For details, check /tmp/pgis_reg_5204/regress_log
>
> make[1]: *** [check] Error 1
> make[1]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/regress'
> make: *** [check] Error 2
>
> 6. Even with the error, i continued to create template_postgis db from
> postgresql shell:
>  On giving the command: psql template_postgis -U postgres
> postgis/postgis.sql I am getting the folowing error:
>
>
> psql:postgis/postgis.sql:6859: NOTICE:  type "geography" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis/postgis.sql:6865: NOTICE:  argument type geography is only a
> shell
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE TYPE
> psql:postgis/postgis.sql:6893: NOTICE:  type "gidx" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis/postgis.sql:6899: NOTICE:  argument type gidx is only a shell
> CREATE FUNCTION
> psql:postgis/postgis.sql:7744: NOTICE:  aggregate geomunion(geometry) does
> not exist, skipping
> DROP AGGREGATE
> psql:postgis/postgis.sql:7745: NOTICE:  aggregate st_geomunion(geometry)
> does not exist, skipping
> DROP AGGREGATE
> psql:postgis/postgis.sql:7746: NOTICE:  aggregate accum_old(geometry) does
> not exist, skipping
> DROP AGGREGATE
> psql:postgis/postgis.sql:7747: NOTICE:  aggregate st_accum_old(geometry)
> does not exist, skipping
> DROP AGGREGATE
> psql:postgis/postgis.sql:7750: NOTICE:  function box2d_overleft(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7751: NOTICE:  function
> box2d_overright(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7752: NOTICE:  function box2d_left(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7753: NOTICE:  function box2d_right(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7754: NOTICE:  function box2d_contain(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7755: NOTICE:  function
> box2d_contained(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7756: NOTICE:  function box2d_overlap(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7757: NOTICE:  function box2d_same(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7758: NOTICE:  function
> box2d_intersects(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7759: NOTICE:  function
> st_box2d_overleft(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7760: NOTICE:  function
> st_box2d_overright(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7761: NOTICE:  function st_box2d_left(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7762: NOTICE:  function st_box2d_right(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7763: NOTICE:  function
> st_box2d_contain(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7764: NOTICE:  function
> st_box2d_contained(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7765: NOTICE:  function
> st_box2d_overlap(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7766: NOTICE:  function st_box2d_same(box2d,box2d)
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7767: NOTICE:  function
> st_box2d_intersects(box2d,box2d) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7768: NOTICE:  function st_addbbox(geometry) does
> not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7769: NOTICE:  function st_dropbbox(geometry) does
> not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7770: NOTICE:  function st_hasbbox(geometry) does
> not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7771: NOTICE:  function cache_bbox() does not
> exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7772: NOTICE:  function st_cache_bbox() does not
> exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7773: NOTICE:  function
> transform_geometry(geometry,text,text,pg_catalog.int4) does not exist,
> skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7774: NOTICE:  function
> collector(geometry,geometry) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7775: NOTICE:  function
> st_collector(geometry,geometry) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7776: NOTICE:  function
> geom_accum(geometry[],geometry) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7777: NOTICE:  function
> st_geom_accum(geometry[],geometry) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7778: NOTICE:  function collect_garray(geometry[])
> does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7779: NOTICE:  function
> st_collect_garray(geometry[]) does not exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7780: NOTICE:  function geosnoop(geometry) does not
> exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7781: NOTICE:  function jtsnoop(geometry) does not
> exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7782: NOTICE:  function st_noop(geometry) does not
> exist, skipping
> DROP FUNCTION
> psql:postgis/postgis.sql:7783: NOTICE:  function
> st_max_distance(geometry,geometry) does not exist, skipping
> DROP FUNCTION
> -bash-4.1$
>
>
> Any solution for this is of great help. thanx in advance
>
> --
> View this message in context: http://old.nabble.com/Postgis-Installation-Error-tp31336778p31336778.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

Hello,

For the make check issue, try first with:

export PGUSER=postgres
export PGPASSWORD=<pass_of_postgres_user>

and then make check again

About the other problem, try with:

createdb -U postgres template_postgis
createlang -U postgres plpgsql template_postgis
psql -U postgres -d template_postgis -f
/path/to/postgis/sources/postgis/postgis.sql
psql -U postgres -d template_postgis -f
/path/to/postgis/sources/spatial_ref_sys.sql

It should work

Best regards,

-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g