Thread: [GENERAL] pg_restore load data
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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.
The command is COPY, not load.
Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone
-------- Original message --------
From: Ron Johnson <ron.l.johnson@cox.net>
Date: 11/16/17 16:07 (GMT-05:00)
To: pgsql-general@postgresql.org
Subject: [GENERAL] pg_restore load data
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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> 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