Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vkRMd-00FEXO-0K for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 18:31:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vkRMb-00A5ek-2x for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 18:31:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vkRMb-00A5eb-1r for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 18:31:01 +0000 Received: from sonic315-20.consmr.mail.ne1.yahoo.com ([66.163.190.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vkRMY-002R6n-2t for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 18:31:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1769452257; bh=H8R/NIZsCTMKbwMbPjSD8IDFPBWJ+MZKJODtwul3rfc=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=fLKQpcFFa+wEj97tRQ61M22KPxdia8TfNuTCvd0OnTd5uRtFFkLNmepNpzLORUHxWQAOcfuD9onhngZN68k/UGFL2OIxIbj34Csgu1BEic3uQ1pYn7XRI44ZSdkwTU00OMtcRrKw+ONRT/13JHD3tR3OslwJ6HcqKnj0bHrvI0caG+SAzvVTHfqIFkj1SihJ1NadClWtvyHnVVWuMDX2BEWY5ZqCx4UgMbTuX6T9kllVermCrz36tQfSFSVGro8dT+bE6i6tveo9kQWnuctsS7Q4Tqqo+LuzLhzZIjcJLh4bhcu1mhnjzeVs5iz4c+iizEdBvBU4tCRerkKBVPI2Aw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1769452257; bh=UK8YSv9bbuFlqVyy/IY4G0FKyhTw28DP9nzGOaLTwSO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=VOGNxt/EQW79gc0rOTd7TnuZ9n6fNYMp9mlbzMkVdVDET6DDyyA+KT22d7DZRsmKrt1JQI/iBYbkIKryk/h/J9xvaOmzRKxeENZ4MppwXoy/vRX4SPftc/3O7d0cUyx7SfuacrIVnJ8f5jG/DBdxzYRXeBf7seIDYJAqNAGSGmld5qHhBphsjmDVcpb75DQ89VpuOrh4aNc5d3m/KjBBNaY2HsNkjSDg6ejsBEbTCwjynTGV0wzrQyapV6HE8j7g9o+p3RC1AWWsdulXieHUNbRAnhEmvqzOAXI0xsT3lq832hMdc3u5dcDgrEUxmmd82TmebDi/JdjL/TS9qg27nA== X-YMail-OSG: u5l0e.AVM1l8Mzr56JUQRJG_zKbJ1l1geb3lIAobso2pmmHXV5_HRfTrL4Ak6Uj l2sa5YXjQFZaUdD5887Xcs5nTYdH80pS3bXUt4RL_wLkxV4lfbt.RT6cyC.97rSbA6.c3s7AwSTe RSCPkECLw1IKY6OLhX6Y3jHZ9oie.qzP9Yb3SQP8K0gP0BwpZSLH.jz8ygmj1BivoNdt6oVRAMIi n2wCbM4_pHRJ1yY9GzZlyeAOz2nFA6sSUMElAS3nVnkN2C12WuEmd0B1kOuJM5p0jceytz5vQJZT BOauG.Sec8wIvAY.rB0O0JElccto9_hsDv3lfGGnItjhZT1pU7R0ISOSHvXx72C9r0b4z7MofuoW Ki8VAFra_A4_jSPqNxbvsdxiWKmw5AI2aCjjY0zzeBorhr2GnuRMl_QvbiGb7C234bye73VGAqTa kQ9HOD1aVRQJX3njtUB48Rh4wNYAemDYPjLMlneRx2egLpsJhRaGYkZZusbtCszYCV3z2M8QbEpk OBu19CbNM94338iXejGfMSb9AvGHYnLcOnXKgi4utAYVPA70YK3IkBlneZTWPvtdLLd0mB_YmWT2 pBMX5A6A_foJSFVzaywuQVpLmwIXdPEI_fMkLLqJXtHwI7bxhWv1LHFTB8z3YAYy_LRKpYs7ZbJv Gj.gfHOuZiC1KD1JFcaDDgBbJG3fLob0yqkar0sxeWrj4C7IxbrNiVOZOV0fv2kAjGrtbA5XMkHl J7XL5tRwnv3VDrm5ecSkqNZjM1FwTq8LiBklmOt.M0vuyWubQfSUEC6egezCH3lFCp1yYLezgBpj rJTn75iguJwPtG_uQJtEj5jZbPQdZ7oYO6OeR_b.zabgYE9zFBOFjsfnf0NpaUIKE47j78QM5ava 6AEdM91LcvbE80RgremGluVawqIxInwnFaFuh8MtVAgxV5anDG_XK3pE.MUt4G.yoszvRhArTyaa LU7E7_UHkx1PFwRfPHMQKRSkANVoCSmGwycY5F8PJWSh5FhPjzV.1zDrXcELcLja03Pnd.NeVqEZ ztjGLl.dR7aYzo5reD5_P7jki2CGa2esyRXf.kp01BvAe4VTgV8A5Qe8yw9s3VXf5WAf_UNgrqla NzluQ83AdBVFn9Ig4iaU1.eozdvBOrxaKM.13zi6IWuQ8JCSBv2VpuUaWZhDEThT1drc28lnqI21 4JXkuxzeLTMF_2VVFaoO.KlqKo9OY6OansgWM0wT0Q1_ZV.am6IahbjTbHNs2YHNphvmOGCcDoMB riQ5Ac6TrdLrtUbcI9QyTtQpYZ39IeeB8SNbr7guwxelIj6xH4CTjokV0v7FiYHlD0CE1Z5H.D_w YJhn_mvYqn.qqVjHpoJ4IAq7Dnw3vi0J9pmHGNXI3IHc66qOsRdW_c1SFUpl6LyWvEv0536JuKfo oUemaVjoQr0QS3sgtDPp30a89wNo5fF5G0Lgoeyx8enhvf_LO.Vvj.85hETV8eNECQmmZzk0SHbM v3.4RBFIrSAdyrJr0to0UhUiKm9z6wXYQwyBcmdx1SFEyMkzTDnHk3zFCgxn4IcXDFLD28PLYqs3 Yps_I03JQNXsUzeYbqwyu9nQWoYX.3RPlyR4yLzZkFs_2hkb_oWMZC.H5HsphOeOdFrB7sUw74b9 QkDP6Q.ud1Cpz9.qKC.61ozFE3CNJ5nXBjcUtMOCwgHibtY5TrJOhOLOLe4akgckzW7TCkmdCOq4 Q9SGLBarhBOZXSurV7Mb4pYBCYrKJB37W5QC.4AqFwZp.dFGoQDgJmAQytZxTf_gqLLJztxVaCkv kHas1uZDFahzc17pBvhbPfZITUmCFQccvWoGk70xGwnnbxuuk3ukHt9ufqrGpFhnYB6Oox20pfVW QSQaxO1gVLh7NX0AeLQ68qyGsGhTVMzgjHodc.ZCsoQEItiS1A6krZorzvcYuJJyLYhWPKgSwGl9 hTDMCGEyx3ynUqBYEyK8Fu0vTU59O6T77hevHfHZb2f5vq4trTB5p_cp_yDW7gnW9DD3avIRks7U 2g9WGM8gF03.bkggcBcV5ZHVdJS9SG3gWdHlhN4rzyfNkJZdxyFbxKS94BYrfr4vf0y1TtEtPUnI JRIOA1aE3iLdflUpTuo9KsD7r_owu8qBoSYuDrB2jDPwjkcI2ASgGhdfRVhcVLkD5lMqJz4THjhc r48pNhMuytfo3yFCtmOPJBA63xkjpXLlf_s7TaG2nl5evwIeW0JcSePeu5F1QwDFsLu_rl75fIGk hO.rJtdy0isaQX.X0JVA- X-Sonic-MF: X-Sonic-ID: 7e78c5cc-54f9-4ad2-9166-718191eee4e8 Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Mon, 26 Jan 2026 18:30:57 +0000 Date: Mon, 26 Jan 2026 18:30:54 +0000 (UTC) From: felix.quintgz@yahoo.com To: pgsql-general@lists.postgresql.org Message-ID: <1859033163.4321267.1769452254461@mail.yahoo.com> In-Reply-To: <06150340-D824-4F4D-A68A-EA205908431F@thebuild.com> References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com> <1730736265.4259921.1769443263077@mail.yahoo.com> <868938296.4311067.1769449951678@mail.yahoo.com> <06150340-D824-4F4D-A68A-EA205908431F@thebuild.com> Subject: Re: About backups MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Mailer: WebService/1.1.24987 YMailNodin Content-Length: 1344 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Can I copy pg_dump directly into the container? Or is there an installer just for the PostgreSQL utilities? On Monday, January 26, 2026 at 01:04:17 PM GMT-5, Christophe Pettus wrote: > On Jan 26, 2026, at 09:52, felix.quintgz@yahoo.com wrote: > > I'm having a problem with this. I'm repurposing an old application writte= n in Visual Basic 6 that did allow backups through signed stored procedures= . > 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 databas= e 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.=C2=A0 You could, in theory, use the COPY command to dump e= ach individual table, but that's probably not what you are looking for (sin= ce it would also require a fairly sophisticated restore process). pg_dump can run in the application container, and connect to the database i= n the database container, just like the application does.=C2=A0 There's no = requirement that pg_dump run on the database host.=C2=A0 That's probably th= e best direction in this case.