[postgis-users] Insert a point value : ST_GeometryFromText unknown function [resolved]

[efusien]

It works fine !

I did:

$ sudo su postgres
$ psql -d test -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
-v ON_ERROR_STOP=1
$ psql -d test -f
/usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
$ psql -d test -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql

Other problems appears now, but I can continue. Thank's a lot.




Sandro Santilli wrote:
> 
> On Tue, Jan 03, 2012 at 01:22:11PM -0800, efusien wrote:
> 
>> $ sudo psql -d test -f
>> /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql -v
>> ON_ERROR_STOP=1
>> => SET
>> BEGIN
>> psql:/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql:59: ERROR: 
>> permission denied for language c
>> 
>> ...fail
>> I see on other websites that I have to be logged with root. But I
>> allready
>> use "sudo" (Ubuntu). What's wrong ? Any idea ?
> 
> You have to be a database "superuser".
> It's usually user "postgres". Try:
> 
>  sudo su postgres -c psql -d test \
>   -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql \
>   -v ON_ERROR_STOP=1
> 
> --strk; 
> 
>   ,------o-. 
>   |   __/  |    Thank you for PostGIS-2.0 Topology !
>   |  / 2.0 |    http://www.pledgebank.com/postgistopology
>   `-o------'
> 
> _______________________________________________
> 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/Insert-a-point-value-%3A-ST_GeometryFromText-unknown-function-tp33073860p33075357.html
Sent from the PostGIS - User mailing list archive at Nabble.com.