Обсуждение: trying to migrate to a new server.
I have a very old postgres server that I am trying to move the data off of. It is running 7.1 and has been trouble free for 6 plus years. I am trying to move the data base off to a server running 8.1. I have managed to back up the data using PG_Dump using like this. " pg_dump -b -Fc -h stan.someplace.com -u phone >phone.data" But I have had no luck getting PG_Restore to restore the data. Any suggestions on what the command line should look like? We set this up as a test system and it ran so well no one wanted to take it down. I really want to migrate it before the PII 266 it is running on gives up the ghost :)
David Siebert <david@aretoo.com> writes: > I have a very old postgres server that I am trying to move the data off > of. It is running 7.1 and has been trouble free for 6 plus years. > I am trying to move the data base off to a server running 8.1. > I have managed to back up the data using PG_Dump using like this. > " pg_dump -b -Fc -h stan.someplace.com -u phone >phone.data" Use the 8.1 pg_dump to connect to the 7.1 database and generate a backup. Then the 8.1 pg_restore should be able to restore (new versions of restore don't always understand old dump formats). -Doug