I’m trying to create a partition in a PostgreSQL table for year and month. I want to archive data in S3 based on these partitions, using separate folders for each year and month. However, including the partition key in the primary key seems to be a requirement. I only need year and month (YYYY-MM format) in the partition key, not the day and time.

The PostgreSQL Global Development Group supports a major version for 5 years after its initial release12. After this, a final minor version will be released and the software will then be considered end-of-life (EOL) and no longer supported12.