Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
samclemmens wrote: I dropped the db and recreated it...and this time it worked. I get the following, which, I'm assuming, means I'm good to go...? testdb1=# SELECT postgis_full_version(); postgis_full_version --- POSTGIS="1.5.0SVN" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS (1 row) Yep; that looks good to me :) 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
I dropped the db and recreated it...and this time it worked. I get the following, which, I'm assuming, means I'm good to go...? testdb1=# SELECT postgis_full_version(); postgis_full_version --- POSTGIS="1.5.0SVN" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS (1 row) Mark Cave-Ayland-3 wrote: > > samclemmens wrote: > >> 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. > > The "make install" output looks good. Are you sure you get *exactly* the > same error as before when installing into a fresh database? The part of > the log we need to see when installed into a fresh database are the set > of lines just before and just after the first ERROR appears. Please drop > the database and try again posting the relevant output. > > The only other thing I can think of is that someone has installed > another version of PostGIS into the template1 database so that it gets > automatically added to any new database. > > > HTH, > > 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@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-tp28691440p28708732.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
samclemmens wrote: 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. The "make install" output looks good. Are you sure you get *exactly* the same error as before when installing into a fresh database? The part of the log we need to see when installed into a fresh database are the set of lines just before and just after the first ERROR appears. Please drop the database and try again posting the relevant output. The only other thing I can think of is that someone has installed another version of PostGIS into the template1 database so that it gets automatically added to any new database. HTH, 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
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. [r...@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 postg
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
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. Mark Cave-Ayland-3 wrote: > > samclemmens wrote: > >> Sorry; I inadvertently posted my previous response twice... The line >> is: >> >> psql:postgis/postgis.sql:80: ERROR: type "spheroid" already exists >> >> So, does this mean that my spatial database was successfully created the >> first time around despite the "notices" that the spatial functions (e.g., >> st_max_distance) do not exist? > > Older versions of 1.5 tried to remove some legacy functions from the > database as part of the installation which is why some people would see > error messages at the end of the installation. > > Since all the SQL functions are now in a transaction, then if you can > call any PostGIS function then the installation has completed correctly. > Does "SELECT postgis_full_version()" work for you? If so, you should be > fine. > > > HTH, > > 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@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-tp28691440p28708126.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
samclemmens wrote: Sorry; I inadvertently posted my previous response twice... The line is: psql:postgis/postgis.sql:80: ERROR: type "spheroid" already exists So, does this mean that my spatial database was successfully created the first time around despite the "notices" that the spatial functions (e.g., st_max_distance) do not exist? Older versions of 1.5 tried to remove some legacy functions from the database as part of the installation which is why some people would see error messages at the end of the installation. Since all the SQL functions are now in a transaction, then if you can call any PostGIS function then the installation has completed correctly. Does "SELECT postgis_full_version()" work for you? If so, you should be fine. HTH, 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
Sorry; I inadvertently posted my previous response twice... The line is: psql:postgis/postgis.sql:80: ERROR: type "spheroid" already exists So, does this mean that my spatial database was successfully created the first time around despite the "notices" that the spatial functions (e.g., st_max_distance) do not exist? Kevin Neufeld wrote: > > These are not the ERRORs messages Devrim was referring to. These are > merely NOTICEs that are typical for a PostGIS installation. Before all > the "ERROR: transaction was aborted" log entries you reported, there > should be a line that indicates what caused the transaction to roll back. > > -- Kevin > > On 5/27/2010 2:14 AM, Peter Cotroneo wrote: >> >> Hi Devrim, >> >> Thanks for your reply. Here’s what I get immediately after trying to >> create a spatial database: >> >> >> [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb >> testdb >> >> [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang >> plpgsql testdb >> >> [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres psql -d >> testdb -f postgis/postgis.sql >> >> BEGIN >> >> psql:postgis/postgis.sql:57: NOTICE: type "spheroid" is not yet defined >> >> DETAIL: Creating a shell type definition. >> >> CREATE FUNCTION >> >> psql:postgis/postgis.sql:63: NOTICE: argument type spheroid is only a >> shell >> >> CREATE FUNCTION >> >> psql:postgis/postgis.sql:68: NOTICE: return type spheroid is only a shell >> >> CREATE FUNCTION >> >> psql:postgis/postgis.sql:73: NOTICE: argument type spheroid is only a >> shell >> >> CREATE FUNCTION >> >> CREATE TYPE >> >> psql:postgis/postgis.sql:90: NOTICE: type "geometry" is not yet defined >> >> DETAIL: Creating a shell type definition. >> >> As I mentioned yesterday, make check works just fine (i.e., it creates >> the spatial database postgis_reg). >> >> Cheers, >> >> Petrus >> >> >> ___ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > ___ > postgis-users mailing list > postgis-users@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-tp28691440p28707299.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
Here’s what I get immediately after trying to create a spatial database: [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang plpgsql testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres psql -d testdb -f postgis/postgis.sql BEGIN psql:postgis/postgis.sql:57: NOTICE: type "spheroid" is not yet defined DETAIL: Creating a shell type definition. CREATE FUNCTION psql:postgis/postgis.sql:63: NOTICE: argument type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:68: NOTICE: return type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:73: NOTICE: argument type spheroid is only a shell CREATE FUNCTION CREATE TYPE psql:postgis/postgis.sql:90: NOTICE: type "geometry" is not yet defined DETAIL: Creating a shell type definition. ...and so on... Devrim GÜNDÜZ wrote: > > On Wed, 2010-05-26 at 12:16 +0100, Peter Cotroneo wrote: >> >> When I try to create a spatial database (e.g., psql -d geodb -f >> postgis.sql), however, it doesn't work. I get numerous errors that >> look as follows: >> >> psql:postgis.sql:7739: ERROR: current transaction is aborted, >> commands ignored until end of transaction block > > There should be something different before this. Could you please paste > it? > > BTW, did you load plpgsql before running postgis.sql script? > -- > Devrim GÜNDÜZ > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > PostgreSQL RPM Repository: http://yum.pgrpms.org > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz > > > ___ > postgis-users mailing list > postgis-users@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-tp28679308p28707160.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
These are not the ERRORs messages Devrim was referring to. These are merely NOTICEs that are typical for a PostGIS installation. Before all the "ERROR: transaction was aborted" log entries you reported, there should be a line that indicates what caused the transaction to roll back. -- Kevin On 5/27/2010 2:14 AM, Peter Cotroneo wrote: Hi Devrim, Thanks for your reply. Here’s what I get immediately after trying to create a spatial database: [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang plpgsql testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres psql -d testdb -f postgis/postgis.sql BEGIN psql:postgis/postgis.sql:57: NOTICE: type "spheroid" is not yet defined DETAIL: Creating a shell type definition. CREATE FUNCTION psql:postgis/postgis.sql:63: NOTICE: argument type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:68: NOTICE: return type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:73: NOTICE: argument type spheroid is only a shell CREATE FUNCTION CREATE TYPE psql:postgis/postgis.sql:90: NOTICE: type "geometry" is not yet defined DETAIL: Creating a shell type definition. As I mentioned yesterday, make check works just fine (i.e., it creates the spatial database postgis_reg). Cheers, Petrus ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS: make check works, but I can't manually create a spatial database
Hi Devrim, Thanks for your reply. Here’s what I get immediately after trying to create a spatial database: [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createdb testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres createlang plpgsql testdb [r...@ip-10-224-82-127 postgis-1.5.0SVN]# sudo -u postgres psql -d testdb -f postgis/postgis.sql BEGIN psql:postgis/postgis.sql:57: NOTICE: type "spheroid" is not yet defined DETAIL: Creating a shell type definition. CREATE FUNCTION psql:postgis/postgis.sql:63: NOTICE: argument type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:68: NOTICE: return type spheroid is only a shell CREATE FUNCTION psql:postgis/postgis.sql:73: NOTICE: argument type spheroid is only a shell CREATE FUNCTION CREATE TYPE psql:postgis/postgis.sql:90: NOTICE: type "geometry" is not yet defined DETAIL: Creating a shell type definition. As I mentioned yesterday, make check works just fine (i.e., it creates the spatial database postgis_reg). Cheers, Petrus ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS: make check works, but I can't manually create a spatial database
On Wed, 2010-05-26 at 12:16 +0100, Peter Cotroneo wrote: > > When I try to create a spatial database (e.g., psql -d geodb -f > postgis.sql), however, it doesn't work. I get numerous errors that > look as follows: > > psql:postgis.sql:7739: ERROR: current transaction is aborted, > commands ignored until end of transaction block There should be something different before this. Could you please paste it? BTW, did you load plpgsql before running postgis.sql script? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS: make check works, but I can't manually create a spatial database
Hi, I've just installed PostgreSQL 8.4.2, Proj 4.6.1, GEOS 3.2.0 (CAPI 1.6.0), libxml 2.7.6, and PostGIS 1.5.0 on an Amazon EC2 instance running the 64-bit version of Fedora 8. (I compiled using GCC 4.1.2.) After installing PostGIS, I ran make check and that was successful. When I try to create a spatial database (e.g., psql -d geodb -f postgis.sql), however, it doesn't work. I get numerous errors that look as follows: psql:postgis.sql:7739: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK psql:postgis.sql:7744: NOTICE: aggregate geomunion(geometry) does not exist, skipping My understanding is that make check creates a spatial database using the postgis.sql script, which is essentially what I'm trying to do manually. So, I'm a bit confused... Can someone please tell me what I'm doing wrong? Cheers, Petrus ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users