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

alwalxed profile image

These Two Tools Helped Me Earn $40K in Bounties

Awa -

karavvayala_sravansaiku profile image

Explaining Data Science Models to Everyone: Making Complex Concepts Understandable

KARAVVAYALA SRAVAN SAI KUMAR 20BCE2659 -

mrcaption49 profile image

EXPLAIN PLAN & DBMS_PROFILER Explanation

Pranav Bakare -

karenpayneoregon profile image

Window Forms Dark mode

Karen Payne -