Installing "postgis" extension with postgresql database

AnonymousFREE

6 months ago

Hi, I have installed Postgresql Database for my Django project and then I connected it in my local machine's console to make migrations then an error occured stating that

psycopg2.errors.FeatureNotSupported: extension "postgis" is not available
DETAIL:  Could not open extension control file "/usr/share/postgresql/16/extension/postgis.control": No such file or directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.

so I thought I should've installed postgis first so installed it using https://railway.app/template/postgis and updated my django Database url with the new postgis template's configuration but when I tried to run python manage.py migrate then it showed

django.db.utils.OperationalError: connection to server at "junction.proxy.rlwy.net" (35.213.179.112), port 19940 failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

so How am I supposed to configure postgis extension in my database? And later I will also add GDAL with it.

16 Replies

brodyEMPLOYEE

6 months ago

PostGIS doesn't have any deployments, go ahead and deploy the template for it again.

space-we3TRIAL

6 months ago

You mean, Which deployments? Postgis again? Or my project?

brodyEMPLOYEE

6 months ago

Deploy the PostGIS template again.

space-we3TRIAL

6 months ago

I made a duplicate of PostGIS and in the duplicate copy, it is still showing the same and also showing

"Failed to commit changes

Your account is on a limited plan. Please visit railway.app/account/plans for details."

Note: Both accounts are mine, so please don't get confused.

brodyEMPLOYEE

6 months ago

I hadn't noticed you where on a limited trial.

You will need to upgrade to the Hobby plan.

space-we3TRIAL

6 months ago

To even use or install "PostGIS"?

brodyEMPLOYEE

6 months ago

That's correct, you are on a limited trial plan and thus you can't deploy templates.

space-we3TRIAL

6 months ago

If I purchase a hobby plan, it says

$5
/mo
+ Resource usage

so what exactly would I get? 5$ Resource usage or one month full access? Or When I use 5$ resource and it wear off then I won't be able to use any more of it?

brodyEMPLOYEE

6 months ago

You pay $5 a month, and that comes with $5 in resource usage, once you go over that $5 you are charged any additional resources.

space-we3TRIAL

6 months ago

And I didn't see where the PostgreSQL database pricing are? Can you share it please?

brodyEMPLOYEE

6 months ago

There is no specific pricing for Postgres, it's all the same pricing for every kind of service.

space-we3TRIAL

6 months ago

You are saying, If I use 100GB of database storage to store so there won't be any charge for that? Or Is it based on Volume

brodyEMPLOYEE

6 months ago

Database storage would be volume storage, and you are indeed charged for that.

Status changed to Solved brody • 6 months ago

arogoclinHOBBY

7 days ago

Hello would you mind help me please?

Status changed to Open railway[bot] • 7 days ago

arogoclinHOBBY

7 days ago

I'm trying to connect to the postgis but seemly it's not working.

Attachments

AnonymousFREE

6 days ago

Hi @arogoclin , Did you successfully deployed Postgis extension along with Postgresql and working fine? In my case, I was trying to a Poddstgis extension in Free Plan which can't be possible because It can be only deployed with Pro or Hobby plan. If it is successfully deployed for you then make sure that You deployed Postgis extension along with Postgresql, I mean, deploy Postgis in the same service where the db service is.

Edit: Oh... Now I see you're on Hobby plan, Best case for you would be to open a new case for this issue which will escalate the problem in solving by Railway team.

Edit: @arogoclin I would suggest you to blur some of the project names/sensitive text while sharing screenshots.

Installing "postgis" extension with postgresql database - Railway Help Station