Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dovuU-0007rE-EH for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 18:15:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dovuT-0000af-NO for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 18:15:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dovuS-0000aV-TG for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 18:15:45 +0000 Received: from my.maila.biz ([138.118.35.245]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dovuL-0001wE-A5 for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 18:15:44 +0000 Received: (Haraka outbound); Mon, 04 Sep 2017 18:15: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 73F1D563-6A33-40B6-8AFF-62F785423813.1 envelope-from (authenticated bits=0); Mon, 04 Sep 2017 18:15:30 +0000 Mime-Version: 1.0 Date: Mon, 04 Sep 2017 18:15:30 +0000 Content-Type: multipart/alternative; boundary="--=_RainLoop_735_477050926.1504548930" X-Mailer: RainLoop/1.11.1 From: "Jean R. Franco" Message-ID: <92e4f5bf6ac966939a3ec887a7917d07@maila.biz> Subject: Re: pgdump and restore results in different sizes DB To: pgsql-admin@postgresql.org In-Reply-To: <55858EF9-AACE-4478-809F-BB84D96FFD02@sqlexec.com> References: <55858EF9-AACE-4478-809F-BB84D96FFD02@sqlexec.com> <1758120710.400302.1504525501413@email.1and1.com> <3e75543bdc093c158f050b3dfc0afe8e@maila.biz> <9f30edef02a5c0f25f4c72fb191f9512@maila.biz> 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=b82iGPmcbm3tiJ6VWnHm0BvtleToKABfPRuWjl9AlzY=;c=relaxed/simple;d=maila.biz;h=from:subject:date:message-id:to:mime-version;s=cloudron;b=CskvzeaQH+i5XbVcVuIPZlFVbsIhJgp7drMG1mBBQg0LdmRlei7zzbg/RNGC6eRKTlEN6Do3SdJd16Pyn960qRBlq3MIQqVG2prG3PKi7RjGRbBAdt12E3xPw86lRgb5HQk1TZ8/vGLKHnCa47BbGvM1Cl+RRiw4CTiCJpaJOnQ= List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ----=_RainLoop_735_477050926.1504548930 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Thanks for replying,=0A=0AThat takes me to another question:=0A- Is there= a way to do a count on all the tables at once?=0AI can check one by one = but that will take me a long time (1596).=0A=0AI checked the table sizes = and they differ very much!=0A=0AThanks,=0A=0A4 de Setembro de 2017 09:54,= Michaeldba@sqlexec.com (mailto:Michaeldba@sqlexec.com) escreveu:=0ADo se= lect counts from all your tables in old and new and see if they match.=0A= =0ASent from my iPad =0AOn Sep 4, 2017, at 8:36 AM, Jean R. Franco wrote= :=0AHi Michael,=0A=0AThanks for replying,=0A=0ADo you think it would be t= hat big of a size? Over 21G?=0A=0AThanks,=0A=0A4 de Setembro de 2017 08:4= 5, "Michael Vitale" escreveu:=0A nice benefit of logical dump and restor= e: bye bye bloat On September 4, 2017 at 7:35 AM "Jean R. Franco" wrote:= =0AHello Everyone,=0A=0AI'm moving a postgresql server from one server t= o another, both running versions 9.4.10=0AIt's a single large database an= d I'm using pgdump to export and restoring on the new server.=0A=0AThe th= ing is, on the old server the database size is 81GB, but when I restore o= n the new server, it decreases to 60GB=0A=0AList of databases=0AName | Ow= ner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace = | Description=0A------------+----------+----------+---------+-------+----= ---------------+-------+------------+-------------=0Aecidade | postgres |= LATIN1 | C | C | | 60 GB | pg_default |=0A=0AI'm watching the whole proc= ess of restoring it and have no errors.=0AWhat could I been doing wrong?= =0A=0AThanks, ----=_RainLoop_735_477050926.1504548930 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
T= hanks for replying,

That takes me to another question:
- Is the= re a way to do a count on all the tables at once?
I can check one by o= ne but that will take me a long time (1596).

I checked the table s= izes and they differ very much!

Thanks,

4 de Setembro de 20= 17 09:54, Michaeldba@sqlexec.com escreveu:
Do select counts from all your tables in old and ne= w and see if they match.

Sent from my iPad

On Sep = 4, 2017, at 8:36 AM, Jean R. Franco <jfranco@maila.biz> wrote:
Hi Michael,

Thanks for replying,

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

Thanks,

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

nice benefit of logical dump and resto= re: bye bye bloat

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

Hello Everyone,

I'm moving a postgresql s= erver 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

L= ist of databases
Name | Owner | Encoding | Collate | Ctype | Access pr= ivileges | 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.<= br>What could I been doing wrong?

Thanks,
<= /div>

----=_RainLoop_735_477050926.1504548930--