On Tue, 2022-07-05 at 22:24 +0530, shashidhar Reddy wrote:
> Could some please let me know how to upgrade postgresql version 8.2 to 13,
> as the database size is 20 TB, backup and restore is not possible.
Then you will probably have to use Slony, and pray to a deity of your choice.
Yours,
Laurenz
Thank you all for the inputs, any one tried upgrading from 8.2 to 8.4 and
then used pg_upgrade to upgrade it to any higher version.
On Wed, 6 Jul, 2022, 12:01 am Michael Nolan, wrote:
> I had a client that was stuck on 8.2 for a long time, when they finally
> upgraded to 10, it took several week
I had a client that was stuck on 8.2 for a long time, when they finally
upgraded to 10, it took several weeks of testing to find things that needed
to be changed in scripts, functions and PHP programs. And even then we
were still finding type cast issues for another year in seldom-used SQL
code.
On Tue, Jul 5, 2022 at 11:05 AM Adrian Klaver
wrote:
> On 7/5/22 10:56 AM, shashidhar Reddy wrote:
> > Down time 10 to 15 hrs
> > Hardware specs are also not sure for now as it is client machine.
>
> This is going to be a difficult task for the following reasons:
>
> In other words there is going
On 7/5/22 10:56 AM, shashidhar Reddy wrote:
Down time 10 to 15 hrs
Hardware specs are also not sure for now as it is client machine.
This is going to be a difficult task for the following reasons:
1) pg_upgrade(https://www.postgresql.org/docs/current/pgupgrade.html)
only goes back to 8.4. So
Down time 10 to 15 hrs
Hardware specs are also not sure for now as it is client machine.
On Tue, 5 Jul, 2022, 11:22 pm Adrian Klaver,
wrote:
> On 7/5/22 10:48 AM, shashidhar Reddy wrote:
>
> Reply to list also
>
> Ccing list
>
> > Hello Adrian,
> >
> > Os is Ubuntu not sure about the version I
On 7/5/22 10:48 AM, shashidhar Reddy wrote:
Reply to list also
Ccing list
Hello Adrian,
Os is Ubuntu not sure about the version I am looking for the low
downtime method it may be on same or different machine but same machine
is preferable
Hardware specs?
How low is low for downtime?
On 7/5/22 9:54 AM, shashidhar Reddy wrote:
Hello,
Could some please let me know how to upgrade postgresql version 8.2 to
13, as the database size is 20 TB, backup and restore is not possible.
This is going to need more information:
1) Are you looking to upgrade on same machine or between mac
Hello,
Could some please let me know how to upgrade postgresql version 8.2 to 13,
as the database size is 20 TB, backup and restore is not possible.
Regards,
Shashidhar
