Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group