Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.8\))
Subject: Re: About backups
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <868938296.4311067.1769449951678@mail.yahoo.com>
Date: Mon, 26 Jan 2026 10:04:15 -0800
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <06150340-D824-4F4D-A68A-EA205908431F@thebuild.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>
To: felix.quintgz@yahoo.com
Archived-At: <https://www.postgresql.org/message-id/06150340-D824-4F4D-A68A-EA205908431F%40thebuild.com>
Precedence: bulk


> On Jan 26, 2026, at 09:52, felix.quintgz@yahoo.com wrote:
>=20
> I'm having a problem with this. I'm repurposing an old application =
written in Visual Basic 6 that did allow backups through signed stored =
procedures.=20
> This is a requirement for financial applications; the user can perform =
a backup whenever they want, but they can't access the database.
> The new application is web-based, deployed in containers, and the =
database server container is not the same as the application's, so I =
can't use pg_dump in the application, or at least I don't know how to do =
it.

There is currently no supported way of backing up a PostgreSQL database =
via an SQL command.  You could, in theory, use the COPY command to dump =
each individual table, but that's probably not what you are looking for =
(since it would also require a fairly sophisticated restore process).

pg_dump can run in the application container, and connect to the =
database in the database container, just like the application does.  =
There's no requirement that pg_dump run on the database host.  That's =
probably the best direction in this case.=