Unable to export AWS RDS Postgres table to CSV in S3, using aws_s3.query_export_to_s3 function

Try upgrading to Postgres 12.4. I’m having a similar problem and that’s what AWS support told me (response pasted below). [edited]

Update

Initially I hadn’t fully got this working, but can confirm upgrading to Postgres 12.4, and dropping and recreating the extension worked.

DROP EXTENSION aws_s3 CASCADE;
DROP EXTENSION aws_commons CASCADE;
CREATE EXTENSION aws_s3 CASCADE;

Original response from AWS Support:

Based on output of describe-db-engine-versions[1] I can see that only the below specific engine versions support s3Export feature. Hence version 12.2 does not support export to S3 feature.

[
    {
        "Engine": "postgres",
        "EngineVersion": "10.14",
        "SupportedFeatureNames": [
            "s3Import",
            "s3Export"
        ]
    },
    {
        "Engine": "postgres",
        "EngineVersion": "11.9",
        "SupportedFeatureNames": [
            "s3Import",
            "s3Export"
        ]
    },
    {
        "Engine": "postgres",
        "EngineVersion": "12.4",
        "SupportedFeatureNames": [
            "s3Import",
            "s3Export"
        ]
    } ]