Home > PHP, Ubuntu, postgresql > Install postgresql on Ubuntu with php5

Install postgresql on Ubuntu with php5

October 16th, 2009 Leave a comment Go to comments

In this installation we integrate postgresql into this apache installation.

First we refresh our package management and our packages:

apt-get update
apt-get upgrade

Then we have to install the basic packages:

apt-get install postgresql postgresql-server-dev-8.3 php5-pgsql

Now we have to do the basic setup of the postgresql server:

sudo -u postgres psql template1

Now you can define a passwort for the postgres user:

\password postgres

To leave the prompt enter:

\q
Categories: PHP, Ubuntu, postgresql Tags: