Yesterday, a Facebook memory reminded me of an old issue with FreshPorts: serial values which are about to overflow. This is where you may be thinking? serial? In this day? You might also think, why serial? Why not UUID. Keep thinking about that. Some of the tables we’re talking about were designed 20+ years ago. […]
Converting from int to bigint and from serial to identity Read More »
When the website enters maintenance mode, there are a few steps to ensure the database is not updated while we dump the data, but still allow the website to display pages. Disable ingress commit processing In the ingress host (for example, x8dtu-ingress01), stop the FreshPorts daemon: [dan@x8dtu-ingress01:~] $ sudo svc -d /var/service/freshports/ [dan@x8dtu-ingress01:~] $ Ensure
Upgrading the database Read More »
This procedure is rarely used, but is documented nonetheless. A database server change is usually accomplished by moving the IP address from one server to another, not by adjusting the clients. The production database server is usually at 127.1.54.32. When changing from one database server to another, there are a few configuration files to update:
Swapping database servers Read More »