| 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 02:17:52 |
| Message-ID: | 20200929021752.GA26860@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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:
https://momjian.us/main/blogs/pgblog/2018.html#October_3_2018
There is no way to move them during the upgrade.
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Serrano | 2020-09-29 03:02:02 | Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces |
| Previous Message | Erik Serrano | 2020-09-29 02:17:39 | Upgrade 9.2 to 9.6 without modifying the location of the tablespaces |