Re: pg_upgrade 9.1.9 ->9.3.1

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, "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:30:38
Message-ID: 526A646E.7080705@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2013-10-25 12:38:30 Re: pg_upgrade 9.1.9 ->9.3.1
Previous Message Elliot 2013-10-25 12:26:13 Re: Count of records in a row