4 ms·
Seeing a service like this makes me wonder if Postgres could support encrypted replication. That would allow using a service like this to provide reliable back
by JoshTriplett 10y ago
Seeing a service like this makes me wonder if Postgres could support encrypted replication. That would allow using a service like this to provide reliable backup without having to trust it with customer data.
- EmielMols 10y agoThanks for this. That would be an ideal scenario for me as well (it's even mentioned in the FAQ). It's technically rather challenging, but when enough users would ask for it, I know putting some resources into it might be viable.
- adrianpike 10y agoThis looks like a potential option; https://github.com/wal-e/wal-e https://github.com/wal-e/wal-e
- anarazel 10y agoWhat exactly do you mean with encrypted replication? Just stream the WAL in an encrypted format, and store it there? Easy enough. But that'll mean that it'll potentially take a long time to re-apply all those changes to a base backup. Actually apply the changes, even though the database and WAL in encrypted? Unlikely, don't really see how that'd be possible. And even if, I'd bet that it'd be fairly easy to generate compression type attacks.
- JoshTriplett 10y agoYou'd need some sort of encryption of the raw data storage, and that would also prevent backing up any indexes. And yes, you'd expose some amount of information, such as row activity. Seems plausible, though, depending on your threat model.
- anarazel 10y agoIf I were to do that I'd use logical decoding (https://www.postgresql.org/docs/current/static/logicaldecoding.html https://www.postgresql.org/docs/current/static/logicaldecodi...) and just write a custom apply mechanism. I think you'll, in any case, end up exposing a lot of information. INSERT/UPDATE/DELETE are going to be discernible, and you'd have to be very careful about compression not exposing things. The backup wouldn't actually be particularly useful though. So I'm not really sure what the use-case here is.
- alfanick 10y agoJust stream it over ssh or vpn tunnel.
- JoshTriplett 10y agoI'm talking about encrypted storage on the other end.