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 http://www.postgresql.org/ftp/source/ and extract it.

$ wget http://ftp.postgresql.org/pub/source/v8.2.19/postgresql-8.2.19.tar.gz

$ 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

Filed Under: DatabaseLinuxTechnologyTutorialUbuntu

RSSComments (0)

Trackback URL

Leave a Reply




If you want a picture to show with your comment, go get a Gravatar.