Import large dataset to Postgres instance in CF
Siva Balan <mailsiva@...>
Below is my requirement:
I have a postgres instance deployed on our corporate CF deployment. I have
created a service instance of this postgres and bound my app to it. Now I
need to import a very large dataset(millions of records) into this postgres
As a CF user, I do not have access to any ports on CF other than 80 and
443. So I am not be able to use any of the native postgresql tools to
import the data. I can view and run simple SQL commands on this postgres
instance using the phppgadmin app that is also bound to my postgres service
Now, what is the best way for me to import this large dataset to my
postgres service instance?
All thoughts and suggestions welcome.