Creating new PostgreSQL Database on production environment

I have a production Chirpstack server running on AWS and am interested in creating a new PostgreSQL databased provided by AWS (externally).

My question here is - if I do this, would all the devices continue to send data automatically or will these sensors need to be re-joined?

So you would like to move the PSQL database Chirpstack uses to AWS?

If you started from scratch the devices would have to rejoin, but you can easily do a backup of your current database using pg_dumpall, then use that file to create your new database.