Do select counts from all your tables in old and new and see if they match.
Sent from my iPad 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" < michaeldba@xxxxxxxxxxx> escreveu: nice benefit of logical dump and restore: bye bye bloat On September 4, 2017 at 7:35 AM "Jean R. Franco" <jfranco@xxxxxxxxx> 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,
|
