Обсуждение: PostgreSQL version upgrade (9.1 to 9.2)
As you already know, one way to upgrade a PostgreSQL DB from one version to another is to perform a pg_dump/pg_restore using the commands of the newer version. Does this have the same effect if I use pgAdmin III of the newer version to backup/restore?
Respectfully,
Jorge Maldonado
>As you already know, one way to upgrade a PostgreSQL DB from one version to another is to perform a >pg_dump/pg_restore using the commands of the newer version. Does this have the same effect if I use >pgAdmin III of the newer version to backup/restore? Yes, It gives the same result/effect. pgAdmin III provides the GUI that makes administration easy. It also supports all PostgreSQL feature. Thanks, Vinayak -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-version-upgrade-9-1-to-9-2-tp5752480p5765127.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
What about migration if i have 5 TB database? Via pg_dump it will take a few month. Is there any faster way to do it ?
2013/7/25 vinayak <vinpokale@gmail.com>
Yes, It gives the same result/effect. pgAdmin III provides the GUI that
>As you already know, one way to upgrade a PostgreSQL DB from one version to
another is to perform a >pg_dump/pg_restore using the commands of the newer
version. Does this have the same effect if I use >pgAdmin III of the newer
version to backup/restore?
makes administration easy.
It also supports all PostgreSQL feature.
Thanks,
Vinayak
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-version-upgrade-9-1-to-9-2-tp5752480p5765127.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
On Fri, Jul 26, 2013 at 1:28 PM, Александр Кайданник <kaydannik.a@gmail.com> wrote:
What about migration if i have 5 TB database? Via pg_dump it will take a few month. Is there any faster way to do it ?
Requesting you to use "pg_upgrade" utility for 5TB database Up-gradation:
Thanks & Regards
Raghu Ram