Re: pg_restore - Real dump file size

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore - Real dump file size
Date: 2016-02-26 05:19:11
Message-ID: CAE_gQfWyUAAg23QPy=AX9D7i9B_fDuJKFCnN-WNG9Qe+j0WVDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Reno, Natalie 2016-02-26 14:29:26 pg_basebackup - Stale file handle for file under gprof
Previous Message drum.lucas@gmail.com 2016-02-26 04:25:48 pg_restore - Real dump file size