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

Re: HOW-TO migrate database

From: "Marian Sabo" <sabo(at)cps(dot)sk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: HOW-TO migrate database
Date: 2001-07-19 06:05:04
Message-ID: 9j5tbh$301n$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

I use the "-d" switch and data format is correctly exported from database.
There's no problem to import table schemes and data to new 7.1.2

Marian Sabo

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
> "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
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

pgsql-admin by date

Next:From: peterDate: 2001-07-19 09:40:32
Subject: how to do???
Previous:From: Mihai AfteniDate: 2001-07-19 05:55:44
Subject: Please help me

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