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 1vkPB3-00EaCZ-0w for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 16:10:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vkPB1-008wKd-1K for pgsql-general@arkaria.postgresql.org; Mon, 26 Jan 2026 16:10:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vkPB0-008wKU-2R for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 16:10:55 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vkPAy-00000000ZAl-056s for pgsql-general@lists.postgresql.org; Mon, 26 Jan 2026 16:10:54 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.phl.internal (Postfix) with ESMTP id D3D06EC00D8; Mon, 26 Jan 2026 11:10:49 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Mon, 26 Jan 2026 11:10:49 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1769443849; x=1769530249; bh=vhYKli8zncF8qpIFbNm7POefprY7IVyBntBn9KJOBzA=; b= DKvu0G1vQ7dgEhmaX/6EVamJaBhtkfgqNVB3LTdFOgV4WpawShXm3iul7oDeCxSp dUykMRX7sQafJ8TVpqL9oCZBfzatdhCcG+KubcDkYAGV0ycNefK2GHBWYRsI3tKT OoONg9Z+iB7IUcl61pj+5uIyZJG4siTQcp9ApEfO5BDZwpIztZXykiRitSQ7kz25 DSsQFVkxORDE1kR33vq5dM3T0yTWb33/Dm6zCvW5LPvVtkKBkGS4lJsDe6BMMONo xosYaGnYo+cqnn+rqvHg1o+/i7kE+W8EHict8Dtb/Uo5iU/vBNRoxgvqHxQzkgyI rllmXZBdTju4UDg+jIP0BA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1769443849; x=1769530249; bh=v hYKli8zncF8qpIFbNm7POefprY7IVyBntBn9KJOBzA=; b=jUlecsNTdWxAc+mMs Onw/wuuwesjoz/6qhJ0X8R01yWylFQ6ejyzrv8zAxFnWtpJa3VB/gK3GqSabQ8Fu B9jF/h7EmDeKSHbTIZ5XzHsdEyZAPBwn51VXRud8j/oK81wZNRjjIDLA7G7SKsaw Fpyu7mCjOnSnIYtMv+yddmihfFGPdDoL4nJv2cp00TG+b9hpVS3k1VxYJcNdHxf/ Tou6jH/AWBp7cT/a11/ClYNkv+L5Ie2f7HlHH6p761bCX591Z82RGDTp6MCLMzVM cP1gzYN3wvOttPd1/OYuxoIcpXmyz1qTnaIx5sIUubD3G4Gq0Vmoq6W+NxAz3JWf Zc+Dw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduheekudduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtkeertd dtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgr vhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepleegveekkeekue eigfdtveeileeuhfefudefteekjeffkeejueejheegheegkedtnecuffhomhgrihhnpehp ohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm pdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehfvg hlihigrdhquhhinhhtghiiseihrghhohhordgtohhmpdhrtghpthhtohepphhgshhqlhdq ghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 26 Jan 2026 11:10:49 -0500 (EST) Message-ID: Date: Mon, 26 Jan 2026 08:10:48 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: About backups To: felix.quintgz@yahoo.com, pgsql-general@lists.postgresql.org References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com> <1730736265.4259921.1769443263077@mail.yahoo.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <1730736265.4259921.1769443263077@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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élix > > -- Adrian Klaver adrian.klaver@aklaver.com