Hello World from OSS Silicon Valley


HowToUse/PostgreSQL/9.2


_ Prerequisite

  • Amazon Linux installation

_ Install&Setup

_ Amazon Linux

Step.1
Install PostgreSQL.
$ sudo yum install postgresql postgresql-server postgresql-contrib pgadmin3
Step.2
Set up the initial password for postgres user.
$ sudo passwd postgres
<password>
Step.3
Initialize DB
$ sudo service postgresql initdb
$ sudo /etc/rc.d/init.d/postgresql start
$ sudo chkconfig postgresql on
Step.4
Setup the initial password for postgres DB user.
$ su - postgres
$ psql
postgres=# alter user postgres with password '<password>';
Step.4
Launch pgAdminIII.
Install_fig1.png
Install_fig2.png
Step.5
Access DB.
Install_fig3.png
Install_fig4.png

_ HowToUse

Step.1
xxx

_ Author

S.Yatsuzuka