[ADMIN] pgdump and restore results in different sizes DB

Поиск
Список
Период
Сортировка
От Jean R. Franco
Тема [ADMIN] pgdump and restore results in different sizes DB
Дата
Msg-id 3e75543bdc093c158f050b3dfc0afe8e@maila.biz
обсуждение исходный текст
Ответы Re: [ADMIN] pgdump and restore results in different sizes DB
Список pgsql-admin

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,

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sivakrishna Tungala
Дата:
Сообщение: [ADMIN] wal file generation
Следующее
От: Michael Vitale
Дата:
Сообщение: Re: [ADMIN] pgdump and restore results in different sizes DB