Search Postgresql Archives

Porblems migrating a server.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?
Is it a problem going from 7.1 to 8.1? If so how do I get around it?
The data does use some large objects for text files if that is any help.
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  :)


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux