From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade 9.1.9 ->9.3.1 |
Date: | 2013-10-25 12:38:30 |
Message-ID: | B6F6FD62F2624C4C9916AC0175D56D880CE3F3FC@jenmbs01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> From: Peter Eisentraut [mailto:peter_e(at)gmx(dot)net]
> On 10/25/13, 7:20 AM, Marc Mamin wrote:
> > Hello,
> >
> > I'm evaluating pg_upgrade and there seems to be something wrong with
> my test:
> > the data get copied within the old data directory instead of the new
> > one
> >
> > Do I have to explicitely set more option or define some environment
> variables ?
> >
> > If this is of concern, there are some redirections with symlinks
> > within the old $PGDATA
> >
> >
> > ./pg_upgrade \
> > --old-datadir "/data/postgresql-data-9"\ --new-datadir
> > "/pgdata/postgresql_93-data-9"\ --old-bindir
> > "/opt/intershop/postgresql-9.1.9-9/bin"\
> > --new-bindir "/opt/intershop/postgresql-9.3.1-9/bin"
> >
> > =>
> >
> > ll /data/postgresql-data-9/tblspc_data/cicpg_logs/
> >
> > drwx------ 3 isdb9 isgrp9 4096 Oct 21 15:48 PG_9.1_201105231
> > drwx------ 3 isdb9 isgrp9 4096 Oct 25 12:26 PG_9.3_201306121
> It appears you are using tablespaces. In that case, that's normal.
which means I cannot take advantage of a separate new file system for the copy and first have to organize enough free place in the "old" one.
correct ?
thanks,
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Veyron | 2013-10-25 13:28:47 | Re: Need help how to manage a couple of daily DB copies. |
Previous Message | Peter Eisentraut | 2013-10-25 12:30:38 | Re: pg_upgrade 9.1.9 ->9.3.1 |