From: Erik Serrano <eserranos@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date: Tue, 29 Sep 2020 00:02:02 -0300
Message-ID: <CA+dvXXteCbPJZzO2k9mk4rum+8Pr9SJpUdFnmZdNn-SCU3hUDA@mail.gmail.com> (raw)
In-Reply-To: <20200929021752.GA26860@momjian.us>
References: <CA+dvXXt_roXnS4B4smVaP0Yy_E6OiPeOWhesubGXxDCTJ4FFoA@mail.gmail.com>
<20200929021752.GA26860@momjian.us>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: eserranos@gmail.com, bruce@momjian.us, pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
In-Reply-To: <CA+dvXXteCbPJZzO2k9mk4rum+8Pr9SJpUdFnmZdNn-SCU3hUDA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox