DEV Community

Agik Setiawan
Agik Setiawan

Posted on

Dump and Restore Postgesql

Dump

pg_dump POSTGRESQL_URL > my_db.sql
Enter fullscreen mode Exit fullscreen mode

Restore

psql -h HOST_DB -U USERNAME existing_db < my_db.sql
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

tallesl profile image

Handling Python event loop shutdown without exceptions

Talles L -

nolunchbreaks_22 profile image

Navigating the Security Landscape of Docker Containers: A DevSecOps Perspective

Osagie Anolu -

cloudgeek7 profile image

Exploring AWS EKS Auto Mode: A Simplified Kubernetes Experience

Madhu Kumar -

javaparainiciantes profile image

Tipos brutos e código legado

Java para Iniciantes (Oracle) -