Ubuntu connect, create database and restore/import postgresql

PostgreSQL logo.
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.
Enhanced by Zemanta

Komentar

Postingan populer dari blog ini

EPrT English Proficiency Test Soal - soal

cara memunculkan dan menyembunyikan icon date, time, clock, volume, network, power battery, action center pada taskbar pada Windows 7

Cara Mengurus Perpanjang SIM dan Rincian Biaya di Lumajang.