adding Postgresql yum repository - Fedora 10

download here your rpm
as root: rpm -Uvh 'file_rpm'
cd /etc/yum.repos.d
Edit fedora.repo and fedora-updates.repo [fedora] sections
Add exclude=postgresql* to the bottom of the section.

installing PostgreSQL 8 via yum

as root: yum install postgresql postgresql-server
service postgresql initdb then service postgresql start
su - postgres
createuser -P dbadmin
logout

adding rpmfusion repository

for Fedora 8, 9, 10
as root: rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm

Essential free software:

• avidemux


• gstreamer-plugins-ugly


• gstreamer-plugins-bad


• lame


• mplayer (or mpg321)


• amule