Re: 11 -> 12 upgrade on Debian Ubuntu

[Alan Hodgson <ahodgson@xxxxxxxxxxxxxxx>]

On Thu, 2019-11-07 at 10:45 -0500, stan wrote:

I am in the middle of a project, and it looks like version 12 is now what

the Debian/Ubuntu package managers want to update to. 

I of course, will do this first on a test machine, not the "production", or

"develop,met" machines, but I thought i would solicit the group wisdom on

this.

Are there any things I should watch out for here? Will my data be preserved

during this upgrade? We are just beginning to put real data in the

"production" instance, and just yesterday, I set up a script to do backups

using pg_basebackup. BTW this is the 1st time I have sued this, having

used pg_dump in the past. Database is fairly small with just one

tablespace if that matters.

You always need to use pg_dump or pg_upgrade to upgrade to a new major version of PostgreSQL.