pg_dump why no indicator of completion

From: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg_dump why no indicator of completion
Date: 2023-05-01 00:18:06
Message-ID: CAGA3vBugp4Ce8ZbOfntb8HjCvo5QtX1hhAHj3iuCMZdzSTo4dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I've been working with pg_dump and one thing that's always struck me as
strange is that there never seems to be an indication in the log that the
pg_dump process completed successfully.

For example, I've been running a bunch of backups with pg_dump in directory
mode with multiple jobs. When I come back several hours later there are no
pg_dump processes running. The log is filled with:

dumping contents of foo
finished item 123456 of TABLE DATA bar
etc.

Other than trying to restore the multi terabyte database somewhere else is
there any way to know that it actually finished successfully?

Why doesn't pg_dump add a line in the output like:

pg_backup finished

when it's completed successfully?

This seems like a terrible oversight.

Am I missing something obvious?

Thanks,
rik.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gavan Schneider 2023-05-01 01:08:03 Re: pg_dump why no indicator of completion
Previous Message Bruce Momjian 2023-04-28 20:11:06 Re: Can't use accounts with .local emails