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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message peter 2001-07-19 09:40:32 how to do???
Previous Message Mihai Afteni 2001-07-19 05:55:44 Please help me