Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] pgdump and restore results in different sizes DB - Mailing list pgsql-admin

From Jean R. Franco
Subject Re: [ADMIN] pgdump and restore results in different sizes DB
Date
Msg-id 9f30edef02a5c0f25f4c72fb191f9512@maila.biz
Whole thread Raw
In response to Re: [ADMIN] pgdump and restore results in different sizes DB  (Michael Vitale <michaeldba@sqlexec.com>)
Responses Re: [ADMIN] pgdump and restore results in different sizes DB
Re: [ADMIN] pgdump and restore results in different sizes DB
List pgsql-admin
Tree view
Hi Michael,

Thanks for replying,

Do you think it would be that big of a size? Over 21G?

Thanks,

4 de Setembro de 2017 08:45, "Michael Vitale" <michaeldba@sqlexec.com> escreveu:

nice benefit of logical dump and restore: bye bye bloat

On September 4, 2017 at 7:35 AM "Jean R. Franco" <jfranco@maila.biz> wrote:

Hello Everyone,

I'm moving a postgresql server from one server to another, both running versions 9.4.10
It's a single large database and I'm using pgdump to export and restoring on the new server.

The thing is, on the old server the database size is 81GB, but when I restore on the new server, it decreases to 60GB

List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description
------------+----------+----------+---------+-------+-------------------+-------+------------+-------------
ecidade | postgres | LATIN1 | C | C | | 60 GB | pg_default |

I'm watching the whole process of restoring it and have no errors.
What could I been doing wrong?

Thanks,

pgsql-admin by date:

Previous
From: Michael Vitale
Date:
Subject: Re: [ADMIN] pgdump and restore results in different sizes DB
Next
From: "Michaeldba@sqlexec.com"
Date:
Subject: Re: [ADMIN] pgdump and restore results in different sizes DB