Opened 2 years ago

Closed 2 years ago

#11957 closed Feature/Enhancement Request (fixed)

Are there some Postgres DB backups on some machines (for members) ?

Reported by: https://id.mayfirst.org/gripuqam Owned by: https://id.mayfirst.org/jaimev
Priority: Medium Component: Tech
Keywords: Cc:
Sensitive: no

Description

I was reading #7869 juste passing by. I am not sure if I can understand that Postgres DB on chelsea are backuped?

  • Have things changed since that time ?
  • Would it be possible to add a few other hosts for automatic backup ?
  • I makes me think to a theoretical security kind of issue, if I have read that if they are no DB it may cause a problem (but there is always a postgres DB and a few other administrative DB in appearance). This is because I never tested if members can delete their Postgres DB, which could produce a situation with no more DB.

By the way, I can make DB backups, I do not need them. Sure it will be a nice feature to have some day.

Change History (4)

comment:1 Changed 2 years ago by https://id.mayfirst.org/jaimev

  • Owner set to https://id.mayfirst.org/jaimev
  • Status changed from new to assigned

Yes it appears the puppet module described in that ticket was implemented and is now deployed automatically to servers running postgres. Backups of all postgres dbs are being made locally to each of those servers daily and synced to remote storage where the last 5 days of backups are held.

comment:2 Changed 2 years ago by https://id.mayfirst.org/jaimev

  • Resolution set to fixed
  • Status changed from assigned to feedback

Let me know if you have any additional questions about this.

comment:3 Changed 2 years ago by https://id.mayfirst.org/gripuqam

  • Resolution fixed deleted
  • Status changed from feedback to assigned

Your answer is very clear, it is a nice security net to have, thanks!

comment:4 Changed 2 years ago by https://id.mayfirst.org/gripuqam

  • Resolution set to fixed
  • Status changed from assigned to closed

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.