Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M47015=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1dophB-0006UM-1E
	for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 11:37:37 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M47015=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1dophA-0003Pd-Bv
	for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 11:37:36 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <jfranco@maila.biz>)
	id 1dopfL-00089i-45
	for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 11:35:43 +0000
Received: from my.maila.biz ([138.118.35.245])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <jfranco@maila.biz>)
	id 1dopfD-0007py-Q1
	for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 11:35:41 +0000
Received: (Haraka outbound); Mon, 04 Sep 2017 11:35:32 +0000
Authentication-Results: my.maila.biz; auth=pass (login)
Received: from webmail.maila.biz
 (e9fe2f8a-27e0-4f92-a13d-5b2f3de0e680.cloudron [172.18.0.21])
	by my.maila.biz (Haraka/2.8.13) with ESMTPA id
 A10DF51E-518E-4666-AA86-F8C66C3C1C63.1
	envelope-from <jfranco@maila.biz> (authenticated bits=0);
	Mon, 04 Sep 2017 11:35:31 +0000
Mime-Version: 1.0
Date: Mon, 04 Sep 2017 11:35:31 +0000
Content-Type: multipart/alternative;
 boundary="--=_RainLoop_683_611582063.1504524931"
X-Mailer: RainLoop/1.11.1
From: "Jean R. Franco" <jfranco@maila.biz>
Message-ID: <3e75543bdc093c158f050b3dfc0afe8e@maila.biz>
Subject: pgdump and restore results in different sizes DB
To: pgsql-admin@postgresql.org
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on 8cf618c304ea
X-Spam-Level: 
X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED,HTML_MESSAGE
	autolearn=ham autolearn_force=no version=3.4.1
DKIM-Signature: 
 v=1;a=rsa-sha256;bh=zrfq4TVosFlUJKX1yWq/Sg/O56XHDCwtmWqAkbUZQr8=;c=relaxed/simple;d=maila.biz;h=from:subject:date:message-id:to:mime-version;s=cloudron;b=c3r+Tp92WJHnwfao54NG7fi69vvZ6v+5RmJ76laJYL1/QdKWhqbqC6eqWhi1i7AZjyjU6ew7pM1/5K6XK51CKlWq532LrAK9DorFVt90sbWvQ4nZLi/I5WjsArA2JM23gL7QqaPFvGI7uuIHduArzZR8+s46pj/zmWd63ViA/X0=
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


----=_RainLoop_683_611582063.1504524931
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hello Everyone,=0A=0AI'm moving a postgresql server from one server to an=
other, both running versions 9.4.10=0AIt's a single large database and I'=
m using pgdump to export and restoring on the new server.=0A=0AThe thing =
is, on the old server the database size is 81GB, but when I restore on th=
e new server, it decreases to 60GB=0A=0A List of databases=0A Name | Owne=
r | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | =
Description=0A------------+----------+----------+---------+-------+------=
-------------+-------+------------+-------------=0A ecidade | postgres | =
LATIN1 | C | C | | 60 GB | pg_default |=0A=0AI'm watching the whole proce=
ss of restoring it and have no errors.=0AWhat could I been doing wrong?=
=0A=0AThanks,

----=_RainLoop_683_611582063.1504524931
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><meta http-equiv=3D"Content-Type" content=3D"t=
ext/html; charset=3Dutf-8" /></head><body><div data-html-editor-font-wrap=
per=3D"true" style=3D"font-family: arial, sans-serif; font-size: 13px;"> =
<signature></signature><br>Hello Everyone,<br><br>I'm moving a postgresql=
 server from one server to another, both running versions 9.4.10<br>It's =
a single large database and I'm using pgdump to export and restoring on t=
he new server.<br><br>The thing is, on the old server the database size i=
s 81GB, but when I restore on the new server, it decreases to 60GB<br><br=
> List of databases<br> Name | Owner | Encoding | Collate | Ctype | Acces=
s privileges | Size | Tablespace | Description<br>------------+----------=
+----------+---------+-------+-------------------+-------+------------+--=
-----------<br> ecidade | postgres | LATIN1 | C | C | | 60 GB | pg_defaul=
t |<br><br>I'm watching the whole process of restoring it and have no err=
ors.<br>What could I been doing wrong?<br><br>Thanks,<br><br> </div></bod=
y></html>

----=_RainLoop_683_611582063.1504524931--