useful database commands for dump i.e. backup and restore postgresql and mongodb

postgres_useful_commands.sh

#resetting the password of postgresql
sudo -u postgres psql postgres
postgres=# \password postgres

# restoring postgres dump database
pg_restore -c -i -U postgres -h localhost -d database_name -v "dump_file" -W
pg_restore --verbose --host localhost --username postgres --clean --no-owner --no-acl --dbname database_name dump_file.dump
# for mac: full path is required.
Applications/Postgres.app/Contents/Versions/9.4/bin/pg_restore -c -i -U postgres -h localhost -d database_name -v "dump_file" -W

# database back up using psql command and with password
psql -h localhost -d database_name -U postgres -W > db.sql

# database restore using psql command
psql -d db_name -f db_dump.sql

#Mongo dump restore command.
mongorestore --host=127.0.0.1 --port 27017 mongo_dump_path/