Submitted by Anonymous (not verified) on Fri, 2008-02-15 05:54.
If you had called pg_dump with the proper options, restore would have created the databases:
pgdump -? reveales:
-C, --create include commands to create database in dump
And pg_dumpall recreates the whole engine with all databases.
Better to read release notes next time you try to upgrade :-)
My mileage with MySQL varies a lot: It was impossible to lift 3.23-type databases to 4.x or 5.x, because they changed the timestamp format between versions completely incompatible. Such a thing never happened to me with PostgreSQL (And I use it since more than 8 years quite heavily).
»
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.
If you had called pg_dump
If you had called pg_dump with the proper options, restore would have created the databases:
pgdump -? reveales:
-C, --create include commands to create database in dump
And pg_dumpall recreates the whole engine with all databases.
Better to read release notes next time you try to upgrade :-)
My mileage with MySQL varies a lot: It was impossible to lift 3.23-type databases to 4.x or 5.x, because they changed the timestamp format between versions completely incompatible. Such a thing never happened to me with PostgreSQL (And I use it since more than 8 years quite heavily).