Re: Move cluster to new host, upgraded version - Mailing list pgsql-general

On Sun, 11 Nov 2018, Adrian Klaver wrote:

> pg_dumpall is going to need to run against a Postgres server not just a data 
> directory.

Adrian,

   Of course. Yet it's the data directory that's written to the .sql file.

> If both your old and new machines are on the same network, why not just
> point the 11.1 pg_dumpall(on the new machine) at the 9.5 server running on
> the old machine?

   The old host is running 10.5. Haven't tried to run an application on one
host using data on another host. I'll look at which tool will do that.

Thanks,

Rich