Getting a GeoServer talking to an AWS RDS?

Lee Heazel

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?

Ian Turton

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.

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

AWS RDS BatchExecuteStatementRequest

分類Dev

Is there a way to AWS RDS postgres.log into CloudWatch?

分類Dev

AWS RDS with Postgres : Is OOM killer configured

分類Dev

Instance Size Flexibility for AWS RDS Reserved Instances

分類Dev

Create AWS RDS Instance with specific version?

分類Dev

AWS Lambda NodeJS Connect to RDS Postgres Database

分類Dev

Connect to AWS RDS Postgres database with python

分類Dev

Enable encryption on existing database - AWS RDS Postgresql

分類Dev

AWS RDS Postgres replication to GCP cloud SQL

分類Dev

Describe RDS Snapshots across AWS Regions

分類Dev

AWS RDS SQL Server failover really slow

分類Dev

Exporting a AWS Postgres RDS Table to AWS S3

分類Dev

Non AWS server connecting to AWS RDS database is much slower

分類Dev

AWS RDS-HIPAA準拠ですか?

分類Dev

Disabling AWS RDS backups when creating/updating instances?

分類Dev

Connecting to Postgres AWS RDS Instance - "certificate verify failed"

分類Dev

AWS Database Backup RDS to S3 By Crontab(Cron Job)

分類Dev

Exporting oracle table on AWS RDS that contains blobs and import into offline database

分類Dev

IstioでのMySQL(AWS RDS)への接続

分類Dev

SQLAlchemy and PyMySQL refusing connection to 'localhost' after connecting to AWS RDS

分類Dev

How to change AWS-RDS instance type without downtime?

分類Dev

AWS RDS MySQL database username and password sufficient for commercial security

分類Dev

how to load data from AWS RDS to Google BigQuery in streaming mode?

分類Dev

Load balance active TCP sessions to AWS Aurora RDS

分類Dev

Django AWS RDS environment variables not setting in Elastic Beanstalk

分類Dev

AWS-RDS-MySQL-メモリ不足

分類Dev

How to implement callbacks on AWS RDS PostgreSQL using node.js

分類Dev

AWS無料利用枠:EC2 + RDS parellel

分類Dev

Getting AngularJS to work with AWS DynamoDB

Related 関連記事

  1. 1

    AWS RDS BatchExecuteStatementRequest

  2. 2

    Is there a way to AWS RDS postgres.log into CloudWatch?

  3. 3

    AWS RDS with Postgres : Is OOM killer configured

  4. 4

    Instance Size Flexibility for AWS RDS Reserved Instances

  5. 5

    Create AWS RDS Instance with specific version?

  6. 6

    AWS Lambda NodeJS Connect to RDS Postgres Database

  7. 7

    Connect to AWS RDS Postgres database with python

  8. 8

    Enable encryption on existing database - AWS RDS Postgresql

  9. 9

    AWS RDS Postgres replication to GCP cloud SQL

  10. 10

    Describe RDS Snapshots across AWS Regions

  11. 11

    AWS RDS SQL Server failover really slow

  12. 12

    Exporting a AWS Postgres RDS Table to AWS S3

  13. 13

    Non AWS server connecting to AWS RDS database is much slower

  14. 14

    AWS RDS-HIPAA準拠ですか?

  15. 15

    Disabling AWS RDS backups when creating/updating instances?

  16. 16

    Connecting to Postgres AWS RDS Instance - "certificate verify failed"

  17. 17

    AWS Database Backup RDS to S3 By Crontab(Cron Job)

  18. 18

    Exporting oracle table on AWS RDS that contains blobs and import into offline database

  19. 19

    IstioでのMySQL(AWS RDS)への接続

  20. 20

    SQLAlchemy and PyMySQL refusing connection to 'localhost' after connecting to AWS RDS

  21. 21

    How to change AWS-RDS instance type without downtime?

  22. 22

    AWS RDS MySQL database username and password sufficient for commercial security

  23. 23

    how to load data from AWS RDS to Google BigQuery in streaming mode?

  24. 24

    Load balance active TCP sessions to AWS Aurora RDS

  25. 25

    Django AWS RDS environment variables not setting in Elastic Beanstalk

  26. 26

    AWS-RDS-MySQL-メモリ不足

  27. 27

    How to implement callbacks on AWS RDS PostgreSQL using node.js

  28. 28

    AWS無料利用枠:EC2 + RDS parellel

  29. 29

    Getting AngularJS to work with AWS DynamoDB

ホットタグ

アーカイブ