localstack
localstack copied to clipboard
localstack
feature request: Add postgresql 14 and postgis extension
Is there an existing issue for this?
- [X] I have searched the existing issues
Feature description
Currently, only postgresql version 11,12 and 13 are supported. As AWS already supports 14, it would be great to have that available. Also, on AWS it is possible to install the PostGIS extension, which would be very helpful for localstack as well.
🧑💻 Implementation
No response
Anything else?
No response
Welcome to LocalStack! Thanks for reporting your first issue and our team will be working towards fixing the issue for you or reach out for more background information. We recommend joining our Slack Community for real-time help and drop a message to LocalStack Pro Support if you are a Pro user! If you are willing to contribute towards fixing this issue, please have a look at our contributing guidelines and our contributing guide.
Hi @chris-stetter,
just a short update: with the localstack/localstack-pro:latest we just released a version that supports postgres v14 and v15.
We haven't added the PostGIS extension yet. We will keep you posted on that matter.
But would it be possible to manually install the PostGIS extension as described in the AWS docs?
TBH I haven't tried it yet.
In general, when creating a postgres instance, you have a database + user with full access to that DB. Moreover, you could try to connect as the superuser postgres.
Running only CREATE EXTENSION postgis; will not create the postgis extensions on LocalStack yet, because we haven't implemented the logic behind it yet.
I think if you want to install it manually, you would have to follow the guides on the offical PostGIS website.
Hi @chris-stetter,
happy to inform you that we recently added postgis support for RDS 🥳
Please pull the latest localstack-pro image to use the new feature. We would be very happy to get your feedback.
Also we included support for postgres 15 and 16 in the meantime 🙂
Hello 👋! It looks like this issue hasn’t been active in longer than two weeks. We encourage you to check if this is still an issue in the latest release. In the absence of more information, we will be closing this issue soon. If you find that this is still a problem, please feel free to provide a comment or upvote with a reaction on the initial post to prevent automatic closure. If the issue is already closed, please feel free to open a new one.