Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces - Mailing list pgsql-admin

From Erik Serrano
Subject Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date
Msg-id CA+dvXXssOceT+Pp3_vxgmov73Be2Dtf=dhX2dEYcsft3QXqA1g@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Keith <keith@keithf4.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: many "cp: cannot stat xxx No such file or directory" logs in warm standby
Next
From: Keith
Date:
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces