I've followed below document and created & attached IAM role and required policies but still not able to import data from S3 bucket to Postgres table.

.S3Import.html

We are getting error (SSL error: BAD_WRITE_RETRY) trying to import using AWS_S3 in Postgres DB, it is continuously running for 5-6 mins and the session getting terminated.

Postgres version: PostgreSQL 16.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-17), 64-bit

SELECT aws_s3.table_import_from_s3( 'ESU_IMPORT20', -- Table name '', -- Columns (leave empty for all columns) '(FORMAT csv,delimiter ",", HEADER true)', -- Options for COPY command 's3-postgres-bucket', -- S3 bucket 'ESU20250120.csv', -- File name in the bucket 'ap-south-1', -- AWS region '', -- AWS Access Key '' -- AWS Secret Key '' );