[Resources]: Postgres extensions

[jonaro00]

Add commonly used Postgres extensions to the shared cluster and/or the AWS RDS instances.

---

_{This issue is a part of the Product Feature Poll (all issues). React with 👍 if you want this feature. Comment if you have suggestions related to this feature.}

[aniketbiprojit]

It should probably start with implementing a single extension to establish the convention and then go on adding more. Not sure if this extension is already supported but I would like to see if pg_vector can be supported.

[joshua-mo-143]

I think pgcrypto and pg_vector would be two PG extension I'd like to see supported, personally. Not sure what other extensions are popular, but having more options for securing your database data and being able to store vectors is always good.

[jonaro00]

Shared Postgres on shuttle.dev now has common Postgres extensions due to being based on AWS RDS.

[carlos-verdes]

@jonaro00 can we reopen this issue to include a search plugin like pg_search?
I could not find any search indexer on that AWS list.

Link to the plugin I found:
https://docs.paradedb.com/deploy/self-hosted/extensions