Re: How to transfer databases form one server to other

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