Postgres database restore via dumps

I am developer/code-reviewer/debugger/bug-fixer/architect/teacher/builder from dubai, uae
Search for a command to run...

I am developer/code-reviewer/debugger/bug-fixer/architect/teacher/builder from dubai, uae
No comments yet. Be the first to comment.
with T.A.C.T

Isolation is part of a database's ACID guarantees. It ensures that concurrent transactions don't affect each other. The goal is to maintain the state of the data as if transactions are run serially. H

You Should Tell Yourself

A URL shortener is a proxy service that provides a mapping between the short and full representation of a URL. The short URL has the advantage of being small. The service can also provide useful analy

Listening to the Mel Robbins's podcast on regrets was a 'ear'-opener. One can have reqrets of action or inaction. 4 types of reqrets foundation - should've done the work boldness - should've taken t

Create the database dump (you'll be prompted for the password)
pg_dump -U<DB_USER> -h<DB_HOST> <DB_NAME> > dumpfile
Copy over the dump file to the new machine that has postgresql installed
Recreate the DB or drop individual tables
Apply the dump
psql -U<DB_USER> -h<DB_HOST> -d <DB_NAME> < dumpfile
The dumpfile might need to be altered to be ingested into a higher versioned DB