---
title: "Panduan Backup dan Restore Database PostgreSQL via Terminal | Clouden"
description: "Panduan ini menjelaskan cara melakukan pencadangan (backup) dan pemulihan (restore) database PostgreSQL menggunakan Command Line Interface (CLI).I. Prasyar..."
canonical_url: "https://clouden.id/panduan/panduan-backup-dan-restore-database-postgresql-via-terminal/"
meta:
  "og:description": "Panduan ini menjelaskan cara melakukan pencadangan (backup) dan pemulihan (restore) database PostgreSQL menggunakan Command Line Interface (CLI).I. Prasyar..."
  "og:image": "https://clouden.id/_og/s/o_c969060bfdb72494.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Panduan Backup dan Restore Database PostgreSQL via Terminal"
  "twitter:image": "https://clouden.id/_og/s/o_c969060bfdb72494.png"
---

> Index of every page on this site: [llms.txt](https://clouden.id/llms.txt)

[**Beranda **](https://clouden.id/panduan/) [**Hosting**](https://clouden.id/panduan/kategori/hosting/)**Panduan Backup dan Restore Database PostgreSQL via Terminal**

# **Panduan Backup dan Restore Database PostgreSQL via Terminal**

**Terakhir diperbarui pada 8 April 2026**

Panduan ini menjelaskan cara melakukan pencadangan (backup) dan pemulihan (restore) database PostgreSQL menggunakan Command Line Interface (CLI).

## I. Prasyarat

Sebelum memulai, pastikan Anda memiliki:

- Akses Terminal
- PostgreSQL.
- Ruang penyimpanan yang cukup untuk menampung file hasil backup.

## II. Metode Backup PostgreSQL

### 1. Backup Satu Database (Format .sql)

Gunakan perintah `pg_dump` untuk mengekstrak database ke dalam file teks SQL.

`pg_dump -U nama_user -d nama_database > nama_file_backup.sql`

### 2. Backup dengan Kompresi (Format .dump)

Sangat direkomendasikan untuk database besar agar ukuran file lebih kecil dan proses restore lebih fleksibel.

`pg_dump -U nama_user -F c -f nama_file_backup.dump nama_database`

- ****-F c****: Menggunakan format *custom* (terkompresi).
- ****-f****: Menentukan nama file output.

## III. Cara Restore (Pemulihan) Data

Proses restore bergantung pada format file backup yang Anda miliki:

### 1. Restore dari File .sql (Plain Text)

Gunakan utilitas `psql`:

`psql -U nama_user -d nama_database -f nama_file_backup.sql`

### 2. Restore dari File .dump (Custom Format)

Gunakan utilitas `pg_restore`:

`pg_restore -U nama_user -d nama_database -v nama_file_backup.dump`

- ****-v****: *Verbose mode* (menampilkan detail proses di terminal).

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://clouden.id/#website","@type":"WebSite","name":"Clouden","url":"https://clouden.id/","publisher":{"@id":"https://clouden.id/#identity"}},{"@id":"https://clouden.id/panduan/panduan-backup-dan-restore-database-postgresql-via-terminal/#webpage","@type":"WebPage","description":"Panduan ini menjelaskan cara melakukan pencadangan (backup) dan pemulihan (restore) database PostgreSQL menggunakan Command Line Interface (CLI).I. Prasyar...","name":"Panduan Backup dan Restore Database PostgreSQL via Terminal","url":"https://clouden.id/panduan/panduan-backup-dan-restore-database-postgresql-via-terminal/","isPartOf":{"@id":"https://clouden.id/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://clouden.id/panduan/panduan-backup-dan-restore-database-postgresql-via-terminal/"]}],"primaryImageOfPage":{"@id":"https://clouden.id/#logo"}},{"@id":"https://clouden.id/#identity","description":"Clouden adalah penyedia layanan hosting murah berkualitas serta domain Indonesia dan internasional dengan jaminan uptime 99,9%.","email":"sales@clouden.id","name":"Clouden","priceRange":"$","telephone":"+62-821-3000-5337","url":"https://clouden.id","@type":["Organization","LocalBusiness"],"address":{"@type":"PostalAddress","streetAddress":"Perum Bangau Putih Permai","addressLocality":"Tulungagung","addressRegion":"Jawa Timur","postalCode":"66229","addressCountry":"ID"},"image":{"@id":"https://clouden.id/#/schema/image/1"},"sameAs":["https://www.facebook.com/cloudenid/","https://www.instagram.com/cloudenid/","https://www.linkedin.com/company/akselerasi-prima-digital/","https://www.youtube.com/@cloudenid"]},{"@id":"https://clouden.id/#/schema/image/1","@type":"ImageObject","contentUrl":"https://clouden.id/assets/images/og-image.png","inLanguage":"id","url":"https://clouden.id/assets/images/og-image.png"},{"@id":"https://clouden.id/#logo","@type":"ImageObject","caption":"Clouden","contentUrl":"https://clouden.id/assets/images/logo.svg","inLanguage":"id","url":"https://clouden.id/assets/images/logo.svg"},{"@id":"https://clouden.id/#organization","@type":"Organization","logo":"https://clouden.id/assets/images/logo.svg","name":"Clouden","url":"https://clouden.id","address":{"@type":"PostalAddress","streetAddress":"Perum Bangau Putih Permai","addressLocality":"Tulungagung","addressRegion":"Jawa Timur","postalCode":"66229","addressCountry":"ID"},"sameAs":["https://www.facebook.com/cloudenid/","https://www.instagram.com/cloudenid/","https://www.linkedin.com/company/akselerasi-prima-digital/","https://www.youtube.com/@cloudenid"]}]}
```

## Sitemap

See the full [sitemap](https://clouden.id/sitemap.md) for all pages.