Home > mailing lists

pg_restore - Real dump file size - Mailing list pgsql-admin

From	drum.lucas@gmail.com
Subject	pg_restore - Real dump file size
Date	February 26, 2016 07:26:32
Msg-id	CAE_gQfXBUYTuTzqTAhJS08JcuKgmr0xoqeVq8QSg8Z2whnecTQ@mail.gmail.com Whole thread Raw
Responses	Re: pg_restore - Real dump file size
List	pgsql-admin

Hi all,

I'm doing the pg_restore now in a 1.5TB file:

# ls -la

postgres postgres 1575324616939 Feb 20 13:55 devdb_0.sql

But, the restore has gone over 1.6 TB

# \l+

1639 GB

How is that even possible?

pg_restore command:

/usr/pgsql-9.2/bin/pg_restore -d dbname --exit-on-error --jobs=4 --verbose devdb_0.sql

Cheers

From: "Fred Parkinson"
Date: 24 February 2016, 21:24:10
Subject: Re: db commands elicit no response

From: "drum.lucas@gmail.com"
Date: 26 February 2016, 08:19:54
Subject: Re: pg_restore - Real dump file size