| Create a schema only dump with the 7.2 pg_dump. | Create a data only dump (possibly with INSERT output) with the 7.3 | pg_dump. Assuming you haven't done anything too wacky, you should be | able to drop your 7.2 database, reload the 7.2 schema, then load up the | 7.3 data. As always, test this out before doing it on a production | system. |
Thanks a lot for this quick explanation, this is very helpful! By the way, is there a possibility to just do incremental dumps/restores? Say, since a given date? Ulf ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html