Posts

Showing posts from May, 2020

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