Re: [GENERAL] pg_restore load data

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.

$ 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