pg_restore real file size

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore real file size
Date: 2016-02-26 04:26:02
Message-ID: CAE_gQfU6TOAjzc4H7f2GgtVo4n=uQh7c8yWB6HU0W0Vbo7V6XQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-02-26 04:30:29 Re: pg_restore real file size
Previous Message Joe Conway 2016-02-26 00:13:12 Re: Privileges granted on dblink extension function do not survive database dump and restore