Re: pg_upgrade 9.1.9 ->9.3.1

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

In response to

Browse pgsql-general by date

  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