1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • migrate from 8.4 to 9.6.2

    From servicelinesbg@gmail.com@21:1/5 to All on Thu Mar 30 09:30:42 2017
    Hi, can anyone tell me the best way to migrate a database from win2003 8.4 verion of postgre to win2012 9.6.2 verion of postgre? I'm using pg_restore but some tables aren't restored on the new version of the server.

    thanks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Klemme@21:1/5 to servicelinesbg@gmail.com on Fri Mar 31 07:25:05 2017
    On 30.03.2017 18:30, servicelinesbg@gmail.com wrote:
    Hi, can anyone tell me the best way to migrate a database from
    win2003 8.4 verion of postgre to win2012 9.6.2 verion of postgre? I'm
    using pg_restore but some tables aren't restored on the new version
    of the server.

    You can always use pg_dumpall. Plus see https://www.postgresql.org/docs/9.6/static/upgrading.html

    Kind regards

    robert

    --
    remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)