Re: Doubt about pg_upgrade with link mode - Mailing list pgsql-admin

From om prash jaiswal
Subject Re: Doubt about pg_upgrade with link mode
Date
Msg-id 1401169065.22048.YahooMailNeo@web190804.mail.sg3.yahoo.com
Whole thread Raw
In response to Re: Doubt about pg_upgrade with link mode  (Luis <luisico@gmail.com>)
List pgsql-admin
Use perl 5.14 or later version for migrating from postgres 9.1 to postgres 9.3.

Regards
Om Prakash



On Monday, 26 May 2014 8:18 PM, Luis <luisico@gmail.com> wrote:


Ok, sorry for the noise. I had a error in my upgrade script, and it
was not being really honored.
Now it worked.

However it still would be great being able to read some article or
documentation that details a little bit information about the link
mode.

Cheers

2014-05-26 16:37 GMT+02:00 Luis <luisico@gmail.com>:
> Hi,
>
> I'm trying to upgrade a PG 9.1 cluster to a 9.3 one.
> I'm trying to use --link to do it in link mode since I don't have much
> disk space for the migration.
>
> I'm not totally sure that the --link parameter is being honored. I
> can't see any mention about link mode in the migration logs and the
> new cluster takes too much space.
>
> I would like to understand how link mode really works. What does it
> link and what does it copy. Unfortunately I didn't find information
> about that. Any link that provides more info would be appreciated.
>
> I've compare inodes from base files in the old data directory and the
> new one and they are different.
>
> copying "/9.1/base/18976/74003" to "/9.3/base/16416/73829"
>
> $ stat /mnt/pg_data/base/18976/74001 --printf=%i
> 12454860
>
> $ stat /mnt/pg_data-9.3/base/16416/73829 --printf=%i
> 10488427
>
> It doesn't seem to be a hard link. Should it?


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


pgsql-admin by date:

Previous
From: goutham goud
Date:
Subject: Re: Oracle Postgres Conversion
Next
From: John Donath
Date:
Subject: invalid page header in block of relation "pg_largeobject"