Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M47016=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1dopol-0006pa-4y
	for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 11:45:27 +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+M47016=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1dopok-0000uY-EX
	for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 11:45:26 +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 <michaeldba@sqlexec.com>)
	id 1dopoj-0000uO-T8
	for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 11:45:26 +0000
Received: from mout.perfora.net ([74.208.4.196])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <michaeldba@sqlexec.com>)
	id 1dopoX-00081b-Q3
	for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 11:45:24 +0000
Received: from oxuslxaltgw03.schlund.de ([10.72.76.59]) by mrelay.perfora.net
 (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LooEX-1dIE5j3YwV-00goPn;
 Mon, 04 Sep 2017 13:45:04 +0200
Date: Mon, 4 Sep 2017 07:45:01 -0400 (EDT)
From: Michael Vitale <michaeldba@sqlexec.com>
Reply-To: Michael Vitale <michaeldba@sqlexec.com>
To: "Jean R. Franco" <jfranco@maila.biz>, pgsql-admin@postgresql.org
Message-ID: <1758120710.400302.1504525501413@email.1and1.com>
In-Reply-To: <3e75543bdc093c158f050b3dfc0afe8e@maila.biz>
References: <3e75543bdc093c158f050b3dfc0afe8e@maila.biz>
Subject: Re: pgdump and restore results in different sizes DB
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Priority: 3
Importance: Medium
X-Mailer: Open-Xchange Mailer v7.8.3-Rev30
X-Originating-Client: open-xchange-appsuite
X-Provags-ID: V03:K0:Gt0GCaH9qnY5U/gVOrHVT7Ltl+1BlDGS9YFocxQ/Zfj/qKsqga+
 g9JcYYPdlUsOTR7Gt6ovWo2jL3g4yDaOw3Bq25vkelzS/spxYQZ/b1jVrf3m+xtBa6+RjCF
 fkmBkTVrIjdAZP71c5q5IjG0WYrdnK/rbgf20LzBO8uH++wFIHtzQwo6fR4FHJaqq/Rhqzc
 R06JTFUF3BX8y+Uer3VdQ==
X-UI-Out-Filterresults: notjunk:1;V01:K0:GTudGFQQwdI=:hbrBE3Kx2ZjjwLxs+VWUyR
 NQF+I5iluMY9+8scuUnEjmh6yDE4WAcXYqM5rGv/5Z7bfRZQNfJaQgtKeMRcq1O3OUdNY6+wy
 QqlNJ+5/1sM1EzCfV+4UdDPJp/Qv5xNHKcV/a0MtxvE3A3pzp81dEbiL/QEUWxGZNpG1chuwy
 3POZUKnYSHpc7S5GX/+k3eH+u9h5RcD9uiJze9OJycA6tZQ0U/z+CQkd8L+nYCtodBE1SE37P
 jwHudbs/ocdzoMwl8w71q+3GJMBp0NsAL3J/rxW0SScQ66YGjJil1rHGYcJesi7/ewY0dbB6U
 bVQgeINRkizn2lRV1CjhLwulxXwq83QFuEva7b+IlrwWixFoV4lngmzABpNcXtntZWLTdybYE
 YlKqqY6HsdQLnutF8uqQe30ZcDreZ5nHbZvRsEMLQKbKg7MvMD21XWJPtjT/cuFVtaPiCX1rk
 0EC6RKTWhUcs04uaLR64S7TEsZJ9dQefkNgQXfgYkXTS7lqQ68Ax0rVUb9Jn+iq+MyPJZcyLj
 BrAzDT+yWsP9dI7s58SS1h8RwqMFbslGSfZgychBpZoKEmQyIPQc7OZEGW+T4zl3NriK3fhvt
 DbW50T2CjvAisHY+ow83w7ALhTt/RGpjMdJu4GSuiu7XaOxlCaiPE3XWUqCrqrU/jpN+UmnuW
 7H1Ev9zPsrAPhm1Cx0jeCTnqNPTeCjBR72glw4O5uR4jO2NF2Gh2ctRvPJ26vSUya9salFIXA
 n+WBeMMmUDw8xhUm3mcFO/X08D2+9H3eyD0QaSG9SgecP8UfQKhHsBL5G5M=
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

<!DOCTYPE html>
<html><head>
    <meta charset=3D"UTF-8">
</head><body><p>nice benefit of logical dump and restore: bye bye bloat</p>=
<blockquote type=3D"cite">On September 4, 2017 at 7:35 AM &#34;Jean R. Fran=
co&#34; &#60;jfranco@maila.biz&#62; wrote:<br><br><div style=3D"font-family=
: arial, sans-serif; font-size: 13px;"><br>Hello Everyone,<br><br>I&#39;m m=
oving a postgresql server from one server to another, both running versions=
 9.4.10<br>It&#39;s a single large database and I&#39;m using pgdump to exp=
ort and restoring on the new server.<br><br>The thing is, on the old server=
 the database size is 81GB, but when I restore on the new server, it decrea=
ses to 60GB<br><br> List of databases<br> Name | Owner | Encoding | Collate=
 | Ctype | Access privileges | Size | Tablespace | Description<br>---------=
---+----------+----------+---------+-------+-------------------+-------+---=
---------+-------------<br> ecidade | postgres | LATIN1 | C | C | | 60 GB |=
 pg_default |<br><br>I&#39;m watching the whole process of restoring it and=
 have no errors.<br>What could I been doing wrong?<br><br>Thanks,<br><br></=
div></blockquote></body></html>
=20