Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore real file size - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: pg_restore real file size
Date
Msg-id CAE_gQfUqxgTEnU4YKZJ=NaHVp4F0gYn1UP6ubuJDLKxnfCeOfg@mail.gmail.com
Whole thread Raw
In response to pg_restore real file size  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-general
Tree view
This has been solved...

The difference between the files must be the indexes...

All good now. 
Thank you

On 26 February 2016 at 17:26, drum.lucas@gmail.com <drum.lucas@gmail.com> wrote:
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: "drum.lucas@gmail.com"
Date:
Subject: Export binary data - PostgreSQL 9.2
Next
From: Karsten Hilbert
Date:
Subject: Re: Designing tables based on user input and defined values