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.