Postgres Pro
Downloads
Home   >   mailing lists

pg_restore real file size - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject pg_restore real file size
Date
Msg-id CAE_gQfU6TOAjzc4H7f2GgtVo4n=uQh7c8yWB6HU0W0Vbo7V6XQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_restore real file size  (John R Pierce <pierce@hogranch.com>)
Re: pg_restore real file size  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Privileges granted on dblink extension function do not survive database dump and restore
Next
From: John R Pierce
Date:
Subject: Re: pg_restore real file size