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+dvXXssOceT+Pp3_vxgmov73Be2Dtf=dhX2dEYcsft3QXqA1g@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  (Keith <keith@keithf4.com>)
Список pgsql-admin
Дерево обсуждения
 I will do a laboratory testing that technique, to see if it works for me.
 Thank you very much!  Bruce,   


Erik R. Serrano Saavedra
Ingeniero de Sistemas Informáticos
      Data Base Administrator
        eserranos@gmail.com
                 998596691


El mar., 29 sept. 2020 a las 0:03, Bruce Momjian (<bruce@momjian.us>) escribió:
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@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

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

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: many "cp: cannot stat xxx No such file or directory" logs in warm standby
Следующее
От: Keith
Дата:
Сообщение: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces