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
Erik R. Serrano Saavedra
El lun., 28 sept. 2020 a las 23:17, Bruce Momjian (<bruce@momjian.us>) escribió:
On Mon, Sep 28, 2020 at 11:17:39PM -0300, Erik Serrano wrote: > Hello, I would like to know if there is any way to upgrade from a 9.2 to 9.6 > version without modifying the location of the tablespaces since I have no more > disks. > Since one of the actions carried out within an upgrade is the creation of new > clusters and the movement of the data from the old location to the new > location. > > Is it possible to perform? > > my server data is: > Operating system: linux Red Hat 6.8 > base size: 1101 GB > discs : > /dev/sdb1 1008G 713G 245G 75% /opt/data_postgres > /dev/sdd1 512G 397G 90G 82% /opt/data_postgres2 > > Thank you very much in advance.
Just move the tablespaces before or after the upgrade: