Import large dataset to Postgres instance in CF
Siva Balan <mailsiva@...>
Hello,
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 instance. 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 instance. Now, what is the best way for me to import this large dataset to my postgres service instance? All thoughts and suggestions welcome. Thanks Siva Balan -- http://www.twitter.com/sivabalans |
|