Postgresql Installation Example | Postresql Short Script Install Database

just very very short postgres startup steps.

1. uncompress/install
2. find initdb file to run init of postgr
3. pg_ctl -D /usr/local/var/postgres -l /home/postgres/server.log start
4. psql
5. psql> create database db1name
6. \connect database_name

> net conf -> pg_hba.conf
> db conf  -> postgresql.conf
> db transaction logs -> ../../pg_xlog   ( -D /usr/local/var/postgres )


postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres