Postgres Pro
Downloads
Home   >   mailing lists

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

From drum.lucas@gmail.com
Subject Re: pg_restore - Real dump file size
Date
Msg-id CAE_gQfWyUAAg23QPy=AX9D7i9B_fDuJKFCnN-WNG9Qe+j0WVDQ@mail.gmail.com
Whole thread Raw
In response to pg_restore - Real dump file size  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: pg_restore - Real dump file size  (Scott Mead <scottm@openscg.com>)
List pgsql-admin
Tree view
sorry I was going to send it to the general list.. but I've sent to admin by mistake


I've sent to general list now


On 26 February 2016 at 17:25, 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-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: pg_restore - Real dump file size
Next
From: "Reno, Natalie"
Date:
Subject: pg_basebackup - Stale file handle for file under gprof