Discussion:
Backup Datomic via pg_dump
Scott Klarenbach
2017-08-14 15:57:41 UTC
Permalink
Using the postresql storage, is it possible to just use pg_dump as the backup and restore option, or do I have to use the backup command in bin?

Thanks.
--
You received this message because you are subscribed to the Google Groups "Datomic" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datomic+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Scott Klarenbach
2017-08-14 18:05:14 UTC
Permalink
To clarify, I know it's "possible" since I'm able to dump and restore in
dev environments. I'm just wondering if there is a good reason NOT to use
this as my backup strategy compared to the backup command in bin. I've
already got scripts setup to pg_dump other dbs, and it would be nice to
have datomic backups included in this existing cron task.
Post by Scott Klarenbach
Using the postresql storage, is it possible to just use pg_dump as the
backup and restore option, or do I have to use the backup command in bin?
Thanks.
--
You received this message because you are subscribed to the Google Groups "Datomic" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datomic+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Linus Ericsson
2017-08-14 18:25:57 UTC
Permalink
One reason would be that the backup is diffing (I have no idea of how
pg_dump works, since the maturity it must have something similar), another
interesting feature is that restoring the data discards some garbage and
gives a more compact structure.

Another reason could be that you can easily restore the data to some other
storage and to various points in time (limited to the timestamps of the
backups, though).

I think the datomic backup/-restore works very, very well, but if you have
another solution which works good for you, then go for it!

/Linus
Post by Scott Klarenbach
To clarify, I know it's "possible" since I'm able to dump and restore in
dev environments. I'm just wondering if there is a good reason NOT to use
this as my backup strategy compared to the backup command in bin. I've
already got scripts setup to pg_dump other dbs, and it would be nice to
have datomic backups included in this existing cron task.
Post by Scott Klarenbach
Using the postresql storage, is it possible to just use pg_dump as the
backup and restore option, or do I have to use the backup command in bin?
Thanks.
--
You received this message because you are subscribed to the Google Groups "Datomic" group.
To unsubscribe from this group and stop receiving emails from it, send an
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Datomic" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datomic+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...