[postgis-users] PostGIS: make check works, but I can't manually create a spatial database

[samclemmens]

I ran make install after make check, and received the output below.  There
was no confirmation that it installed properly or not.  I tried creating
another spatial database using the same commands, but to no avail.  ---Same
issue.

[root at ip-10-224-82-127 postgis-1.5.0SVN]# make install
make -C liblwgeom
make[1]: Entering directory
`/opt/sources/postgis/postgis-1.5.0SVN/liblwgeom'
: -Plwg_parse_yy -i -f -o'lex.yy.c' wktparse.lex
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/liblwgeom'
make -C postgis
make[1]: Entering directory `/opt/sources/postgis/postgis-1.5.0SVN/postgis'
Makefile.pgxs:17: warning: overriding commands for target `install'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:92: warning: ignoring old
commands f                                             or target `install'
Makefile.pgxs:63: warning: overriding commands for target `installdirs'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:140: warning: ignoring old
commands                                              for target
`installdirs'
Makefile.pgxs:82: warning: overriding commands for target `uninstall'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:164: warning: ignoring old
commands                                              for target `uninstall'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/postgis'
make -C loader
make[1]: Entering directory `/opt/sources/postgis/postgis-1.5.0SVN/loader'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/loader'
make -C utils
make[1]: Entering directory `/opt/sources/postgis/postgis-1.5.0SVN/utils'
chmod +x postgis_restore.pl create_undef.pl postgis_proc_upgrade.pl
profile_inte                                             rsects.pl
test_estimation.pl test_joinestimation.pl
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/utils'
PostGIS was built successfully. Ready to install.
make -C postgis install
make[1]: Entering directory `/opt/sources/postgis/postgis-1.5.0SVN/postgis'
Makefile.pgxs:17: warning: overriding commands for target `install'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:92: warning: ignoring old
commands f                                             or target `install'
Makefile.pgxs:63: warning: overriding commands for target `installdirs'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:140: warning: ignoring old
commands                                              for target
`installdirs'
Makefile.pgxs:82: warning: overriding commands for target `uninstall'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:164: warning: ignoring old
commands                                              for target `uninstall'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/mkinstalldirs
'/usr/lib                                             64/pgsql'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
755  p                                             ostgis-1.5.so
'/usr/lib64/pgsql/postgis-1.5.so'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 ./                                             ../spatial_ref_sys.sql
'/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 po                                             stgis.sql
'/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 un                                             install_postgis.sql
'/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 po                                            
stgis_upgrade_15_minor.sql '/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 po                                            
stgis_upgrade_14_to_15.sql '/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
644 po                                            
stgis_upgrade_13_to_15.sql '/usr/share/pgsql/contrib/postgis-1.5'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m
755  p                                             ostgis-1.5.so
'/usr/lib64/pgsql/postgis-1.5.so'
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/postgis'
make -C loader install
make[1]: Entering directory `/opt/sources/postgis/postgis-1.5.0SVN/loader'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c
pgsql2shp                                              /usr/bin
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c
shp2pgsql                                              /usr/bin
make[1]: Leaving directory `/opt/sources/postgis/postgis-1.5.0SVN/loader'




Mark Cave-Ayland-3 wrote:
> 
> samclemmens wrote:
> 
>> Unfortunately, I get the following:
>> 
>> postgres=# SELECT postgis_full_version();
>> ERROR:  function postgis_full_version() does not exist
>> LINE 1: SELECT postgis_full_version();
>>                ^
>> HINT:  No function matches the given name and argument types. You might
>> need
>> to add explicit type casts.
> 
> Okay so something has gone wrong somewhere. Firstly, after "make check", 
> did you run "make install"? Secondly, what happens if you load the 
> postgis.sql file into a brand new database?
> 
> 
> ATB,
> 
> Mark.
> 
> -- 
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
> 
> Sirius Labs: http://www.siriusit.co.uk/labs
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/PostGIS%3A-make-check-works%2C-but-I-can%27t-manually-create-a-spatial-%09database-tp28691440p28708405.html
Sent from the PostGIS - User mailing list archive at Nabble.com.