Per conversation in Matrix, I'd like the readonly password to datanommer2 so that I can export mini-dumps of the database (either a single day or a single week) to batcave01. This should incur no more load than the existing pg_dump process, and for a much shorter timespan. My PGP key is in FAS if you want to be super secret about it.
I intend to scp these dumps off of Fedora infra to top off my local datanommer from my most-recent full download. I also hope to be able to fully automate this to get it published for others to use alongside the full nightly backup.
Metadata Update from @zlopez: - Issue priority set to: Waiting on Assignee (was: Needs Review) - Issue tagged with: low-gain, low-trouble, ops
I wonder what is needed to be done here, I assume adding @mwinters to some group with read-only access should be enough.
Metadata Update from @kevin: - Issue assigned to kevin
It's not group based. We just need to get him the datanommer_metrics_ro user password.
@mwinters I have placed that info in a file in your homedir on batcave01:
datanommer-ro-info
please handle it with care. :)
Let us know if you have any issues with it.
Metadata Update from @kevin: - Issue close_status updated to: Fixed with Explanation - Issue status updated to: Closed (was: Open)
Log in to comment on this ticket.