Re: Actualizar PostgreSQL

Se usa el pg_upgrade para no tener que volcar y volver a cargar la base
de datos completa. Pon atención en la opción -k especialmente si tu
base de datos es muy grande.

Importante: el uso de pg_upgrade no te exime de hacer respaldos y tener
un plan de recuperación.

man pg_upgrade

G_UPGRADE(1) PostgreSQL 9.5.2
Documentation PG_UPGRADE(1)

NAME
pg_upgrade - upgrade a PostgreSQL server instance

SYNOPSIS
pg_upgrade -b oldbindir -B newbindir -d olddatadir -D newdatadir [op
tion...]

DESCRIPTION
pg_upgrade (formerly called pg_migrator) allows data stored in
PostgreSQL data files to be upgraded to a later
PostgreSQL major version without the data dump/reload typically
required for major version upgrades, e.g. from
8.4.7 to the current major release of PostgreSQL. It is not
required for minor version upgrades, e.g. from 9.0.1
to 9.0.4.

Major PostgreSQL releases regularly add new features that often
change the layout of the system tables, but the
internal data storage format rarely changes. pg_upgrade uses
this fact to perform rapid upgrades by creating new
system tables and simply reusing the old user data files. If a
future major release ever changes the data storage
format in a way that makes the old data format unreadable,
pg_upgrade will not be usable for such upgrades. (The
community will attempt to avoid such situations.)

pg_upgrade does its best to make sure the old and new clusters
are binary-compatible, e.g. by checking for
compatible compile-time settings, including 32/64-bit binaries.
It is important that any external modules are
also binary compatible, though this cannot be checked by pg_upgrade.

pg_upgrade supports upgrades from 8.4.X and later to the current
major release of PostgreSQL, including snapshot
and alpha releases.

...
-k
--link
use hard links instead of copying files to the new cluster
(use junction points on Windows)
---

On 27/05/16 22:02, Jaime Casanova wrote:
> 2016-05-27 15:26 GMT-05:00 Alberto Cuevas <betocuevas(dot)net(at)gmail(dot)com>:
>> Buenas tardes a todos actualmente trabajo con la versión 9.3 y quisiera
>> actualizar a la 9.5, si tuvieran algun ejemplo por favor.
>>
> Que sistema operativo? Que tamaño de base? Usas algo especial (algo
> que no venga en la distribución estándar de postgres)?
> La forma mas simple es:
> - instalar la nueva versión
> - sacar un backup con el pg_dump del 9.5
> - restaurarlo en la nueva versión
>

--
Sandino Araico Sánchez
http://sandino.net