Install PostgreSQL Server and PostGIS on Fedora 14

To install PostgreSQL on Fedora 14 perform the following:

yum install postgresql postgresql-server
service postgresql initdb
service postgresql start
yum install postgis
chkconfig --add postgresql

Configure PostgreSQL

Change Password

passwd postgres
su - postgres
psql -d template1 -c "ALTER USER postgres WITH PASSWORD 'CHANGEME';"

Create and Connect to Database

createdb testdatabase
psql testdatabase

Create a PostgreSQL Table

Once connected to the database issue the following command:

CREATE TABLE mytable (fieldId int, firstName varchar, lastName varchar);

Exit

\q