PATH=/usr/local/pg713/bin:$PATH export PATH export LD_LIBRARY_PATH=/usr/local/pg713/lib export PGDATA=/usr/local/pg713/data export PGLIB=/usr/local/pg713/lib export POSTGRES_HOME=/usr/local/pg713 mkdir /usr/local/pg713 ./configure --prefix=/usr/local/pg713 --with-perl --with-tcl --with-CXX --with-python --enable-odbc make make install ### Now we need to install the perl interface for postgresql. gmake -C src/interfaces/perl5 install cd /usr/local/src/postgresql-7.1.3/src/interfaces/perl5 perl Makefile.PL make ### Uncomment the next line if you want to test it. ## su -c 'make test' postgres make install ### Change ownership of all files to the user postgres. chown -R postgres /usr/local/pg713 ### Initialize the database. su -c '/usr/local/pg713/bin/initdb -D /usr/local/pg713/data' postgres ### Start the database server. su -c '/usr/local/pg713/bin/pg_ctl -o " -p 6000 " -D /usr/local/pg713/data -l logfile start' postgres ### The interfaces for perl, tcl, and pl/pgsql should have been created. ### Now add them. su -c 'createlang -p 6000 plpgsql template1' postgres su -c 'createlang -p 6000 pltcl template1' postgres ### Now assuming you have perl 5.6.1 installed correctly. rm -f /usr/local/pg713/lib/libperl.so ln -s /usr/lib/perl5/5.6.1/i686-linux/CORE/libperl.so \ /usr/local/pg713/lib/libperl.so su -c 'createlang -p 6000 plperl template1' postgres ### If it worked out correctly, any new database will copy itself from ### template1 and have perl, tcl, and pl/pgsql. ### Now additional stuff. su -c 'createdb -p 6000 postgres' postgres