Re: Postgres 10 disk space requirement compared to postgres 9.5.4

Hi Debraj,
I recently upgraded my postgres from 9.5 to 10.3 using pg_upgrade and it
was smooth. There is no separate disk space requirement for migration of
data .
Also before migration you can try "check " option for dry run of migration.
(not actual migration , data will be untouched).Below is command
/usr/pgsql-10/bin/pg_upgrade --old-bindir=<> --new-bindir=<>
--old-datadir=<> --new-datadir=<> --check

On Fri, Aug 3, 2018 at 9:38 AM Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
wrote:

> Yes.
>
> What will be the disk space requirement for space for same set of data in
> 9.5 and 10? I am asking this as I am guessing since we have to do data
> migration so there may be some change in data format.
>
> On Fri 3 Aug, 2018, 9:34 AM suresh neravati, <suresh(dot)neravati(at)yahoo(dot)com>
> wrote:
>
>> Hi Debraj,
>>
>> You can use pg_upgrade utility from Postgresql. This works with inplace
>> option. Look at this link below for more details.
>>
>> PostgreSQL: Documentation: 10: pg_upgrade
>> <https://www.postgresql.org/docs/10/static/pgupgrade.html>
>>
>> PostgreSQL: Documentation: 10: pg_upgrade
>>
>> <https://www.postgresql.org/docs/10/static/pgupgrade.html>
>>
>>
>> This option is also be the fastest for upgrading from 9.5 to PG10
>>
>> Thanks,
>> Suresh Neravati
>>
>> On Thursday, August 2, 2018, 7:28:47 AM PDT, Debraj Manna <
>> subharaj(dot)manna(at)gmail(dot)com> wrote:
>>
>>
>> Hi
>>
>> On moving from postgres 9.5.4 to postgres 10.x we have to do data
>> migration.
>>
>> Can some one let me know will the disk space requirement remain same for
>> same set of tables with same number of rows in postgres 10.x and postgres
>> 9.5.4 ?
>>
>> Thanks,
>>
>

--

To:

With Regards

Sachin

Contact: +91-8123183431
Email: notsachin(at)gmail(dot)com
BANGLORE