Postgres Backup and Restore

For backing up a particular database in tar format pg_dump -U postgres -h 127.0.0.1 -Ft dbname > dbname.tar If you don't want to type password or use it inside script PGPASSWORD=pwd pg_dump -U postgres -h 127.0.0.1 -Ft dbname > dbname.tar Before yo...