Mime-Version: 1.0
Date: Mon, 04 Sep 2017 12:36:03 +0000
Content-Type: multipart/alternative;
 boundary="--=_RainLoop_548_485622872.1504528563"
From: "Jean R. Franco" <jfranco@maila.biz>
Message-ID: <9f30edef02a5c0f25f4c72fb191f9512@maila.biz>
Subject: Re: pgdump and restore results in different sizes DB
To: "Michael Vitale" <michaeldba@sqlexec.com>, pgsql-admin@postgresql.org
In-Reply-To: <1758120710.400302.1504525501413@email.1and1.com>
References: <1758120710.400302.1504525501413@email.1and1.com>
 <3e75543bdc093c158f050b3dfc0afe8e@maila.biz>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


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

Hi Michael,=0A=0AThanks for replying,=0A=0ADo you think it would be that =
big of a size? Over 21G?=0A=0AThanks,=0A=0A4 de Setembro de 2017 08:45, "=
Michael Vitale"  escreveu:=0A	nice benefit of logical dump and restore: b=
ye bye bloat On September 4, 2017 at 7:35 AM "Jean R. Franco"  wrote:=0AH=
ello Everyone,=0A=0AI'm moving a postgresql server from one server to ano=
ther, 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 i=
s, on the old server the database size is 81GB, but when I restore on the=
 new server, it decreases to 60GB=0A=0AList of databases=0AName | Owner |=
 Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Des=
cription=0A------------+----------+----------+---------+-------+---------=
----------+-------+------------+-------------=0Aecidade | postgres | LATI=
N1 | C | C | | 60 GB | pg_default |=0A=0AI'm watching the whole process o=
f restoring it and have no errors.=0AWhat could I been doing wrong?=0A=0A=
Thanks,

----=_RainLoop_548_485622872.1504528563
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;">H=
i Michael,<br><br>Thanks for replying,<br><br>Do you think it would be th=
at big of a size? Over 21G?<br><br>Thanks,<br><br>4 de Setembro de 2017 0=
8:45, "Michael Vitale" &lt;<a target=3D"_blank" tabindex=3D"-1" href=3D"m=
ailto:%22Michael%20Vitale%22%20&lt;michaeldba@sqlexec.com&gt;">michaeldba=
@sqlexec.com</a>&gt; escreveu:<br> <blockquote><div><div> <p>nice benefit=
 of logical dump and restore: bye bye bloat</p> <blockquote type=3D"cite"=
>On September 4, 2017 at 7:35 AM "Jean R. Franco" &lt;<a target=3D"_blank=
" rel=3D"noopener noreferrer" href=3D"mailto:jfranco@maila.biz">jfranco@m=
aila.biz</a>&gt; wrote:<br> <div style=3D"font-family: arial, sans-serif;=
font-size: 13px"> <br>Hello Everyone,<br><br>I'm moving a postgresql serv=
er from one server to another, both running versions 9.4.10<br>It's a sin=
gle large database and I'm using pgdump to export and restoring on the ne=
w server.<br><br>The thing is, on the old server the database size is 81G=
B, but when I restore on the new server, it decreases to 60GB<br><br>List=
 of databases<br>Name | Owner | Encoding | Collate | Ctype | Access privi=
leges | Size | Tablespace | Description<br>------------+----------+------=
----+---------+-------+-------------------+-------+------------+---------=
----<br>ecidade | postgres | LATIN1 | C | C | | 60 GB | pg_default |<br><=
br>I'm watching the whole process of restoring it and have no errors.<br>=
What could I been doing wrong?<br><br>Thanks,<br> </div> </blockquote> </=
div></div></blockquote> <signature></signature><br> </div></body></html>

----=_RainLoop_548_485622872.1504528563--