I have a folder of rasters that updates daily that I load into a PostgreSQL database using the raster2pgsql command line tool. I want to make this database outward facing so that I can connect to it. I like the idea of storing this database on AWS, but I don't know if it's possible to
- Add rasters directly to the AWS PostgreSQL database, or
- Sync my on-prem database with the database on AWS.
I really would like to avoid having to re-import the entire database daily as I only need to keep adding one raster per day. Is this possible (and how would I go about doing this?) or is there a better tool for doing this?