Backup and restore postgresql database

Backup and restore postgresql database

              
                <h2>backup postgresql</h2>
pg_dump -U user-name -d source_db -f dumpfilename.psql
<h2>restore postgresql</h2>
psql -U  user-name -d desintation_db -f dumpfilename.sql