Updates
Minor updates in the agreed maintenance window, after reviewing the release notes.
Version upgrades
Planned major version upgrades with testing, a rollback plan and an agreed time window.
PostgreSQL and MySQL administration on your infrastructure
We operate PostgreSQL, MySQL and MariaDB where they run today: updates, backups with point-in-time recovery, replication, 24/7 monitoring and basic performance care.
- PostgreSQL
- MySQL
- MariaDB
- Point-in-time recovery
Starting point
The database runs, but nobody is responsible
In many companies, the database was set up once and has been running along ever since. The risks show when space, version or recovery become an issue.
Version without security updates
Each PostgreSQL major version is maintained for five years. After that there are no more fixes, and the upgrade gets harder every year.
Only a nightly dump
One dump per night means up to a day of data loss. Point-in-time recovery narrows this gap to the time since the last archived log file.
Slow queries without a known cause
Missing indexes, bloated tables or a default configuration slow down the application.
Knowledge held by one person
Often only one employee or a former contractor knows how replication and recovery work.
Services
Scope of database operations
Six building blocks for PostgreSQL, MySQL and MariaDB; the proposal sets out which apply. Not included: application code and data model, Oracle and SQL Server, cloud provider database services.
Backup and PITR
Base backup plus WAL archive (PostgreSQL) or binary log (MySQL, MariaDB), restores tested.
Replication
Setup and monitoring of replicas, documented failover procedure.
24/7 monitoring
Availability, connections, disk space, replication lag, backup status; response to P1 incidents by service level.
Basic performance care
Analyse slow queries, recommend indexes, tune configuration, maintain VACUUM (PostgreSQL) and statistics.
Process
How we take over your database
Four steps from the first look to ongoing operations.
- 01
Assessment
Version, size, configuration, backup, replication and application dependencies.
- 02
Backup first
Before we change anything, a tested backup with point-in-time recovery is in place.
- 03
Monitoring and documentation
Connection to 24/7 monitoring, runbooks for recovery and failover.
- 04
Ongoing operations
Updates, upgrades and basic performance care at the agreed frequency, with a report.
Pricing
Price by database and service level
Single server or cluster, replication, the number and size of databases and the desired service level determine the scope. We state the price in the proposal after the assessment. Individual tasks such as an upgrade are possible at the support rate of €120 excl. VAT / hour.
Database managementPrice in the proposal
Comparison
Database operations or database hosting
Both routes lead to a managed database. The difference is where it runs and who owns the infrastructure.
| Criterion | Database operations (this page) | PostgreSQL hosting |
|---|---|---|
| Infrastructure | Your servers, your cloud, on-premises | provided by WZ-IT |
| Databases | PostgreSQL, MySQL, MariaDB | PostgreSQL |
| Provider contract | stays with you | not needed |
| Fits when | data should stay on your own infrastructure | you do not want to run your own infrastructure |
Frequently Asked Questions
Answers to the most important questions
- Updates within the major version, planned version upgrades, backups with point-in-time recovery, replication, 24/7 monitoring and basic performance care. The database runs on your servers or in your cloud account; WZ-IT handles the agreed operations remotely.
- With PostgreSQL hosting, WZ-IT provides the database as a hosted service. Database operations on this page apply to databases that run on your own infrastructure and should stay there.
- Current versions of PostgreSQL, MySQL and MariaDB supported by their projects. PostgreSQL supports each major version for five years; PostgreSQL 14 reaches end of support on 12 November 2026. We take over older versions after a risk review and with an upgrade plan.
- Point-in-time recovery (PITR) restores a database to any moment after a base backup, for example to just before a faulty delete statement, provided the log files are complete. PostgreSQL uses archived WAL files for this, MySQL and MariaDB use the binary log.
- Basic care includes analysis of slow queries, index recommendations, memory and connection configuration, and maintenance such as VACUUM (PostgreSQL) and statistics. Changes to application code or the data model are handled by your development team or agreed as a separate engagement.
- Monitoring runs 24/7. An outage of the production database is usually a P1 incident; the response follows the agreed service level. With replication, a replica can be promoted to primary according to the agreed procedure.
- The price depends on the number and size of databases, replication and service level and is set out in the proposal. Individual tasks such as a version upgrade are also possible at the support rate of €120 excl. VAT / hour.
Knowledge
Further reading
Versions, comparisons and related services.
Guides
Reviews & projects
Operations that visibly relieve customers
Customer feedback on monitoring, updates, maintenance, support and stable production systems.
Networking & Provisioning
WZ-IT moved our studio infrastructure from decentralised individual devices to a central platform: every site is securely connected via VPN, new devices are onboarded automatically and an entire site is provisioned from a template, without manual steps on location. What impressed me most is the breadth and depth of their knowledge: Timo and Robin are not a typical IT provider who sets up a server and leaves. The two of them think their way into highly complex infrastructure and software topics, work through every requirement we put in front of them, and build networking, provisioning and operations so that everything fits together in the end. WZ-IT is an excellent partner for complex software, network and architecture projects.
Steve KirchnerManaging Director, nextGYM GmbH
International
Built in Germany's Ruhr Valley. Running worldwide.
WZ-IT designs, develops and operates infrastructure and software for clients in Germany and internationally. We deliver projects remotely and continue supporting them in ongoing operations after go-live.
Selected projects
- LiveRemote access platform for distributed water treatment plantsABCO Water Systems · Australia · Secure Access & OT
- 81%AWS migration with substantially lower operating costsEVA Real Estate · UAE · Cloud exit & infrastructure
- 98%Provision new sites in minutes instead of hoursnextGYM GmbH · Germany · Automation & IoT
Read client reviews
Enquiry
Request database operations
For an initial assessment, the database system, version, approximate size and the current state of backup and replication are sufficient. We only need access credentials after commissioning.
- Straight with Timo and Robin - no sales team, no pitch
- A professional assessment of your situation
- Concrete next steps for infrastructure, software or AI
The conversation is free and non-binding.
WZ-IT's advice on our Azure migration was technically sound and completely non-binding right from the intro call - we took away a great deal.
Jakob ÖschlbergerInno7 GmbH
WZ-IT's advice on our Azure migration was technically sound and completely non-binding right from the intro call - we took away a great deal.