Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Erik Serrano <eserranos(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date: 2020-09-29 03:03:25
Message-ID: 20200929030325.GB26860@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Sep 29, 2020 at 12:02:02AM -0300, Erik Serrano wrote:
> Thank you very much Bruce, I update the binary and the data in this way:
>
>
> bash# /usr/pgsql-9.6/bin/pg_upgrade --old-datadir /var/lib/pgsql/data/
> --new-datadir /var/lib/pgsql/9.6/data/ --old-bindir /usr/bin/ --new-bindir /usr
> /pgsql-9.6/bin/
>
>
> And in that I would like to know if it is essential to move the data?. Remember
> that I do not have space on the disks to make a tablespaces move
> thank u  Bruce

Use link mode so you don't need double the disk space.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hong Yao 2020-09-29 03:05:22 Re: many "cp: cannot stat xxx No such file or directory" logs in warm standby
Previous Message Erik Serrano 2020-09-29 03:02:02 Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces