Personal #databases#php 1 min

Installing PostgresSQL 7.0.2

Translation of the original in Catalan. Read it in: CatalàCastellano

Updating PHP and adding postgres to the portal server.

In order to install the calendar program that interests me on the portal I have had to install Postgres on the server, since otherwise I had to modify the source code of the calendar, which is in php, and I had no time to do it.

Taking advantage of this change in PHP, which now has to support pg, I have updated the version of PHP and I have put 4.0.2, I still had 4.0.1, so the config line of PHP has ended up like this: ./configure --prefix=/usr/local/php4 --enable-ftp --with-apxs=/usr/local/apache- ssl/bin/apxs --enable-versioning --with-mysql=/usr/local/mysql --enable-track-va rs --enable-xml --with-gd --with-mcrypt --with-mhash --without-ttf --with-pgsql= /usr/local/pgsql

This is a line practically the same as the one used at maestratnet.net but I have added pg support. But initially it did not work properly, since I was missing a couple of libraries:

libmcrypt --> freshmeat.net

libmhash --> mhash.sourceforge.net

1 comment

Comments from the old blog, as they were written. Comments are closed.

  1. Oriol Rius

    Com sempre en les bases de dades SQL t'estàs un segle per entendre com
    carai funciona el tema dels usuaris. Doncs bé després de moltes
    proves he solucionat el problema instal.lant el phpPgSQL un gestor PHP de bases
    de dades postgres.

    Aquest usa les propies bases de dades per entrar al programa a no se q
    desactivis al fitxer de configuració la opció d'authadv algo
    així com accés avançat. Així doncs desactives la
    opció entres a la base de dadesi afegeixes l'usuari 'root'. Un cop
    afegit aquest usuari ja pots activar la opció q havies desactivat i
    així soluciones fàcilment el problema dels usuaris.