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

Поиск
Список
Период
Сортировка
От Erik Serrano
Тема Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Дата
Msg-id CA+dvXXteCbPJZzO2k9mk4rum+8Pr9SJpUdFnmZdNn-SCU3hUDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-admin
Дерево обсуждения
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


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:

        https://momjian.us/main/blogs/pgblog/2018.html#October_3_2018

There is no way to move them during the upgrade.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces