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

mofshamim profile image

Interface Segregation Principle (ISP)

Omar Faruque Shamim -

prince_beec5ccde00b7c6c73 profile image

Password Validator using html css and javascript

Prince -

Large Dataset - Pipeline, Seamless Scale-Up and Scale-Down

Vaibhav Bhutkar -

learn_n_share profile image

30 Days of Amplify 2024

Amandeep Singh -