Secure Installation of Postgresql

General Information

This guide will help you set up, and start running PostgreSQL using the ports tree. ugg grise ugg classic mini air jordan 31 bns gold chaussure asics For information of how to use PostgreSQL, try google. asics france new balance avis new balance avis This guide will not help you with PostgreSQL past installing it.


You will need the following items to be able to complete this guide:

  1. Root access to a FreeBSD machine
  2. FreeBSD install with ports up-to-date


This is where your up-to-date ports come in handy.

 # cd /usr/ports/databases/postgresql80-server/ # make install 

Setting up PostgreSQL

There is little to do for the PostrgreSQL set up, but these steps are required. ffxiv Items basket nike air max 1 nike free ugg promo You could go with the defaults in the rc script, but that leaves you open for attack from local untrusted users.

 # mkdir /usr/local/pgsql/data # chown pgsql:pgsql /usr/local/pgsql/data # su -l pgsql -c "initdb -D /usr/local/pgsql/data -W -A md5" # echo 'postgresql_enable="YES"' >> /etc/rc.conf 

This initializes the database, and lets you set the “super user” password, as well as telling PostgreSQL to only allow authentication if the client sends a md5 encrypted password. new balance france nike femme solde This is for security if you are going to be accessing it over the network.

Starting PostgreSQL

There are two ways that you can start PostgreSQL. adidas femme nike air max flyknit Chaussures Adidas Reboot your system, or execute it’s rc file.

 # /usr/local/etc/rc.d/ start 

It should now be running. nike air max 2016 soldes adidas gazelle pas cher asics pulse soldes Christian Louboutin Pas Cher To see if it really is running, check with ps.

 # ps auxwwww | grep postmaster 

You should see a postmaster process running. nike free nike air max flyknit new balance france ffxiv gil That is what the postgresql people called their server, don’t ask why!

Using PostgreSQL

Using PostgreSQL can be done one of two ways. blade and soul gold Chaussures adidas running nike pour homme pas cher soldes timberland ugg australia chaussures adidas One way is to install phpPgAdmin, which allows you to use a web interface to add users, add databases, and other such neat features, or one can make use of the psql tool that is available.

 # psql   

I will not walk you through adding users to psql, or even executing queries.

Speak Your Mind