Re: About backups

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: felix(dot)quintgz(at)yahoo(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: About backups
Date: 2026-01-26 20:02:23
Message-ID: 992bfa7f-3a6a-4832-b196-675ec13af754@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/26/26 11:24, felix(dot)quintgz(at)yahoo(dot)com wrote:
> A full database backup is the requirement. A database restore is optional, but that's negotiable; the backup is not.
> All of this must be done without access to the server or the database itself, solely through the application, and the user must have the necessary permissions within the application.
> > The postgresql-client option is probably the right one.

FYI, in Postgres 17+ you have in the client program pg_basebackup the
option to do incremental backups.

In addition there are third party tools that offer more options for backups:

https://pgbarman.org/

https://pgbackrest.org/

> I still have the restore history part to do, but the main thing is the backup.
>
> On Monday, January 26, 2026 at 01:42:55 PM GMT-5, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
>> On Jan 26, 2026, at 10:37, felix(dot)quintgz(at)yahoo(dot)com wrote:
>>
>> I can't change my expectations. It's either you do it or I won't certify you, and you won't be able to use the application.
>> That's how a certification body works, and there's nothing I can do about it.
>
> Can you articulate the specific requirement?  I assume it's not "the database can be backed up completely by issuing an SQL command."  If we know what the precise requirement is, we might be able to provide more specific guidance.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2026-01-26 20:11:22 Re: About backups
Previous Message felix.quintgz 2026-01-26 19:46:44 Re: About backups