Upgrade 9.2 to 9.6 without modifying the location of the tablespaces

From: Erik Serrano <eserranos(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date: 2020-09-29 02:17:39
Message-ID: CA+dvXXt_roXnS4B4smVaP0Yy_E6OiPeOWhesubGXxDCTJ4FFoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

*Erik R. Serrano Saavedra*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2020-09-29 02:17:52 Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Previous Message Ian Barwick 2020-09-28 05:28:55 Re: many "cp: cannot stat xxx No such file or directory" logs in warm standby