Re: [GENERAL] database size changed after restoring using pg_restore

On 11/8/2017 2:59 PM, Dylan Luong wrote: 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. . But when I listed the size of the database (postgres=# \l+) between the 9.2 and the upgraded 9.6,

Re: [GENERAL] database size changed after restoring using pg_restore

På onsdag 08. november 2017 kl. 23:59:40, skrev Dylan Luong < dylan.lu...@unisa.edu.au >: 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

[GENERAL] database size changed after restoring using pg_restore

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