The Penguinlinux.com Blog

Ok so I had to compile PostgreSQL at work and installed the most recent one. 8.2.5 and compiled it with perl, ssl support
I followed the instructions on the install file. I then created a postgres user and initialized the db and also
installed tsearch2 and ltree

everything worked fine except that when importing the data I got a few errors related to tsearch2 there is function that the new tsearch2 that is on 8.2.5 is missing so data from our backup can’t b e imported because that function does not exist.

So basically this is something the developers have to figure out if they want to stay with the old version of postgres or upgrade to the new version and still get the errors of the new tsearch2

Things I had to do copy a init.d/ script to start the db automatically the script was inside the /contrib/start-scripts folder then I copied the script and put it inside my /etc/init.d/ folder and changed permissions to execute and then I used chkconfig to make it start.

I also had to add paths to my /etc/profile so that the shell can find the path to the psql binaries and other cool tools.

I guess that is basically what I had to do to upgrade to the new postgres.

There wasn’t anything else special that I had to go , Oh I remember I had to install readline-devel because the .configure script was complaining that I didn’t have readline installed. I had the readline RPM installed but the configure script was looking for files included only on the readline-devel

so I did a yum install redline-devel

Later fellow penguin readers.