Ubuntu connect, create database and restore/import postgresql

PostgreSQL logo. (Photo credit: Wikipedia)

Hi everyone,
I want to share to you about setting database postgresql.

1. Connect database
    sudo -u postgres psql postgres
    password: postgres
2. Create database
    sudo -u postgres createdb mydb
3. Restore/import database
    sudo -u postgres psql -d mydb < database.dump

I hope this article can help you guys.