From: Rui DeSousa <rui@crazybean.net>
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: Frank Lanitz <frank@frank.uvena.de>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump why no indicator of completion
Date: Mon, 1 May 2023 10:31:18 -0400
Message-ID: <8D0A91FC-C10C-4B68-9348-DA3F751FE470@crazybean.net> (raw)
In-Reply-To: <CAGA3vBsyWKwJNPiYCu3juFfTqprb6FUK5gSH8zt29rqUzhtcLw@mail.gmail.com>
References: <CAGA3vBugp4Ce8ZbOfntb8HjCvo5QtX1hhAHj3iuCMZdzSTo4dg@mail.gmail.com>
<61e421bc-d47f-05ef-edb2-bd9cbce1be40@frank.uvena.de>
<CAGA3vBsyWKwJNPiYCu3juFfTqprb6FUK5gSH8zt29rqUzhtcLw@mail.gmail.com>
> On May 1, 2023, at 10:00 AM, richard coleman <rcoleman.ascentgl@gmail.com> wrote:
>
> As I've mentioned in another response I typically run pg_dump as follows:
>
> nohup pg_dump {various settings} > something.log 2>&1 &
Why redirect standard error to standard out when using pg_dump? I assume that using standard out is not the backup stream.
If you want a success message in the log; write the success message to the log file if pg_dump exits successfully.
i.e.: nohup pg_dump --verbose prod > prod.sql 2> prod.log && echo "Backup Completed Successfully!" >> prod.log &
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rui@crazybean.net, rcoleman.ascentgl@gmail.com, frank@frank.uvena.de, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump why no indicator of completion
In-Reply-To: <8D0A91FC-C10C-4B68-9348-DA3F751FE470@crazybean.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox