Postgres Pro
Downloads
Home   >   mailing lists

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

From Erik Serrano
Subject Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Date
Msg-id CA+dvXXt_roXnS4B4smVaP0Yy_E6OiPeOWhesubGXxDCTJ4FFoA@mail.gmail.com
Whole thread Raw
Responses Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view
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.



Erik R. Serrano Saavedra

pgsql-admin by date:

Previous
From: Ian Barwick
Date:
Subject: Re: many "cp: cannot stat xxx No such file or directory" logs in warm standby
Next
From: Bruce Momjian
Date:
Subject: Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces