PostgreSQL: Dump(Backup) and Restore a Database

Backup pg_dump is the utility i am using for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers). Restore pg_restore is the utility i am using for restoring a PostgreSQL database from an archive created