Once I download some data (see Data Sources) I will need to put it somewhere so I downloaded and installed PostGIS. In fact the Fedora install system has PostGIS in it and automatically pulls down PostgreSQL and installs it for you so this is quite easy. The only problem is finding where it put everything [1].
I then created a user role for my self using the createuser command. It’s quite easy you just follow the prompts.
As I wanted to be able access this database from other machines on the local net work I also had to edit /var/lib/pgsql/data/pg_hba.conf to add
host all all 128.118.54.0/24 md5
so other machines on my network (128.118.54.*) could log on to the database (and remember to restart postmaster).
Footnotes
| [1] | /usr/share/pgsql/contrib/postgis-1.5 |