Re: partial data migration

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 7 Mar 2019 19:59:46 -0600



    (8.3?  That's even older than what we just migrated from!!!)

    
    No.  Make some views (I'd probably make them "month-sized"), COPY
    each view from the source db to a file, and then COPY each file to
    it's relevant target table.

    
    You should also think about a program named pg_bulkload.

    
    https://www.postgresql.org/docs/9.6/sql-copy.html

    https://www.postgresql.org/docs/8.3/sql-copy.html

    
    On 3/7/19 7:53 PM, Julie Nishimura
      wrote:

    
      Thank you Ron! What if dev environment is on 9.6, but prod is on
      version 8.3? Will posgtres_fdw still be the right option? 

      
      Sent from my iPhone
      

        On Mar 6, 2019, at 11:57 PM, Ron <ronljohnsonjr@xxxxxxxxx>
        wrote:

        
        On 3/7/19 1:54 AM, Julie Nishimura wrote:

          
              Hello psql friends,
            
              We need to migrate only 6 months worth of data from one
              instance to another. What would be the easiest way to do
              it? In Oracle, I would set up dblink. What about
              postgresql?
          
          
          postgres_fdw

          
    -- 

      Angular momentum makes the world go 'round.