<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>nice benefit of logical dump and restore: bye bye bloat</p><blockquote type="cite">On September 4, 2017 at 7:35 AM "Jean R. Franco" <jfranco(at)maila(dot)biz> wrote:<br><br><div style="font-family: arial, sans-serif; font-size: 13px;"><br>Hello Everyone,<br><br>I'm moving a postgresql server from one server to another, both running versions 9.4.10<br>It's a single large database and I'm using pgdump to export 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 decreases 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'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>