Hi. TL;DR Has anyone experience with PITR backup/restoring in PostGreSQL ?
I've tried and continue tests of using docker to run the test suite, and as expected, the tests are much faster, when run inside a docker container, than inside a full virtualbox VM (I'll try and improve the docs for setting up a docker test env ASAP). At least for the part of PHPUnit and Selenium that executes individual test cases. However, the still really slow part is the DB restoration between test cases (db_reload.sh). Maybe it isn't optimal due to the way the union FS of docker is setup, but I fear it is indeed really slow in any case. And it is performed very often :-/ I'm not so sure it is possible to use some snapshoting, as Sylvain suggested, to speed-up things if the test suite and the tested fusionforge run inside the same container. I could imagine to run the phpunit part on the host and the DB inside a container, which indeed could offer some snapshotting options, but that's a much more different architecture than the current one, so I'm not sure it's possible to expect this in the near future... In any case, there may be something to try on the dump loading side, as it is indeed the bigest bottleneck I can see for the moment, as Christian suggested. Has anyone tried PITR recovery in PostGreSQL [0] by any chance ? It seems to me this could be an interesting option to consider. I'll try and investigate, to compare with the psql < dump current option. Comments ? [0] http://www.postgresql.org/docs/9.1/static/continuous-archiving.html BAYLE Christian <[email protected]> writes: > Le 21/03/2014 14:45, Sylvain Beucler - Inria a écrit : >>> It could be interesting to replace this with docker if it's possible to >>> use snapshot function >>> to roll back after every test, instead or reseting the database as we >>> do. >> Hmmm, don't you think it will actually be much slower then restoring >> the small test db? >> postgresql (or VM?) stop / restore snapshot / restart postgresql, >> between each test... >> > droping / reloading the db is rather slow, so i'm not sure it's faster > than restoring a snapshot > > Christian > > _______________________________________________ > Fusionforge-general mailing list > [email protected] > http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general > -- Olivier BERGER http://www-public.telecom-sudparis.eu/~berger_o/ - OpenPGP-Id: 2048R/5819D7E8 Ingenieur Recherche - Dept INF Institut Mines-Telecom, Telecom SudParis, Evry (France) _______________________________________________ Fusionforge-general mailing list [email protected] http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general
