From: | Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | database size changed after restoring using pg_restore |
Date: | 2017-11-08 22:59:40 |
Message-ID: | ae182f2365a843f4981146e5df960098@ITUPW-EXMBOX3B.UniNet.unisa.edu.au |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I am upgrading some databases from a PostgreSQL 9.2 server to a new PostgreSQL 9.6 server.
I used pg_dump and pg_restore for the upgrade.
This is the command I used to dump the database. I ran the command from the 9.6 server.
pg_dump -h 9.2server -j 16 --format=directory -f /pg_backup/backup/dump/mydb-20171108.dmp -U postgres -W mydb
This is the command I used to restore the database on the 9.6server.
pg_restore -j 16 -C -d postgres /pg_backup/backup/dump/mydb-20171108.dmp
Everything appears ok, the dump and restore completed without and errors.
But when I listed the size of the database (postgres=# \l+) between the 9.2 and the upgraded 9.6, they were different.
on 9.2 it was 3776 MB
on 9.6 it was 1570 MB
I also did a few more databases using the same steps and they all appeared to be smaller. Is that normal?
Regards
Dylan
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2017-11-08 23:23:20 | Re: database size changed after restoring using pg_restore |
Previous Message | John R Pierce | 2017-11-08 21:34:04 | Re: Because PostgreSQL is compiling in old versions of OS? |