Re: psql backward compatibility

2020-11-18 Thread Alvaro Herrera
On 2020-Nov-18, Stephen Haddock wrote: > 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? As others have said: yes. > It looks like the recommended method is to dump the data, upgrad

Re: psql backward compatibility

2020-11-18 Thread Ron
On 11/18/20 10:30 AM, Laurenz Albe wrote: On Wed, 2020-11-18 at 11:05 -0500, Stephen Haddock wrote: 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? Since nobody mentioned that explicitly: do n

Re: psql backward compatibility

2020-11-18 Thread Ron
On 11/18/20 10:13 AM, Adrian Klaver wrote: On 11/18/20 8:05 AM, Stephen Haddock wrote: 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 t

Re: psql backward compatibility

2020-11-18 Thread David G. Johnston
On Wed, Nov 18, 2020 at 9:30 AM Laurenz Albe wrote: > On Wed, 2020-11-18 at 11:05 -0500, Stephen Haddock wrote: > > 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? > > Since nobody mentione

Re: psql backward compatibility

2020-11-18 Thread Laurenz Albe
On Wed, 2020-11-18 at 11:05 -0500, Stephen Haddock wrote: > 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? Since nobody mentioned that explicitly: do not upgrade to 9.6. If you upgrade, move

Re: psql backward compatibility

2020-11-18 Thread David G. Johnston
On Wed, Nov 18, 2020 at 9:16 AM Adrian Klaver wrote: > On 11/18/20 8:05 AM, Stephen Haddock wrote: > > 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 th

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, Stephen Haddock wrot

Re: psql backward compatibility

2020-11-18 Thread Adrian Klaver
On 11/18/20 8:05 AM, Stephen Haddock wrote: 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,

Re: psql backward compatibility

2020-11-18 Thread Adrian Klaver
On 11/18/20 8:05 AM, Stephen Haddock wrote: 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,

Re: psql backward compatibility

2020-11-18 Thread David G. Johnston
On Wed, Nov 18, 2020 at 9:05 AM Stephen Haddock wrote: > It appears that 9.6 is able to run against the older cluster (DB service > starts, queries work, etc) > If this is indeed what you've observed you've found a bug because a 9.6 service should not start at all if the data directory it is bei

Re: psql backward compatibility

2020-11-18 Thread Christophe Pettus
> On Nov 18, 2020, at 08:05, Stephen Haddock wrote: > 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? Yes. You cannot run binaries from a newer major version of PostgreSQL on a cluster tha

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