From: Jean R. Franco <jfranco@maila.biz>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pgdump and restore results in different sizes DB
Date: Mon, 04 Sep 2017 18:16:37 +0000
Message-ID: <a601349707d04867756f2bdaf3d708c5@maila.biz> (raw)
In-Reply-To: <CAHw75vvBmzJMhv6_R8mjRCAb_zh8zgZu=Jn7awdSoFv=8wcQMw@mail.gmail.com>
References: <CAHw75vvBmzJMhv6_R8mjRCAb_zh8zgZu=Jn7awdSoFv=8wcQMw@mail.gmail.com>
<3e75543bdc093c158f050b3dfc0afe8e@maila.biz>
<1758120710.400302.1504525501413@email.1and1.com>
<9f30edef02a5c0f25f4c72fb191f9512@maila.biz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Thanks Keith,
I´m afraid that this is also going to be my problem!
Best regards,
4 de Setembro de 2017 13:02, "Keith" escreveu:
On Mon, Sep 4, 2017 at 8:36 AM, Jean R. Franco wrote:
Hi Michael,
Thanks for replying,
Do you think it would be that big of a size? Over 21G?
Thanks,
Most certainly. I've cleaned up hundreds of gigs when a system had never done any serious bloat monitoring/cleanup before.
https://www.keithf4.com/cleaning-up-postgresql-bloat/ (https://www.keithf4.com/cleaning-up-postgresql-bloat/)
Keith
4 de Setembro de 2017 08:45, "Michael Vitale" escreveu:
nice benefit of logical dump and restore: bye bye bloat On September 4, 2017 at 7:35 AM "Jean R. Franco" 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,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jfranco@maila.biz
Subject: Re: pgdump and restore results in different sizes DB
In-Reply-To: <a601349707d04867756f2bdaf3d708c5@maila.biz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox