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

uniquescadd profile image

Implementing BIM Technology for Sustainable Building Design

Uniquescadd -

ericksmith14 profile image

Tips and Tricks for Efficiently Using a Live Flight Tracker

Weatherstack -

hiringgo profile image

Top six things to consider while working with staffing Agency

hiringgo -

micromindercs profile image

IoT Security Vulnerabilities in Operational Technology: Addressing the Risks

mathew -