Re: copy expensive local view to an RDS instance

Marcus Engene <mengpg2@xxxxxxxxx> · Tue, 06 May 2014 17:30:23 +0200



    On 06/05/14 17:15, bricklen wrote:

    
          On Tue, May 6, 2014 at 8:07 AM,
            Marcus Engene <mengpg2@xxxxxxxxx>
            wrote:

            On 06/05/14 16:58,
              bricklen wrote:

              
                A very quick search shows that rds supports dblink, so
                perhaps that would work.

                http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html

              
              Then I'd need to open our servers to external visits. It
              would be lovely if dblink_exec could push a subselect of
              data instead instead of pull from RDS. Does this make
              sense?

            
          Is the idea to pull data from the RDS to your local machine?
          If so, dblink or possibly plproxy[1] should be able to do
          that.

          
          [1] https://wiki.postgresql.org/wiki/PL/Proxy

        
    Sorry, no, I want to push data from my local machine but I've only
    seen examples of push with dblink_exec and litteral values rather
    than a subselect or smth.

    
    Best regards,

    Marcus