Re: [ADMIN] HOW-TO migrate database

2001-07-17 Thread SUVRANSHU KAR
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 execu

Re: [ADMIN] HOW-TO migrate database

2001-07-17 Thread Tom Lane
"Marian Sabo" <[EMAIL PROTECTED]> 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

[ADMIN] HOW-TO migrate database

2001-07-17 Thread Marian Sabo
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 dbna