Re: pg_dump why no indicator of completion

Поиск
Список
Период
Сортировка
Искать
От
Holger Jakobs
Тема
Re: pg_dump why no indicator of completion
Дата
в 07:43:35
Msg-id
D2233CA3-EC91-4154-AD06-730E3E574DE5@jakobs.com
Ответ на
Список
Дерево обсуждения
pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Frank Lanitz <frank@frank.uvena.de>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Rui DeSousa <rui@crazybean.net>
Re: pg_dump why no indicator of completion "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_dump why no indicator of completion Scott Ribe <scott_ribe@elevated-dev.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion Tim <timfosho@gmail.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Erik Wienhold <ewie@ewie.name>
Re: pg_dump why no indicator of completion Tim <timfosho@gmail.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion Holger Jakobs <holger@jakobs.com>
Re: pg_dump why no indicator of completion Gavan Schneider <list.pg.gavan@pendari.org>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion Frank Lanitz <frank@frank.uvena.de>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion Rui DeSousa <rui@crazybean.net>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Scott Ribe <scott_ribe@elevated-dev.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Rui DeSousa <rui@crazybean.net>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion M Sarwar <sarwarmd02@outlook.com>
Re: pg_dump why no indicator of completion Scott Ribe <scott_ribe@elevated-dev.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Scott Ribe <scott_ribe@elevated-dev.com>
Re: pg_dump why no indicator of completion Ron <ronljohnsonjr@gmail.com>
Re: pg_dump why no indicator of completion richard coleman <rcoleman.ascentgl@gmail.com>
Re: pg_dump why no indicator of completion Ian Lawrence Barwick <barwick@gmail.com>
At least it you use plaintext dump, you can check with tail dumpFile for the message


Am 1. Mai 2023 02:18:06 MESZ schrieb richard coleman <rcoleman.ascentgl@gmail.com>:
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.

В списке pgsql-admin по дате отправления
От: Laurenz Albe
Дата:
От: Frank Lanitz
Дата:
FAQ