Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #738

Re: migrate from 8.4 to 9.6.2

Show all headers | View raw

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/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

migrate from 8.4 to 9.6.2 servicelinesbg@gmail.com - 2017-03-30 09:30 -0700
  Re: migrate from 8.4 to 9.6.2 Robert Klemme <shortcutter@googlemail.com> - 2017-03-31 07:25 +0200

csiph-web