From: | "Jean R(dot) Franco" <jfranco(at)maila(dot)biz> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pgdump and restore results in different sizes DB |
Date: | 2017-09-04 18:15:30 |
Message-ID: | 92e4f5bf6ac966939a3ec887a7917d07@maila.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for replying,
That takes me to another question:
- Is there a way to do a count on all the tables at once?
I can check one by one but that will take me a long time (1596).
I checked the table sizes and they differ very much!
Thanks,
4 de Setembro de 2017 09:54, Michaeldba(at)sqlexec(dot)com (mailto:Michaeldba(at)sqlexec(dot)com) escreveu:
Do select counts from all your tables in old and new and see if they match.
Sent from my iPad
On 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,
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,
From | Date | Subject | |
---|---|---|---|
Next Message | Jean R. Franco | 2017-09-04 18:16:37 | Re: pgdump and restore results in different sizes DB |
Previous Message | Artem Tomyuk | 2017-09-04 17:23:30 | Fastest Backup Method? |