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$1@news.tht.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hello

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
news:25373(dot)995388342(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "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-2014 The PostgreSQL Global Development Group