Re: Migrating Postgresql 8.0 to 8.3

Craig Ringer <ringerc@xxxxxxxxxxxxx> · Mon, 13 Aug 2012 21:33:56 +0800



    On 08/13/2012 08:40 PM, quickinfo
      wrote:

    
      Hello Friends,

      
      I would like to migrate postgresql 8.0 to 8.3. Please suggest me
      the best way of restoring my backup.

    
    If at all possible, use the 8.3 version of pg_dump to make a new
    backup from your 8.0 server, rather than trying to restore a dump
    from 8.0 to 8.3.

    
    Also, please consider 8.3 as a stepping stone to 9.1, which should
    be your migration target. 8.3 will be leaving support early next
    year:

    
    http://www.postgresql.org/support/versioning/

    
    so it is not a good choice for an upgrade target.

    
    --

    Craig Ringer