CODEWITHSUNDEEP
postgresqldockerdocker-composepostgisgeoserver
Lee Heazel
Lee Heazel

Reputation: 33

Getting a GeoServer talking to an AWS RDS?

I have an issue that's killing me. I have an AWS account and am hosting a GeoServer instance up there within a Docker container, launched through a docker-compose file. It works perfectly fine. I also have a PostgreSQL RDS instance up there. As far as I can tell, it's working fine. Getting them to communicate, that's been my problem.

My issue is that everything I've found indicates that GeoServer utilizes only PostSQL natively, and PostgreSQL not at all. AWS doesn't give the option to create a PostSQL RDS but, as it's an extension of PostgreSQL, this avenue seems the simplest to pursue.

So my challenge is to find a way for my dockerized GeoServer application to communicate with the RDS, and I'm leaning in the direction of incorporating the PostSQL extension into my docker-compose file. But this is all well over my head, as I've only begun learning these things recently, and it's specific enough that Google has hardly been a help at all. Can anyone give me some guidance with this endeavor?

Upvotes: 3

Views: 909

Answers (1)

Ian Turton
Ian Turton

Reputation: 10976

It is easy to add PostGIS (the spatial extension to PostgreSQL) to an RDS instance, see the AWS documentation for a detailed guide. But for the impatient just log on to the database and run:

create extension postgis;

GeoServer makes it as simple to connect to a remote database as to a local one. All you need to know is the hostname and port, add the username and password for the database and finally the schema you are using.

Upvotes: 2

Related Questions