[OSM-Devserver] Request to Install Hstore In osmosisci_pgsql06

[Brett Henderson]

I've tried to run hstore.sql again and received the output listed below.  I
can't run the hstore-new.sql either because it fails due to the hstore type
already existing and refuses to proceed further.

I don't think I need any special hstore functionality, the normal 8.3
version should be sufficient.  Can somebody please run the original
hstore.sql?  Hopefully that will be enough to get things working.

osmosisci at gauss:/osm/osmosis-continuous-integration/database/install$ psql
-f /usr/share/postgresql/8.3/contrib/hstore.sql osmosisci_pgsql06 SET
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:6: ERROR:  type "hstore"
already exists
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:11: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:16: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:23: ERROR:  function
hstore_in(cstring) does not exist
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:28: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:34: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:39: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:44: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:52: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:57: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:62: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:67: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:72: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:78: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:83: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:88: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:97: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:106: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:116: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:125: ERROR:  type "hstore"
is only a shell
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:130: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:136: ERROR:  function
tconvert(text, text) does not exist
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:141: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:146: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:151: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:156: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:163: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:169: ERROR:  type
"ghstore" already exists
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:174: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:179: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:185: ERROR:  function
ghstore_in(cstring) does not exist
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:190: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:195: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:200: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:205: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:210: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:215: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:220: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:238: ERROR:  must be
superuser to create an operator class
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:245: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:250: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:255: ERROR:  permission
denied for language c
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:266: ERROR:  must be
superuser to create an operator class

On Tue, Aug 24, 2010 at 10:34 AM, Brett Henderson <brett at bretth.com> wrote:

> Hmm, I got a lot of errors saying something like a C function required
> superuser access.  I was trying to use the hstore.sql, not hstore-new.sql.
> I'll try again this evening and see how I go.
>
> 2010/8/23 Sven Geggus <lists at fuchsschwanzdomain.de>
>
> Brett Henderson <brett at bretth.com> wrote:
>>
>> > Can somebody with superuser access to PostgreSQL please install the
>> > hstore.sql contrib module into the osmosisci_pgsql06 database?
>>
>> I'm quite shure taht this would not need superuser access
>>
>> psql:/usr/share/postgresql/8.3/contrib/hstore-new.sql:13: ERROR:  type
>> "hstore" already exists
>>
>> Regards
>>
>> Sven
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstreetmap.de/pipermail/devserver/attachments/20100824/5c0fe7b1/attachment.htm>