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.
