PostgreSQL

pg

1. INSTALL DATABASE POSTGRESQL

bedson@server:~$ sudo apt-get update

bedson@server:~$ sudo apt-get install postgresql postgresql-contrib

bedson@server:~$ sudo vi /etc/postgresql/9.1/main/postgresql.conf

# – Connection Settings –

listen_addresses = ‘db.ltsppos.net’
sudo service postgresql restart

memulai membuat database diposgresql
bedson@server:~$ sudo su – postgres
[sudo] password for bedson:
postgres@server:~$ createdb dbbgsoft //membuat database
postgres@server:~$ createuser -P //membuat user
Enter name of role to add: bedson
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
dbbgsoft=# psql –U bedson  -W dbbgsoft
bgsoft-#
2. INSTALL PHPPGADMIN AGAR DATABASE DAPAT DIAKSES MELALUI WEBROWSER

bedson@server:~$ sudo apt-get install phppgadmin
bedson@server:~$ sudo service apache2 start

bedson@server:~$sudo service postgresql restart

3. KEMUDIAN AKSES DATABASE DARI WEBROWSER

http://db.ltsppos.net/phppgadmin

JIKA KONFIGURASI SUDAH BENAR MAKA ANDA AKAN DAPAT MASUK DENGAN

TAMPILAN GAMBAR SEPERTI DIBAWAH INI:
phpgadmin

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s