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

From: Erik Serrano <eserranos(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date: 2020-09-29 13:39:32
Message-ID: CA+dvXXssOceT+Pp3_vxgmov73Be2Dtf=dhX2dEYcsft3QXqA1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
* 998596691*

El mar., 29 sept. 2020 a las 0:03, Bruce Momjian (<bruce(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
> EnterpriseDB https://enterprisedb.com
>
> The usefulness of a cup is in its emptiness, Bruce Lee
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2020-09-29 14:54:31 Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Previous Message David G. Johnston 2020-09-29 03:33:18 many "cp: cannot stat xxx No such file or directory" logs in warm standby