How to restore PostgreSQL database dump

They'res a magnitude of methods to restore PostgreSQL dumps for a typical plaintext dump "psql" can do a pretty neat Job

In few words a PostgreSQL plaintext dump is nothing but a corpus embodied with SQL statements, which when executed tables are created data gets retrieved, inserted and restored.

So assuming you have a backup dump saved somewhere on your system open your terminal.

And type;

psql -U {{username}} < {{dump.sql}}

That's it you've imported a database dump

Comments

Popular posts from this blog

How to set content disposition header for nginx server to force content download

How to create zip archives in nodejs

How to make a Snake Game using JavaScript and html5

How to draw clouds on HTML5 Canvas

How to resume a suspended web audio api context