[Mapbender-dev] Database integrity?

[Michael Schulz]

Hi,

> > Is it possible to dump the mapbender database and restore it in one go
> > (e.g. for copying it, backup), without disabling the referential
> > integrity checks?
>
> Which database? In postgres you could try to create a backup-database
> using the existing as a template. not tested!

Sorry, i was referring to a postgres/utf8 mapbender database.

Using templates for copying is an interesting idea when you are on the
same machine. You couldn't use ist across servers, because then were
in the dump trap again.

>
> > At the moment, it's not possible to do that because of left-overs in
> > several tables, that conflict with FK constraints (e.g. wms_id 336 in
> > wms_format). Are there other reasons why it wouldn't work?
>
> Why not get rid of the left-overs?

Yep, I think so too.

Cheers, Michael

-- 
-----------------------------------------------------------
Michael Schulz
mschulz at webgis.de

in medias res
Gesellschaft für Informationstechnologie mbH

In den Weihermatten 66
79108 Freiburg

Tel  +49 (0)761 556959-5
Fax +49 (0)761 556959-6

http://www.webgis.de / http://www.zopecms.de
-----------------------------------------------------------