Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
Date: 2024-12-03 01:08:44
Message-ID: 20241203010844.3cqe6ds6ainih4b3@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2024-12-03 00:25:15 +0000, Bharani SV-forum wrote:
> qsn1: What is the size of database(s) you are dealing with?
> ans1: roughly 25 GB (maximum size)
>
> qsn2 : What sort of downtime can you afford?
> ans2: can be maximum 30 mins or so

That does seem sufficient time to dump/restore a 25 GB database, so
that's what I'd try first. It's simple and you can easily test it
without disruption.

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-12-03 01:17:21 Re: Errors when restoring backup created by pg_dumpall
Previous Message Bharani SV-forum 2024-12-03 00:25:15 Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X