Yearly database upgrade scheduled for November 27

News updates about the Prohashing pool
Forum rules
The News forum is only for updates about the Prohashing pool.

Replies to posts in this forum should be related to the news being announced. If you need support on another issue, please post in the forum related to that topic or seek one of the official support options listed in the top right corner of the forums page or on prohashing.com/about.

For the full list of PROHASHING forums rules, please visit https://prohashing.com/help/prohashing- ... rms-forums.
Locked
User avatar
Steve Sokolowski
Posts: 4585
Joined: Wed Aug 27, 2014 3:27 pm
Location: State College, PA

Yearly database upgrade scheduled for November 27

Post by Steve Sokolowski » Wed Oct 02, 2019 10:31 am

We have scheduled the yearly database downtime for Wednesday, November 27. As we have done on Thanksgiving week in previous years, we will again upgrade Postgresql, this time to version 12.

At the same time as the upgrade, we will enable TRIM support on the disks on which Postgres is installed. This feature is necessary to keep the disks operating at a reasonable speed and needs to be done before the next bubble starts. You might recall that we performed these upgrades on the coin daemon servers in early September. The Postgres database has about 4TB of rows in it. Because the disks need to be reformatted, the operation will require copying several terabytes of data to hard drives and then copying it back, so several hours of downtime is expected.

We'll keep everyone updated as the upgrade date approaches.
Locked