Re: v11.5- v15.3 upgrade (linux)

2024-03-08 Thread David Gauthier
Thanks. On Fri, Mar 8, 2024 at 12:12 PM Adrian Klaver wrote: > On 3/8/24 09:09, Adrian Klaver wrote: > > On 3/8/24 08:57, David Gauthier wrote: > >> Thanks for the reply. > >> > >> When you say "dump/restore" do you mean pg_dump then running the > >> resulting SQL into the destination DB? > >> I

Re: v11.5- v15.3 upgrade (linux)

2024-03-08 Thread Adrian Klaver
On 3/8/24 09:09, Adrian Klaver wrote: On 3/8/24 08:57, David Gauthier wrote: Thanks for the reply. When you say "dump/restore" do you mean pg_dump then running the resulting SQL into the destination DB? I like the replication option myself best (min downtime), especially as we use a DB alias

Re: v11.5- v15.3 upgrade (linux)

2024-03-08 Thread Adrian Klaver
On 3/8/24 08:57, David Gauthier wrote: Thanks for the reply. When you say "dump/restore" do you mean pg_dump then running the resulting SQL into the destination DB? I like the replication option myself best (min downtime), especially as we use a DB alias for connections.  But I don't think I'l

Re: v11.5- v15.3 upgrade (linux)

2024-03-08 Thread David Gauthier
Thanks for the reply. When you say "dump/restore" do you mean pg_dump then running the resulting SQL into the destination DB? I like the replication option myself best (min downtime), especially as we use a DB alias for connections. But I don't think I'll be able to sell that to the IT group. Re

Re: v11.5- v15.3 upgrade (linux)

2024-03-08 Thread Yogesh Sharma
Greetings, On 3/6/24 19:19, David Gauthier wrote: Hi: I'm a PG user in a big corp with an IT dept that administers a PG server/instance that I use.  It's an old install, v11.5, and we need to upgrade to v15.3.  They want to bring the upgraded DB up on a new linux vm which has OS upgrades of i

Re: v11.5- v15.3 upgrade (linux)

2024-03-07 Thread Adrian Klaver
On 3/7/24 07:47, David Gauthier wrote: Please reply to list also. Ccing list >>I would definitely read the release notes for 12.0, 13.0, 14.0 and 15.0. Check !  None of the breaking changes affect me. >>How are and from where are you installing the Postgres package(s)? IT does the installs

Re: v11.5- v15.3 upgrade (linux)

2024-03-07 Thread Ron Johnson
Bug fixes for problems (like slow queries) you didn't realize you had, or would have if you later implemented a feature with the bug. (For example, an aggravating weekly manual activity disappeared when I was allowed to update from 9.6.6 to 9.6.24.) And, of course, security bug fixes, Won't you

Re: v11.5- v15.3 upgrade (linux)

2024-03-06 Thread Ron Johnson
On Wed, Mar 6, 2024 at 7:19 PM David Gauthier wrote: > Hi: > I'm a PG user in a big corp with an IT dept that administers a PG > server/instance that I use. It's an old install, v11.5, and we need to > upgrade to v15.3. They want to bring the upgraded DB up on a new linux vm > which has OS upgr

Re: v11.5- v15.3 upgrade (linux)

2024-03-06 Thread Bruce Momjian
On Wed, Mar 6, 2024 at 07:19:20PM -0500, David Gauthier wrote: > Hi:   > I'm a PG user in a big corp with an IT dept that administers a PG server/ > instance that I use.  It's an old install, v11.5, and we need to upgrade to > v15.3.  They want to bring the upgraded DB up on a new linux vm which h

Re: v11.5- v15.3 upgrade (linux)

2024-03-06 Thread Adrian Klaver
On 3/6/24 16:19, David Gauthier wrote: Hi: I'm a PG user in a big corp with an IT dept that administers a PG server/instance that I use.  It's an old install, v11.5, and we need to upgrade to v15.3.  They want to bring the upgraded DB up on a new linux vm which has OS upgrades of its own.  So

v11.5- v15.3 upgrade (linux)

2024-03-06 Thread David Gauthier
Hi: I'm a PG user in a big corp with an IT dept that administers a PG server/instance that I use. It's an old install, v11.5, and we need to upgrade to v15.3. They want to bring the upgraded DB up on a new linux vm which has OS upgrades of its own. So it's a move AND an upgrade. There are 2 conc