From: M Sarwar <sarwarmd02@outlook.com>
To: richard coleman <rcoleman.ascentgl@gmail.com>
To: Rui DeSousa <rui@crazybean.net>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump why no indicator of completion
Date: Mon, 1 May 2023 15:51:54 +0000
Message-ID: <DM4PR19MB59784BD44516CD488CDACE89D36E9@DM4PR19MB5978.namprd19.prod.outlook.com> (raw)
In-Reply-To: <CAGA3vBvXS8e-k3gf4FUnGewAqO=huvM+mFYd=a7C39hXUgUGzA@mail.gmail.com>
References: <CAGA3vBugp4Ce8ZbOfntb8HjCvo5QtX1hhAHj3iuCMZdzSTo4dg@mail.gmail.com>
<f68e9f75-4036-30c7-6d10-72dce6521bb3@gmail.com>
<CAGA3vBsq49mS47iH9CpCjipxu-BP_85x9doEHrvP5jyaPuNN4Q@mail.gmail.com>
<ac61c17e-1816-716e-9cb9-6d41682bc7c1@gmail.com>
<CAGA3vBsUcbcofa6F6nDBvqFHRtrBUFxu4270dnWwT3RjDP7QRQ@mail.gmail.com>
<A65804DE-890B-4709-AAC4-516748687D72@crazybean.net>
<CAGA3vBvSQ7RxxQ3ELRR7qF=FobhkyhXU7Ncbw5xi+4VZi==dRQ@mail.gmail.com>
<6FEB60CF-D7E0-41F6-B125-8D53C81CEE2B@crazybean.net>
<CAGA3vBvXS8e-k3gf4FUnGewAqO=huvM+mFYd=a7C39hXUgUGzA@mail.gmail.com>
If somebody is seriously looking into these suggestions, I like to bring another point for the development of pgdump log.
In pgdump while displaying backedup table names, the same row in the log can include the number of rows backedup for each table.
Thank you,
Sarwar
Working on the project where I do not know the application 🙂
________________________________
From: richard coleman <rcoleman.ascentgl@gmail.com>
Sent: Monday, May 1, 2023 11:34 AM
To: Rui DeSousa <rui@crazybean.net>
Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump why no indicator of completion
Rui,
Thanks for those suggestions, and your earlier ones.
It would be helpful though if the dev included a completion status message in pg_dump, even if it was only included when you specified the -v flag.
rik.
On Mon, May 1, 2023 at 11:29 AM Rui DeSousa <rui@crazybean.net<mailto:rui@crazybean.net>> wrote:
On May 1, 2023, at 10:34 AM, richard coleman <rcoleman.ascentgl@gmail.com<mailto:rcoleman.ascentgl@gmail.com>> wrote:
As I've asked Ron, if pg_dump isn't fit for purpose, then what do you believe is?
If you need a logical backup then pg_dump is the right tool; as noted before but with better options to improve performance.
For backups; I would recommend physical backups which there are many solutions for. I have personally used snapshots and believe that is the best solution. It is the fastest and best solution to meet recovery time objective (RTO). For example, I’m able to make a backup of a multi-terabyte database in under a second and multiple backups are cheap. This allows me to do a backup of the system every 6 hours. The most expensive part of a database restore is going to be applying the WAL files when doing a point in time recovery (PITR). This means that at most, I would only have to apply around 6 hours of WAL files; which can still take a long time given a high volume system.
In my opinion snapshots are the best solution but it will depend on your infrastructure and requires knowledge of the infrastructure and setting it up correctly.
If I could not use snapshots; I would look into either pgBackRest or pgBarman.
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: sarwarmd02@outlook.com, rcoleman.ascentgl@gmail.com, rui@crazybean.net, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump why no indicator of completion
In-Reply-To: <DM4PR19MB59784BD44516CD488CDACE89D36E9@DM4PR19MB5978.namprd19.prod.outlook.com>
* 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