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)

profile
AWS
 Promoted

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More

Read next

mikeyoung44 profile image

New Benchmark Tests How Well AI Can Update Its Visual Knowledge While Retaining Information

Mike Young -

mikeyoung44 profile image

AI Expert System Gets 2% Smarter by Rerouting Tasks on the Fly

Mike Young -

mikeyoung44 profile image

AI System Breaks Down Complex Code Fixes Into Simple Steps, Boosting Success by 25%

Mike Young -

mikeyoung44 profile image

Study Reveals Punctuation Acts as Memory Anchors in AI Language Models

Mike Young -

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay