Running Script In AWS?

Question

I don't know this is a relevant question or not? I have one csv file and 1 shape file in my own drive and I used to run one script in cmd and combined these two files and stored in a pgsql using pgfuttur. I want to do the same thing in aws. If I kept these two files on a bucket is it possible to do the same with the below command I used in cmd?

shp2pgsql -I "<Shape file directory>" <Tablename> | psql -U <username> -d <DatabaseName>  Example : shp2pgsql -I "C:\Test\filep" public.geo | psql -U postgres -d gisDB

if yes please help me to get this. If no please let me know the reason.. [Please note that I am new to AWS]

helloV · Accepted Answer · 2018-01-02 06:58:03Z

1

You can do it in two ways:

You plan to do it only once or few times: Download the files locally using AWS CLI: aws s3 cp or aws s3 sync and then pass those files as input
You will be accessing multiple files: Use another AWS service to expose your S3 objects as files. Check AWS Storage Gateway and choose AWS Storage Gateway for Files. Once configured, you can refer to the S3 objects as files.

edited Jan 2, 2018 at 6:58

answered Jan 2, 2018 at 6:47

helloV

52.8k7 gold badges146 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running Script In AWS?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related