With the recent incident of Cloudflare, many services world-wide had severe impacts. I've a shared hosting server where I've had deployed my clients' website and also databases are maintained in the same. As cloudflare went down, all of my docker containers collapsed and got corrupt. Because of this, even when I managed to brink back the websites live, they couldn't read data from the database. That day I realized the importance of DB replications (horizontal scaling) and frequent DB backup.
&nbsp;
Today we are going to look into how we can secure data from the corrupt Postgres container.
 ℹ️ Note that this only works if the docker volume (where the data are stored) is not deleted.
&nbsp;
Steps to perform to secure the data from corrupt database container:
<ol style="text-align: left;">
<li style="font-size: 14pt;">Check if the docker volume exists:  The following command helpts to check the volume. 
<pre class="language-javascript" style="font-size: 11pt;"><code>docker volume ls</code></pre>
&nbsp;
</li>
<li style="font-size: 14pt;">Note the volume name you want to secure. If you don't see the volume, then you cannot recover it. This means the data are actually deleted. </li>
<li style="font-size: 14pt;">Run a new Postgres docker container with the existing volume. Note to use the same docker Postgres version as it was before. For example: I had Postgres version 17 and volume with name `captain--floraldb` 
<pre class="language-javascript" style="font-size: 11pt;"><code>docker run -d \
 --name postgres17 \
 -e POSTGRES_PASSWORD=mysecret \
 -v captain--floraldb:/var/lib/postgresql/data \
 postgres:17</code></pre>
&nbsp;
</li>
<li style="font-size: 14pt;">After this, make a dump of the .sql file. 
<pre class="language-javascript" style="font-size: 11pt;"><code>docker exec -it &lt;container_name_or_id&gt; pg_dumpall -U postgres &gt; dump.sql</code></pre>
&nbsp;
</li>
<li style="font-size: 14pt;">Start a new Postgres container with a fresh volume and required version. Used Postgres 18 here. 
<pre class="language-markup" style="font-size: 11pt;"><code> docker run -d \
 --name postgres18 \
 -e POSTGRES_PASSWORD=&lt;password&gt; \
 -v captain--postgresql-blog-data:/var/lib/postgresql \
 postgres:18</code></pre>
&nbsp;
</li>
<li style="font-size: 14pt;">Restore the dump 
<pre class="language-javascript" style="font-size: 11pt;"><code>docker exec -i postgres18 psql -U postgres &lt; dump.sql</code></pre>
&nbsp;
</li>
<li style="font-size: 14pt;">Check if the data is restored 
<pre class="language-javascript" style="font-size: 11pt;"><code>1. docker exec -it &lt;postgres-container-id&gt; sh
2. psql -U postgres
3. List database: \l
4. Connect database: \c &lt;db-name&gt;
5. Query database: run select query to verify your data</code></pre>
&nbsp;
</li>
</ol>
And that's all. With these steps, you can easily recover the corrupt database. 🔥

Steps to perform to securely recover data from corrupt PostgreSQL Docker container 🧑🏽‍💻 

Search results for Tag: "postgresql"

Tags

Blogs

Search results for Tag: "postgresql"

TagsReset

Blogs

Tags