dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #11117
Re: Partial restore using PgAdmin?
Very likely could be foreign key references.
I think MySQL may drop the foreign key references and then recreate
them, but postgres does not.
I am not sure this is exactly the same as a partial restore as they
mention that they drop the db and then recreate it, which should not
be possible with a partial restore.
Obviously seeing the logs from postgres would be useful.
On Tue, Mar 22, 2011 at 9:09 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260974901293
Follow ups
References