Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL version upgrade (9.1 to 9.2) - Mailing list pgsql-novice

From Александр Кайданник
Subject Re: PostgreSQL version upgrade (9.1 to 9.2)
Date
Msg-id CAD_EgNLsvHGsBkffHHsAFTbQHbfuOSmJETSxUSS1FgwgUAKBYw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL version upgrade (9.1 to 9.2)  (vinayak <vinpokale@gmail.com>)
Responses Re: PostgreSQL version upgrade (9.1 to 9.2)  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-novice
Tree view
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>

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


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: vinayak
Date:
Subject: Re: PostgreSQL version upgrade (9.1 to 9.2)
Next
From: James David Smith
Date:
Subject: Fwd: Tricky join and update with same table