Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

How to remove the file from S3 after import #17

Open
pguser4ever opened this issue Sep 18, 2021 · 0 comments
Open

How to remove the file from S3 after import #17

pguser4ever opened this issue Sep 18, 2021 · 0 comments

Comments

@pguser4ever
Copy link

pguser4ever commented Sep 18, 2021

Hi have a question, don't know could be something i missed but anyway
like to use postgres copy command to export/import data to RDS from outside RDS so aws-s3 extension looks great
so let's say we on a regular bases call a job using aws-s3 export function to export data from a number of tables in csv format to s3 storage (using federated dblinks outside RDS ) then import csv files using aws-s3 import function.
Fine but how to clean up s3 storage and remove the csv files from s3 after file import?
kind of missing a delete function to remove the file from s3 after import to RDS
We have a similar setup today using a plsh function to make OS calls and works great but guess not supported in RDS

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant