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

From Bruce Momjian
Subject Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date
Msg-id 20200929030325.GB26860@momjian.us
Whole thread Raw
In response to Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Erik Serrano <eserranos@gmail.com>)
Responses Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Erik Serrano <eserranos@gmail.com>)
List pgsql-admin
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: Erik Serrano
Date:
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Next
From: Hong Yao
Date:
Subject: Re: many "cp: cannot stat xxx No such file or directory" logs in warm standby