Обсуждение: HOW-TO migrate database
Hello 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. the same result is on pg_dump dbname > file and on second server pg_restore file ... How it is possible to copy all databases from one (6.5.2) to second (7.1.2) server ? Many thanks Marian Sabo
"Marian Sabo" <sabo@cps.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
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@sss.pgh.pa.us> wrote: > "Marian Sabo" <sabo@cps.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@yahoo.com Good Day! __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
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@sss.pgh.pa.us> wrote in message news:25373.995388342@sss.pgh.pa.us... > "Marian Sabo" <sabo@cps.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