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 1vkQdo-00F0TJ-1f for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 17:44:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vkQdn-009kLi-18 for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 17:44:43 +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 1vkQdm-009kLX-2B for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 17:44:43 +0000 Received: from sonic310-24.consmr.mail.ne1.yahoo.com ([66.163.186.205]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vkQdk-002QmJ-0Z for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 17:44:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1769449478; bh=Mu5W6hyl8lvbtl/vcsy/B8l+bywnSurB6/Bj+uPt7Ck=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=V8/z6KyqX2KPT79sMHeR2pvjKtxVIw2QWL/PkLVkjwT7id10MkX8eGhkhqCUbPI78mX20n/XffRQSgJATM7nmVUZ+UIexwQpvO0bDWmOLIfQ8NZQvNRYbk6fmHHiV6vafxnnbx5Vo+qFZCDHxt+ePGezbieBj3QG6fz/a6VU085hBVVias81UkRErq23Bgs3c6duN6knE6fnw17IVjFOnbs72BhLbkfUDGwouPXuYhNcbJspeEHeN/sS3mnjbuBsAS9gGvuGX3JOuuwo2M8hhS+nJJzjlyBkYJN4bLJETD7VfcZBuELP3ygZ0BZMXtHDDpQywWiQlt6mTTVRrn1HfA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1769449478; bh=riKkb6DkWB3fpIFL/mLbC8AXqxUuuf5IufvCwBHcCDy=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=jFzSdtbuwUPhVapffldAIvRmAhp8XdCc9FTASYabNtFCWqE2ZRhjbeI2Q7TzJAc4m9VxUO6vd9m8Eo4I7UMvnbf3QegnvS6uT+ev+KxgZyjmRVEU/Sl/Whp5e1I+6SDM7qpkoGevl4l6E5VYBBrnoqtpkk97JqJEJeTPl7ihWtpEe8+sKOmH6vfs0nEP/7f8tj1uxkDU3TlTlYixqQ4upcIbB5RxFiHTJgFDjJjrYCmkxh0G8wqIAeJimzaxLma+YabVpwhYjefbWpxIdrEfnlFxlynPyY3sOB88VYBksZkUMRbO++IgU+6pXqnYiCzGWcG+W+SQmY/EUAHdpnq1PQ== X-YMail-OSG: UHmKQDAVM1mrNjXb9v0h0jJ5477kOMPRsGkI0C5oPKNWHUeG.QyVY7vPZ3Dk3UH F5aXPypY5CD79zE.qyLj.D1Gf1nbU6lGhmflYlqcz6UP27mf3odUI0SUrMs7sjoA4poOWQVnla6u BSim97i6V5fI91Wv_vtvDHZLtUpXe_stoBmIsT.XYSRFzMEyOjHa6IHySTVdhcKnK9SLH_qEHb_C eFAs5o0T4SXUnV0U2KXfbn4tCqHwUCK4Fn6BfpgYjatREPLu.1l.75esz94al8wXLAR0X0Ww_XcO cV3pbJ7jKCsp_w4fbdVN3q8W6EbI8cScK3gdSRw0IcHV78eVZ7vqgfxXgjcoQkMuRV0Xu9Oq6SXy rpuwyXYmsuONbYh9yyJy2poquPfVdKZ.EeMzRAQJrwJyAIXhdYffkEmhAUhh_ITw19HuUn2eijfG P68d3Bt0hfkFZWU1lhtbxakubgL3YrUBT9Xy6F_iTHjSGeYHYPSy3fyqqLOXeUeun6IFU7wYGF3W xi.DGvPKnEvXisBBqFkzZAOW0o7C4sa9nIQQw1Cqu1ngV8iiZFAz8xcqKCYZRTKIEu0tVgKyn.6A Jm3xHmsEJ5oQdhRZFJELCBOdX60buUkdide9n_UM8Li.g4A5n_XRGVcdHkQUBuawFTiVlJbYtwum M4fIeTFGxohV7mrN_bn3dgwv3yZ7TjOhqplnE7s9jul6kAaSI9Sqb9F03iEYuap0BPgMr1OLbSja kDQnFI28KIqThFpsk9gEd7cVkoN6CUhG5OgWgA5NktexkXRYFvsgB9EQNDZnwZkM1KXgkj70xxZh f7ELQPmLu8XwwvzSM3w2PtgqnfHY97pgMgYOTSZjXPKEgJe8gjOsQBPdhzOskm_wrvk_I_SnJjG1 b4OF29zCccXGz_GmOAJAxKRqPun6XrjNC4lYqj54EsAs6gy71zK0R5OwOnGA_Jd81J5gL_dRAPa6 uDd5f476IOQLFnZeydS7H3RJA0vrINgXqWRgXd.quKMqVpwRvf9bnUy_dygDAmWS7w2Og2CfqeNS _jQz6G5G1JwxJQQaP6S4JZU3BBCHU5tALhGS6zjNGaP_sS7JUTNe9KWX9hw_29M0xJfCyLxTa9eB nmajwDiHT6D6LzvImtRJqtmrSBXh_V7bRNWVABfWjXKmIzVBK5rYo1gNr9cl46wjT8xUam_UBzbh X.m0ZPf3o3Lcg7hcxrHafJrK_o0iCo3yr0ZEOJZTwacKcqIELCWELp2ErPugdiQkgohWZJRmtXn7 SW8LOG5PKG0BvfOaBTAQ20cktX.DRCFW4psZsbIJshgnt4phBp2ZLTSeCJRQxENYU_pwrTASXpr4 xIlJybvTEoAa6U_MGB07mlYifRHPgUmiiBA_X2GG8X_qF7Yw1tn7r6GhmRHG7WUo5CQsW_V5g8kI XXLw2hmYjCJt.0cb7OGqI3F64ZyZDUwYT1.fKAO.LAqR4f5jbkGNqIhTwtMgoI.9ysdlODPCtUPN FLAbD_0nbgrx9ReCASl7XyeA9pHRSRl75CekRIsB29HnhMrqtAWW1GSkAb2WrD8m0XazIX6HHzAK DhAWdNHupLH8bwhpCoZFDvG37spd8xIxVyZ5af4bSobpHpWAbHkdvYwm2EcX8uon8jAlQcSn4pdz NewSkkzxFDyy39031C7dZDWITLi9W3AZsbeJrI0gtJUmyAIMozXSqUjlDotmZtvwEXjAVVLYYam. paIe.FSDJehumYyhD5ww9y68REU7Kqse4SRJHiLhWnuO_El2UoASNLinWYBsUjVQ1NwnLqdtIhRm DPIjN_WzBnK2uXGssdjOwpPBVAp2DNQMJ8MLbAQPaKK0DS9k.Ty86p0wTr0miil_6crazrW_bXaM j7WldzB4txl8e1PMhcSVXv4BErQhf7PAFwbipmGqjDyUlT0J3DBticGPP4gedRA4fedi.aF9BwDM tggqc4iMGta._sn7wGincP9NIIE1DMyudI6EFWDnLu4J4MEBLnElU1DJOAD1b7AZwYTTTrRDqYfh HCTY4NOazMjEnYRDaGDqgfFG8ZJ5FJm82J.XQ1sQifpylOKmGpsz3ejnHRPrFx8Yhz7clFjtz1mx W9hfwSRnAFC.PqKlW7eOztt2IWNWtRNBciwp9rghrHoqPF_b4KFAf4SCAj0oCrYOzMyJX4TQS1C5 CdN1qR_lSi2zrtJCKAVA3WJ73wk.A2IzQa839_i13BhvZJ__VRsCYmoclMolnW3azSDJYnwoqSCX NPvE2gUcnGfqaiV21jw-- X-Sonic-MF: X-Sonic-ID: e36eac0b-c006-4664-8353-275c3942305e Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ne1.yahoo.com with HTTP; Mon, 26 Jan 2026 17:44:38 +0000 Date: Mon, 26 Jan 2026 17:44:33 +0000 (UTC) From: felix.quintgz@yahoo.com To: pgsql-general@lists.postgresql.org Message-ID: <2097370962.4296686.1769449473672@mail.yahoo.com> In-Reply-To: References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com> <1730736265.4259921.1769443263077@mail.yahoo.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: 1131 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Any method that allows me to know who accessed the database and when. This is necessary for auditing the database. It's a requirement for financi= al applications. I can't use a table within the database because it gets overwritten upon re= storation. I don't have admin access to the database server; in SQL Server, I resolved= this using signed stored procedures. On Monday, January 26, 2026 at 11:10:50 AM GMT-5, Adrian Klaver wrote: On 1/26/26 08:01, felix.quintgz@yahoo.com wrote: > Is there a way to implement the SQL Server command 'BACKUP DATABASE'? Not from within the Postgres instance. You will need to use: https://www.postgresql.org/docs/current/app-pgdump.html > > Is there a way to see the restores performed on a database? > Is there an equivalent table to msdb.dbo.restorehistory in SQL Server? > Is there a way to implement an equivalent if one doesn't exist? From what I understand there are various ways of doing this in SQL Server, which way are you interested in? > > Thank you very much. > Regards > > F=C3=A9lix > > -- Adrian Klaver adrian.klaver@aklaver.com