Re: psql backward compatibility

2020-11-18 Thread Stephen Haddock
Thanks for the quick responses! I'll double-check the configuration. Given your responses it is highly likely that the older version is still running the server and I'm simply running the client in 9.6. On Wed, Nov 18, 2020, 11:16 Adrian Klaver wrote: > On 11/18/20 8:05 AM, St

psql backward compatibility

2020-11-18 Thread Stephen Haddock
Hello, When upgrading an older version of postgres, version 8.4 for example, to a newer version such as 9.6, does the data have to be migrated immediately? It looks like the recommended method is to dump the data, upgrade, initialize a new cluster, and then restore the dumped data into the newer