On 26/01/2020 22:47, Andrus wrote:
> Hi!
>
>> Before you do any of this I would check the Release Notes for the
>> first release of each major release. Prior to version 10 that would be
>> X.X.x where X is a major release. For 10+ that is X.x. I would also
>> test the upgrade before doing it on your production setup.
>
> I want to create test transfer first, check applications work and after
> that final transfer.
>
>> Best practice if you are going the dump/restore route is to use the
>> pg_dump binary from the new server(12) to dump the old server(9.1)
>
> Postgres version 12 pg_dump probably cannot installed in old server
> (Debian Squeeze 9).
I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo:
https://apt.postgresql.org
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie