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

danilop profile image

Testing AI-Powered Apps: Introducing LLM Test Mate

Danilo Poccia -

rashmit_mhatre_40c3a37e37 profile image

Creating a Dream Recorder using React, Vite, and Tolgee 😀🐁

Rashmit Mhatre -

mohdtahzeebkhan profile image

Why Nextjs is Better Than Reactjs

Mohammad Tahzeeb Khan -

treasure_joy profile image

Core Azure Architectural components

Treasure Joy -