I am running an Aurora postgresql 14.6 cluster, that has 1 writer and 1 read replica.

There is one database under the cluster which interacts with an API, which gets called by consumers around 50-100 times per day. What the API does is to perform CRUD operations against multiple tables.

I am using liquibase for database deployment.

My question is, if I want to deploy an DDL such as adding a column to an existing table or modifying an existing function etc, can I deploy the DDL while the cluster is up and running? Will it affect any production operation?

What is the best practice here？Thanks.