Re: 11 -> 12 upgrade on Debian Ubuntu

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.