Horton

Thread

  1. pg_restore load data

    Ron Johnson <ron.l.johnson@cox.net> — 2017-11-16T21:07:28Z

    Hi,

v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.)

During a "whole database" restore using pg_restore of a custom dump, when is 
the data actually loaded?  I've looked in the list output and don't see any 
"load" statements.

Thanks

-- 
World Peace Through Nuclear Pacification

  2. Re: pg_restore load data

    bricklen <bricklen@gmail.com> — 2017-11-16T21:13:15Z

    On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson <ron.l.johnson@cox.net> wrote:

> v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.)
>
> During a "whole database" restore using pg_restore of a custom dump, when
> is the data actually loaded?  I've looked in the list output and don't see
> any "load" statements.
>

Look for COPY lines, that's how the data is restored.

  3. Re: pg_restore load data

    Ron Johnson <ron.l.johnson@cox.net> — 2017-11-16T21:33:03Z

    On 11/16/2017 03:13 PM, bricklen wrote:
>
> On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson <ron.l.johnson@cox.net 
> <mailto:ron.l.johnson@cox.net>> wrote:
>
>     v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.)
>
>     During a "whole database" restore using pg_restore of a custom dump,
>     when is the data actually loaded?  I've looked in the list output and
>     don't see any "load" statements.
>
>
> Look for COPY lines, that's how the data is restored.

$ pg_restore -l CDSHA01.dump > CDSHA01.txt
$ grep --color -i copy CDSHA01.txt
$ echo $?
1

There are lots of "restoring data", though.  I should have thought to grep 
for that.

One thing that puzzles me is how fast the tables (even large ones) loaded 
compared to how slow the pg_dump -Fc was.  Granted, I'm running -j4 but 
still, these were some really large, poorly compressible tables (the dump 
file was about as big as du -mc data/base).

-- 
World Peace Through Nuclear Pacification