Hello World from OSS Silicon Valley


HowToUse/PostgreSQL/9.2


  • The added line is THIS COLOR.
  • The deleted line is THIS COLOR.
#contents

*Prerequisite [#i4598436]
-Amazon Linux installation

*Install&Setup [#z080214c]
**Amazon Linux [#af160a4a]
: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.

#ref(Install_fig1.png,,500x266,)
#ref(Install_fig2.png,,500x266,)

:Step.5|
Access DB.

#ref(Install_fig3.png,,500x266,)
#ref(Install_fig4.png,,500x266,)


*HowToUse [#maf95962]
:Step.1|
xxx

*Author [#yddb7860]
S.Yatsuzuka