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.

Roland.
-- 
Roland Mas

Et c'est tellement plus mignon de se faire traiter de con en chanson...
  -- in En chantant (Michel Sardou)

_______________________________________________
Fusionforge-general mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general

Reply via email to