Roland Mas <[email protected]> writes: > Olivier Berger, 2014-04-30 22:33:40 +0200 : > >> Hi. >> >> TL;DR Has anyone experience with PITR backup/restoring in PostGreSQL ? > > [...] > >> 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 :-/ > > Something that should probably be investigated before going complex > routes such as snapshotting: > > # rm -rf /var/lib/postgresql > # cp -a --reflink=auto /var/lib/postgresql.backup /var/lib/postgresql > > That's pretty much instant on Btrfs. >
Yeah, I've been thinking the same, after I had experimented with PITR ;) Even without btrfs I guess it should be quicker than the current SQL loading procedure, on most FS. Best regards, -- 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
