3 ms·
just wondering, did you have to plan a maintenance downtime for doing all that or could it be done without interrupting the production DB?
by 11235813213455 8y ago
just wondering, did you have to plan a maintenance downtime for doing all that or could it be done without interrupting the production DB?
- beatgammit 8y agoNot OP, but I imagine you could just duplicate the DB into a test environment to mess around with it.
- bshipp 8y agoThat's exactly what it was. I had a bit of time after buying the server before I wanted to deploy it in production so I copied the last backup over and just started messing around. Because this database primarily ingests data from outside sources and doesn't drive user experiences, I was able to easily duplicate the data flow to replicate the production environment. I recognize this would be a much different beast when it comes to a database that supports a hundred thousand users or something. However, Postgresql does have the ability to do hot standby and streaming replication so it's likely not as difficult as one might imagine. https://www.postgresql.org/docs/current/warm-standby.html https://www.postgresql.org/docs/current/warm-standby.html