Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.databases.postgresql Subject: Re: migrate from 8.4 to 9.6.2 Date: Fri, 31 Mar 2017 07:25:05 +0200 Lines: 16 Message-ID: References: <82844d32-265a-4d30-a5a9-d41906384d5e@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net jLX8EWjmXpJroNsZI+m9OA4KMG5IHpsZX6OEqyiO7JbOU17ME= Cancel-Lock: sha1:wyWgooi3Tgo6AIBUPsOzd9330bo= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.7.0 In-Reply-To: <82844d32-265a-4d30-a5a9-d41906384d5e@googlegroups.com> Xref: csiph.com comp.databases.postgresql:738 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/