Submitted by Jeff (not verified) on Fri, 2008-02-15 09:57.
What do you mean "would not restore"? The "--clean" option is for removing pre-existing data in the database, so if you're restoring into an empty database it makes sense that you'd get errors like "_________ doesn't exist", but that doesn't mean your data wasn't restored. What actual errors are you getting?
I agree that dump/reload is not an ideal solution. There has been some significant effort toward in-place upgrades, and I think it's a possibility in the near future. In the meantime, you have to use something like Slony if you have a lot of data (and that's not an easy process either).
Why did you have to create each database again? That's the point of pg_dumpall. pg_dumpall will recreate all your databases, users, and everything else, while pg_dump is the one that only dumps a single database. Again, without more information it's hard to figure out what went wrong (if anything).
Also, post things like this to pgsql-general. You will no doubt get all your problems resolved very quickly, and it may lead to better documentation so that other users don't have similar problems.
»
Reply
Search
Windows for Intel Macs
Todd Ogasawara's Windows for Intel Macs ($7.99USD published by O'Reilly Media) is for Intel Mac users running Bootcamp or Parallels who want to learn more about running Microsoft Windows XP on Mac. It also provides specific tips and hints for using Parallels Desktop for Mac.
What do you mean "would not
What do you mean "would not restore"? The "--clean" option is for removing pre-existing data in the database, so if you're restoring into an empty database it makes sense that you'd get errors like "_________ doesn't exist", but that doesn't mean your data wasn't restored. What actual errors are you getting?
I agree that dump/reload is not an ideal solution. There has been some significant effort toward in-place upgrades, and I think it's a possibility in the near future. In the meantime, you have to use something like Slony if you have a lot of data (and that's not an easy process either).
Why did you have to create each database again? That's the point of pg_dumpall. pg_dumpall will recreate all your databases, users, and everything else, while pg_dump is the one that only dumps a single database. Again, without more information it's hard to figure out what went wrong (if anything).
Also, post things like this to pgsql-general. You will no doubt get all your problems resolved very quickly, and it may lead to better documentation so that other users don't have similar problems.