Re: HOW-TO migrate database

Hi All,

Actually we also faced some in migration from Postgres
6.5.2 to 7.0- both upon Red Hat Linux, and 7.0 to
7.1.2 ( on NT WS using Cygwin) using pgdump.

In the Ist case, Tables and Index were no problem, but
data didnot come up. So we seperately edited the data
part from dump file and executed it through
pgsql.Tables and Index were no problem, but data
didnot come up. But 7.1.2 couldnot reconnize the data
format easily. So we wrote a front end program in
delphi to migrate.

Bye now.

KAR

For the 2nd case,
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "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

=====
>From SKAR. suvranshu_k(at)yahoo(dot)com
Good Day!

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/