[Solved] Postgis and othe extensions on johnny

[alank]

Hi

I have created my Postgres database on johnny and am trying to use phppgadmin to create a postgis extension via SQL... without success.

 

SQL error:

ERROR: could not open extension control file "/usr/share/pgsql/extension/postgis.control": No such file or directory

 

In statement:
Create extension postgis;

 

 

Is there something else I need to be doing?

 

Thanks

 

[wolstech]

If I recall correctly, we don't support postgis on Johnny.

[alank]

Thanks for the prompt reply.

 

Is Postgis  supported on any of the other servers? If so am I able to move?

[wolstech]

I'm not sure which ones it's supported on honestly. It may even be possible to make it supported on Johnny now that it's been rebuilt.

 

Let's see what our other root admin Krydos says.

[alank]

Thanks for that - it would be good if I could get remote access as well, if that isn't too much to ask.

 

Cheers

AlanK

[Krydos]

Does postgis work now? We'll need to know what user and database you want remote access from.

[alank]

Thanks Krydos,

We are closer, but no quite there:

 

SQL error:

ERROR: permission denied to create extension "postgis"
HINT: Must be superuser to create this extension.

 

In statement:
create extension postgis

 

Is it possible for me to connect as a super user?

 

I would like to have access to "alank_backloader" as "alank"

 

Cheers 

[Krydos]

Is it possible for me to connect as a super user?

No, you may not have access to view/modify/delete everyone's databases on the entire server. I can run the command for you though.

 

I would like to have access to "alank_backloader" as "alank"

Remote access enabled.

[alank]

Thanks for enabling remote access.

 

I wasn't actuallywanting access as the postgres user...

When I created the database (using the PostgreSQL Wizard)  I was asked to create a "privileged user".

I thought that this user would have privileges for the database I created... but I can't see how to log into postgres as that user.

 

If you could run the "create extension postgis" SQL, that would be good.

[Krydos]

Postgis extension has been created on the database alank_backloader.

[alank]

Thank you.

 

Is it possible to enable remote access to "alank_backloader"  for postgres user "alank_backloader"?

[Krydos]

Remote access enabled.