The Prefect documentation doesn't specify minimum RAM requirements for a remote Postgres database. However, the memory requirements generally depend on factors like the size of your data, the number of concurrent connections, and the complexity of your queries.
A typical starting point for a production Postgres database is 4GB of RAM, but you'll need to monitor performance and adjust based on your workload.
Here's an overview I found for setting up Prefect with a remote Postgres DB:
Configuring Prefect to use a remote Postgres database:
1. Set the
PREFECT_API_DATABASE_CONNECTION_URL
environment variable to your Postgres connection string.
2. Start the Prefect server using
prefect server start
.
Source documentation:
https://docs.prefect.io/latest/guides/host/
For precise requirements, consider your specific workload and perhaps start with monitoring tools to adjust resources as needed.