https://wiki.haidhi.my.id/wiki/index.php?action=history&feed=atom&title=Cara_Backup_Postgres_Docker
Cara Backup Postgres Docker - Revision history
2026-11-01T23:38:32Z
Revision history for this page on the wiki
MediaWiki 1.43.0
https://wiki.haidhi.my.id/wiki/index.php?title=Cara_Backup_Postgres_Docker&diff=389&oldid=prev
SanzSkuy: /* ambil backup dari database asal */
2025-05-27T08:04:43Z
<p><span class="autocomment">ambil backup dari database asal</span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:04, 27 May 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>=== ambil backup dari database asal ===</div></td><td class="diff-marker" data-marker="+"></td><td style="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;"><div>=== ambil backup dari database asal <ins style="font-weight: bold; text-decoration: none;">(jalanin salah satu) </ins>===</div></td></tr>
<tr><td class="diff-marker"></td><td style="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;"><div><syntaxhighlight lang=bash></div></td><td class="diff-marker"></td><td style="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;"><div><syntaxhighlight lang=bash></div></td></tr>
<tr><td class="diff-marker"></td><td style="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;"><div>docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data</div></td><td class="diff-marker"></td><td style="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;"><div>docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data</div></td></tr>
</table>
SanzSkuy
https://wiki.haidhi.my.id/wiki/index.php?title=Cara_Backup_Postgres_Docker&diff=388&oldid=prev
SanzSkuy: Created page with "=== ambil backup dari database asal === <syntaxhighlight lang=bash> docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data docker exec -i postgres-container pg_dump -U USERNAME -a DB_NAME > backup.sql # backup data only docker exec -i postgres-container pg_dump -U USERNAME -s DB_NAME > backup.sql # backup struktur only </syntaxhighlight> === Backup di container postgres yang baru === <syntaxhighlight lang=bash> docke..."
2025-05-27T08:04:18Z
<p>Created page with "=== ambil backup dari database asal === <syntaxhighlight lang=bash> docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data docker exec -i postgres-container pg_dump -U USERNAME -a DB_NAME > backup.sql # backup data only docker exec -i postgres-container pg_dump -U USERNAME -s DB_NAME > backup.sql # backup struktur only </syntaxhighlight> === Backup di container postgres yang baru === <syntaxhighlight lang=bash> docke..."</p>
<p><b>New page</b></p><div>=== ambil backup dari database asal ===<br />
<syntaxhighlight lang=bash><br />
docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data<br />
docker exec -i postgres-container pg_dump -U USERNAME -a DB_NAME > backup.sql # backup data only<br />
docker exec -i postgres-container pg_dump -U USERNAME -s DB_NAME > backup.sql # backup struktur only<br />
</syntaxhighlight><br />
<br />
=== Backup di container postgres yang baru ===<br />
<syntaxhighlight lang=bash><br />
docker cp backup.sql new-postgres-container:/backup.sql<br />
docker exec -i new-postgres-container bash<br />
<br />
# di dalam container (pastikan db nya udah ada)<br />
psql -U USERNAME -d DB_NAME -f /backup.sql<br />
</syntaxhighlight></div>
SanzSkuy