From: om prash jaiswal <op12om@yahoo.co.in>
To: Luis <luisico@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Doubt about pg_upgrade with link mode
Date: Tue, 27 May 2014 13:37:45 +0800 (SGT)
Message-ID: <1401169065.22048.YahooMailNeo@web190804.mail.sg3.yahoo.com> (raw)
In-Reply-To: <CAM-gcbQ=A+x+hbzwZq2+Ys2kP8oQMx47yry6MhTZQUaeKdgORA@mail.gmail.com>
References: <CAM-gcbR0i+dunsiMaCz8Wdj3J3C=23XLCXhQMJ1QAMTkC6xLbg@mail.gmail.com>
<CAM-gcbQ=A+x+hbzwZq2+Ys2kP8oQMx47yry6MhTZQUaeKdgORA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in, luisico@gmail.com
Subject: Re: Doubt about pg_upgrade with link mode
In-Reply-To: <1401169065.22048.YahooMailNeo@web190804.mail.sg3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox