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.94.2) (envelope-from ) id 1tkjLc-006K0S-LH for pgsql-es-ayuda@arkaria.postgresql.org; Wed, 19 Feb 2025 12:38:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tkjLa-00829M-Ly for pgsql-es-ayuda@arkaria.postgresql.org; Wed, 19 Feb 2025 12:38:38 +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.94.2) (envelope-from ) id 1tkjLa-00829D-E2 for pgsql-es-ayuda@lists.postgresql.org; Wed, 19 Feb 2025 12:38:38 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tkjLY-001lDT-23 for pgsql-es-ayuda@postgresql.org; Wed, 19 Feb 2025 12:38:38 +0000 Received: by mail-wr1-x42e.google.com with SMTP id ffacd0b85a97d-38f1e8efe82so7354091f8f.0 for ; Wed, 19 Feb 2025 04:38:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739968715; x=1740573515; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:disposition-notification-to :from:content-language:references:cc:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=3ImbtdvRANBgFshDi7ap50QhZ60o6ij76/amGstq6+8=; b=FkF0LKcK88s6fZSLBN4N7mcM0e5Fc6JDsCXZz0IsUgjmql029VeJegqLpk0hGblKCS IoqfYST1+pR19XaotWeJ5VvQmcdh8hVETBAwfb7F9KTxo94Xq7hbgY28ekeDAx7jUBG/ P8v5pVEjPtDD4SYsNiUqCdU2Or1jFxY/zn5iuVD+lKpNWb47vvknkXFLe+pRPdZzfrUV 2lt0BAYqH5GZUal8id9hcGJBWfYQv3sS1X3sl/CoaOVMm3WgAQMDH0/z00lZgMUwG8GJ 7i83bCoUQK99OWpWfn+/cZXYjRbveoBnUvQusuZKXQEIcdyJ/dBORLO8V0i4xjprJMil jq0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739968716; x=1740573516; h=content-transfer-encoding:in-reply-to:disposition-notification-to :from:content-language:references:cc:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=3ImbtdvRANBgFshDi7ap50QhZ60o6ij76/amGstq6+8=; b=peymPk3Z+vqqx77RqXqUzCVKKQnm6qUnup8ko4DgUEnGU7kgk+30tROSALvxwHno/y Xhe12yanJ4t5lGFkA8SMztEh5oikL5bxyj0PSbkCpa10QhCZPeQCpNUJUtzwTNFi3WPf PYT62xHK73f+QWoHH2q0ObqEoPubfgEPz5IpQJSFz0QXe6ytx7FUN72kV2S6GlU4LPIE ty/9IW05v+H9ggRKYVW4YZzx6yZZKT95qT8XM9DEQyK+Rw30MYdDMh5fy2EiojiIPzq6 jCFwJF8mutfqLED2ezLq8bj3Xv2CZtLN//kAQJYhSXRnd2BFDm9bcUD/Dv51Bu9y0Xs0 LcVQ== X-Forwarded-Encrypted: i=1; AJvYcCUdrBIbOYl9oeBBVWkpA7TymPBKLPxoECKTtmjSBh3CKVHFeqRthmrlSiCix1PuoXg/HxgdSevL2lKuDqzelw==@postgresql.org X-Gm-Message-State: AOJu0Yw743yVprkUPyNvwo/KAfQMFvHfTZUfz7BJHw1jpzdPw6TdiJPQ bcp5ZvVGAIzzrFz+EdHw67uXjKGqHtZp2WNREDJeWYgr11u49AUV X-Gm-Gg: ASbGncu5JeL6T+YypbKox9PAfrh0NIHKzwMRMzIam9nMXraZ/HgZYqPrnhs1rLvxJA/ BsinNk+qkhDeR7Rj8z7/rWyClkqJDb2AkfaLZK0yrYXV23scEqKqQgaRoonqFU+MYcIl20TS2o9 1lLzBUHKOBwZE8AE6hIxxBm3DorsHrZUIAHpE9L8TZzQoHqEKlDzXfqtZ8ipWLMUnoYX90LNGAT zhfL0jPcOt4kLSiuLzNaC1/Gdh2i8AeAswXU5NoFlC3jUOGkt914tTo+gTZKVkkULwG1+fRuXI9 IiDjh6NJZcdim0an5rVh0Rq1D3RhU94= X-Google-Smtp-Source: AGHT+IEVxHS1d1oejyCWL/L6j1IgXZrCFJOzkg7An+Zao1ZgtOsQ8zeZQzjLYOw9LV0MUPNWXcc3FQ== X-Received: by 2002:a5d:47a7:0:b0:38f:4f62:7e29 with SMTP id ffacd0b85a97d-38f4f627e84mr8436132f8f.26.1739968714928; Wed, 19 Feb 2025 04:38:34 -0800 (PST) Received: from [192.168.222.10] ([81.0.60.106]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38f259d94acsm18040087f8f.75.2025.02.19.04.38.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 19 Feb 2025 04:38:34 -0800 (PST) Message-ID: <2f4a0097-eec4-4a86-add8-64cff49804ba@gmail.com> Date: Wed, 19 Feb 2025 13:38:33 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: borrado de archivos WAl To: =?UTF-8?Q?Mart=C3=ADn_Marqu=C3=A9s?= , Fernando Monjes Cc: "Guillermo E. Villanueva" , Ayuda References: <16ae4604-6c39-4ec6-85ce-e4e4097f5507@gmail.com> Content-Language: es-ES From: kernel Disposition-Notification-To: kernel In-Reply-To: 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 Gracias por las explicaciones, he tenido que hacer un resetwal y restaurar una copia Voy a interesarme por el barman Gracias por vuestro tiempo!!! El 19/02/2025 a las 9:36, Martín Marqués escribió: > El mar, 18 feb 2025 a las 19:33, Fernando Monjes > () escribió: >> Si tienes barman si se pueden recuperar los wal, puedes hacer PITR esa es la gran maravilla de barman >> >> ejemplo >> barman recover number --remote-ssh-command "ssh postgres@ " --target-time="2021-03-22 03:22:47.681236-03:00" /var/lib/pgsql/15/data >> >> y te recupera esa linea de tiempo con los wal hasta esa fecha > Si tiene Barman, solo tiene que configurar `barman_wal_restore` o > copiar los WALs desde el servidor de backup al pg_wal del servidor. No > hace falta hacer un `restore` en este caso. >