<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Depurar_de_Postgres_el_FS_de_Wals</id>
	<title>Depurar de Postgres el FS de Wals - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Depurar_de_Postgres_el_FS_de_Wals"/>
	<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Depurar_de_Postgres_el_FS_de_Wals&amp;action=history"/>
	<updated>2026-11-21T21:59:05Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.46.2</generator>
	<entry>
		<id>https://www.zabbix-es.com.es/index.php?title=Depurar_de_Postgres_el_FS_de_Wals&amp;diff=203&amp;oldid=prev</id>
		<title>Unknown user at 11:15, 2 July 2020</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Depurar_de_Postgres_el_FS_de_Wals&amp;diff=203&amp;oldid=prev"/>
		<updated>2020-07-02T11:15:31Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw-interface=&quot;&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 11:15, 2 July 2020&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l3&quot;&gt;Line 3:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 3:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  [postgres@zbxssoo01 ~]$ pg12&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  [postgres@zbxssoo01 ~]$ pg12&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  Environment Postgres 12 cargado!&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  Environment Postgres 12 cargado!&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;==Forzamos un Checkpoint==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt; [postgres@zbxssoo01 ~]$ psql –d postgres &lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt; checkpoint;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;==Recuperar el ultimo Wal generado==&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;==Recuperar el ultimo Wal generado==&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key wiki:diff:1.41:old-202:rev-203:php=table --&gt;
&lt;/table&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
	<entry>
		<id>https://www.zabbix-es.com.es/index.php?title=Depurar_de_Postgres_el_FS_de_Wals&amp;diff=202&amp;oldid=prev</id>
		<title>Unknown user: Created page with &quot;==Loguearnos como Postgres y cargar entorno==  [root@zbxssoo01 ~]# su - postgres  [postgres@zbxssoo01 ~]$ pg12  Environment Postgres 12 cargado!  ==Recuperar el ultimo Wal gen...&quot;</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Depurar_de_Postgres_el_FS_de_Wals&amp;diff=202&amp;oldid=prev"/>
		<updated>2020-07-02T11:11:10Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;==Loguearnos como Postgres y cargar entorno==  [root@zbxssoo01 ~]# su - postgres  [postgres@zbxssoo01 ~]$ pg12  Environment Postgres 12 cargado!  ==Recuperar el ultimo Wal gen...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==Loguearnos como Postgres y cargar entorno==&lt;br /&gt;
 [root@zbxssoo01 ~]# su - postgres&lt;br /&gt;
 [postgres@zbxssoo01 ~]$ pg12&lt;br /&gt;
 Environment Postgres 12 cargado!&lt;br /&gt;
&lt;br /&gt;
==Recuperar el ultimo Wal generado==&lt;br /&gt;
 [postgres@zbxssoo01 pg_wal]$ pg_controldata -D $PGDATA&lt;br /&gt;
 pg_control version number:            1201&lt;br /&gt;
 Catalog version number:               201909212&lt;br /&gt;
 Database system identifier:           6831258203631478219&lt;br /&gt;
 Database cluster state:               in production&lt;br /&gt;
 pg_control last modified:             Thu 02 Jul 2020 01:02:57 PM CEST&lt;br /&gt;
 Latest checkpoint location:           83DA/F10E8288&lt;br /&gt;
 Latest checkpoint&amp;#039;s REDO location:    83DA/D9503068&lt;br /&gt;
 Latest checkpoint&amp;#039;s REDO WAL file:    00000001000083DA000000D9    &amp;lt;--- Ultimo checkpoint&lt;br /&gt;
&lt;br /&gt;
==Verificar los wals que se va a cargar==&lt;br /&gt;
 [postgres@zbxssoo01 pg_wal]$ pg_archivecleanup -n $PGDATA/pg_wal/ 00000001000083DA000000D9&lt;br /&gt;
&lt;br /&gt;
==Eliminar los Wals==&lt;br /&gt;
 [postgres@zbxssoo01 pg_wal]$ pg_archivecleanup -d $PGDATA/pg_wal/ 00000001000083DA000000D9&lt;/div&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
</feed>