HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is there a version history for the Postgres upgrades made in the installation?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
themadepostgreshistoryversioninstallationforupgradesthere

Problem

I'm trying to determine when the last Postgres upgrade was made. I know my current version (through "show server_version" command, and other ways too). But I wasn't able to find a history of the last upgrades and the respective dates. Is there such a thing?

An analogy: this can be achieved with the file $II_SYSTEM/ingres/version.dat in an Ingres DBMS.

Solution

You're using Redhat, so it's stored under dnf history list. It's a function of the package manager, not the database. You can build your own PostgreSQL and install and that won't show under the package manager.

The database engine itself doesn't track revisions to itself in the database: and, it would be weird if it did. If Redhat issues an upgrade and restarts the server, the server is supposed to know that Redhat issued an upgrade? What if the upgrade was a minor fix that Redhat pushed out ahead of PostgreSQL?

Context

StackExchange Database Administrators Q#195723, answer score: 2

Revisions (0)

No revisions yet.