pg_upgrade link mode

From: Fabio Rueda Carrascosa <avances123(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade link mode
Date: 2013-05-16 17:42:15
Message-ID: CAA3M-fb28v+gH=qtLNW94VA7Z+yZw8+dSfRAPtX-3+Two+uYLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I have a 9.1 cluster with 50 databases, only one table per db with
2000 rows only, but a lot of schema around each one (postgis databases)

The old cluster size is 1GB

du -chs /var/lib/postgresql/9.1/main/
1.1G

now I run a pg_upgrade to 9.2 with hard link mode,

pg_upgrade --link \
--old-datadir=/var/lib/postgresql/9.1/main \
--new-datadir=/var/lib/postgresql/9.2/main \
--old-bindir=/usr/lib/postgresql/9.1/bin \
--new-bindir=/usr/lib/postgresql/9.2/bin

du -chs /var/lib/postgresql/9.2/main/
880M

Is the expected behaviour? I can't double the space in production.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JotaComm 2013-05-16 17:44:18 Re: WAL contains references to invalid pages
Previous Message Tom Lane 2013-05-16 17:36:12 Re: 9.3 beta and materialized views