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

[Sandro Santilli]

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------'