Re: HOW-TO migrate database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marian Sabo" <sabo(at)cps(dot)sk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: HOW-TO migrate database
Date: 2001-07-17 16:45:42
Message-ID: 25373.995388342@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Marian Sabo" <sabo(at)cps(dot)sk> writes:
> I have a many databases on server "one" in postgres-6.5.2
> How can I copy my databases to a new server with new postgres vsersion
> (7.1.2) ?
> on first server I run : pg_dumpall -o > outputfile, but on new server
> pg_restore don't understand the data format.

pg_dumpall is the right approach, though I would not recommend using -o.

Possibly you will need to do a little bit of editing to cope with
changes from 6.5 to 7.1, although it surprises me to hear it. What
problems are you seeing, exactly, when you try to load the dump script?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message speeves 2001-07-17 21:24:59 putting odbc on university server
Previous Message Tom Lane 2001-07-17 16:14:08 Re: Problem: plperl load failed (PGSQL 7.1.2)