Date: Mon, 26 Jan 2026 20:16:12 +0000 (UTC)
From: felix.quintgz@yahoo.com
To: pgsql-general@lists.postgresql.org
Message-ID: <532797406.4381326.1769458572799@mail.yahoo.com>
In-Reply-To: <992bfa7f-3a6a-4832-b196-675ec13af754@aklaver.com>
References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com> <1730736265.4259921.1769443263077@mail.yahoo.com> <f88a803f-2954-44c5-bd29-e7f1dc5f9d02@aklaver.com> <CANzqJaAygQG3F3fKe25YV765kUkO=UQqefACpo+2KQJXew7g-Q@mail.gmail.com> <868938296.4311067.1769449951678@mail.yahoo.com> <CANzqJaBnBBAWO7ot2V+oSNpR7VSnkAELMX0aqZcP=rHs2ddoig@mail.gmail.com> <2022327491.4341234.1769452625380@mail.yahoo.com> <32C440DF-84C3-48D3-AF25-C0D977359F56@thebuild.com> <1244937982.4358855.1769455485523@mail.yahoo.com> <992bfa7f-3a6a-4832-b196-675ec13af754@aklaver.com>
Subject: Re: About backups
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Length: 1600
Archived-At: <https://www.postgresql.org/message-id/532797406.4381326.1769458572799%40mail.yahoo.com>
Precedence: bulk

Thank you all so much.=20
With what they've given me, I can continue in my job.

 On Monday, January 26, 2026 at 03:02:45 PM GMT-5, Adrian Klaver <adrian.kl=
aver@aklaver.com> wrote:
 On 1/26/26 11:24, felix.quintgz@yahoo.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 its=
elf, solely through the application, and the user must have the necessary p=
ermissions 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 ba=
ckup.
>
>=C2=A0 On Monday, January 26, 2026 at 01:42:55 PM GMT-5, Christophe Pettus=
 <xof@thebuild.com> wrote:
>> On Jan 26, 2026, at 10:37, felix.quintgz@yahoo.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 abou=
t it.
>
> Can you articulate the specific requirement?=C2=A0 I assume it's not "the=
 database can be backed up completely by issuing an SQL command."=C2=A0 If =
we know what the precise requirement is, we might be able to provide more s=
pecific guidance.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com