CODEWITHSUNDEEP
postgresqlpostgresql-9.6
Ed Mendez
Ed Mendez

Reputation: 1683

How do I upgrade Postgresql 9.6rc1 to Postgresql 9.6

I am fairly new to the PostgreSql scene so forgive me if this is a dumb question. I tried to search for this but, I kept finding only questions on upgrading from one version to another, like from 8.x to 9.x. But Just the other day I upgraded from 9.6beta4 to 9.6rc1 using dumpall, and today i see that 9.6 was released and don't really want to waste a day creating a dumpall file and restoring it. So I'd like to to know if there is an "inplace" upgrade, or do i still need to use dumpall again to go from 9.6rc1 to 9.6.

My main DB experience is with Firebird and Sql Server, and with those you don't need to do a backup restore when upgrading the DB software.

thanks, Edward

Upvotes: 1

Views: 150

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246053

Dump/restore is only necessary if the catalog version has changed; that's CATALOG_VERSION_NO in src/include/catalog/catversion.h.

If you look at the commit log of REL_9_6_STABLE, you'll see that the last change was on 2016-08-13.

So it should be safe to just update the software and restart the server.

Upvotes: 3

Related Questions