Postgresql setting

hi, before i have write about setting postgresql in my blogger at http://agustiono.wordpress.com , but now i wan to write in english.

u can click in here for indonesian languages.

Ok first step for configuration postgresql at your server.

1. login fro shell as "root"
2. from command type "su postgres"
root@love [~]# su postgres

3.after login as user postgres create database test
bash-2.05b$ createdb test
CREATE DATABASE

4.after thats in postgresql u can view database test
bash-2.05b$ psql test

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

5.so in postgresqlnya we create user super user :). example user usertest with password passtest
test=# create user usertest createdb createuser password ‘passtest’;
CREATE USER
test=#

6.and edit /var/lib/pgsql/data/postgresql.conf with vi /var/lib/pgsql/data/postgresql.conf. and change tcpip_socket with true
tcpip_socket = true

7.after thats edit /var/lib/pgsql/data/pg_hba.conf and addressing line like below. example ip server 65.75.155.210 :
host all all 65.75.155.210 255.255.255.255 trust

8.now u can download phpPgAdmin from http://prdownloads.sourceforge.net/phppgadmin/phpPgAdmin-3.3.tar.gz?download

9. extract in folder web with command
tar zxvf phpPgAdmin-3.3.tar.gz

10.edit file configure phpPgadmin , file conf/config.inc.php
edit :

$conf['servers'][0]['host'] = ‘127.0.0.1′; // Hostname or IP address for server.
rubah 127.0.0.1 sesuai dengan ip pada langkah nomor 7
11.restart postgresql
root@love [~]# /etc/init.d/postgresql restart

12.open web browser and type http://yourdomain.com/phpPgAdmin/
13.input username and password like step nomber 5
14.after login ,create super user whatever you wan, and logout
15.from command, edit /var/lib/pgsql/data/pg_hba.conf and edit :
host all all 65.75.155.210 255.255.255.255 trust
as :
host all all 65.75.155.210 255.255.255.255 password

16.restart postgresql
root@love [~]# /etc/init.d/postgresql restart

17.if you get error like this “Login disallowed for security reasons.”
change your configuration phppgadmin at file “config.php atau config.inc.php” with line
$conf['extra_login_security'] = true;
as
$conf['extra_login_security'] = false;