how can I increase resource for pod source-postgres-check?

To increase the resources for the

source-postgres-check

pod in Airbyte, you need to set environment variables in the worker deployment. The relevant variables for memory allocation are

JOB_MAIN_CONTAINER_MEMORY_REQUEST

and

JOB_MAIN_CONTAINER_MEMORY_LIMIT

. Here is an example of how you might set these variables:

bash JOB_MAIN_CONTAINER_MEMORY_REQUEST=512Mi JOB_MAIN_CONTAINER_MEMORY_LIMIT=1Gi

In this example, the memory request is set to 512Mi and the memory limit is set to 1Gi. You can adjust these values according to your needs. Please note that these changes should be made in the environment where your Airbyte instance is running. If you're running Airbyte on Kubernetes, these environment variables would typically be set in the Kubernetes deployment configuration for the worker. Also, keep in mind that increasing the resources for the pod will only be effective if there are sufficient resources available on the node where the pod is scheduled to run. If the node does not have enough resources, the pod may not be able to start or may be evicted. For more details, you can refer to these discussions and issues where similar topics are discussed: [Forum Post: Increase Sync Worker Resources](https://discuss.airbyte.io/t/1714), [Github Issue: Airbyte is ignoring

JOB_MAIN_CONTAINER_MEMORY_REQUEST

in .env](https://github.com/airbytehq/airbyte/issues/30814), [Github Issue: Source Postgres: making worker pod use a lot of memory](https://github.com/airbytehq/airbyte/issues/31041).