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....@gmail.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