dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Does anyone have experience with partial/incremental restore of postgresql dbs?

> 3. I’m having some issues with PGadmin’s restore utility.  It doesn’t seem
> to want to restore to a database which is currently active or already has
> data in it. I’ve found the workaround is to create a new db with a different
> name, restore to that, then take the other one off-line, rename it … old and
> rename the new one.  That’s odd. MySQL utilities don’t seem to have a
> problem with that.  This is important so that I can refresh my local copy of
> the database to work off-line.  Do you have any other suggestions?

Knut