Re: 11 -> 12 upgrade on Debian Ubuntu

On 11/7/19 7:45 AM, 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.

This should be a dist-upgrade correct?

On a my Ubuntu instance that just installed the Postgres 12 version and
started it(also auto start in start.conf). This was just the template
databases and postgres db. No data was moved over from the 11 instance
that is running.

>
> 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.
>
> Thanks for anyone's input.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com