Installing Postgres in Fedora Core 10 and Setting of default password

Lately, I was trying to install a new postgresql server in my FC10 box. I thought it was as easy as 1,2,3 but I discovered it needed some technical knowledge to install postgresql server.

After reading few blogs and my personal google docs, I came up with the following procedure.

Installing postgresql server
- Go to System -> Add/Remove Software
- Search for postgresql
- install postgresql-server and postgresql client files
- after installation, you have to initialize your database
- open terminal
- su root
- su postgres
- cd ~
- initdb data
- then start postgresql server with pg_ctl -D data -l logfile start

Setting default password for user postgres
- without exiting the terminal or su postgres, type
psql -c "ALTER USER postgres WITH PASSWORD 'password'" -d template1

that's it for now....