Re: PostgreSQL version upgrade (9.1 to 9.2)

From: Александр Кайданник <kaydannik(dot)a(at)gmail(dot)com>
To: vinayak <vinpokale(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL version upgrade (9.1 to 9.2)
Date: 2013-07-26 07:58:24
Message-ID: CAD_EgNLsvHGsBkffHHsAFTbQHbfuOSmJETSxUSS1FgwgUAKBYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message James David Smith 2013-07-26 09:24:26 Fwd: Tricky join and update with same table
Previous Message vinayak 2013-07-25 12:47:48 Re: PostgreSQL version upgrade (9.1 to 9.2)