alank

Thank you.

 

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

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.

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 

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

Thanks for the prompt reply.

 

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

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