How to Downgrade to PostgreSQL 8.2 on Ubuntu 11.10

Ubuntu 11.10 comes with PostgreSQL 8.4.

I did this downgrade because my web application, Hospital Management System, was developed using PostgreSQL 8.2 database and it will throw SQL query error if running on version 8.4.

This is step by step guide how to install PostgreSQL 8.2 on Ubuntu 11.10

1.Download source code from and extract it.

$ wget

$ tar zxvf postgresql-8.2.19.tar.gz

2. Configure, compile, and install

$ cd postgresql-8.2.19

$ ./configure --without-readline --without-zlib

$ make

$ su

$ make install

3. Create postgres user

$ sudo adduser postgres

4. Create user data

$ sudo mkdir /usr/local/pgsql/data
$ sudo chown postgres /usr/local/pgsql/data

5. Initialize database

$ su - postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

6. Edit PostgreSQL configuration file

$ sudo nano /usr/local/pgsql/data/postgresql.conf

And uncomment this line:

listen_addresses = 'localhost'

7. Run PostgreSQL

$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data &

8. Create test database

$ /usr/local/pgsql/bin/createdb test
$ /usr/local/pgsql/bin/psql test

9. Don’t forget to install php pgsql module

$ sudo apt-get install php5-pgsql

10. Reload apache

$ sudo /etc/init.d/apache reload

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.