I found that postgresql-perl installed plpgsql.so in /usr/lib, instead of
/usr/lib/pgsql
My import of a 7.0 database used pl/pgsql and it errored on import (psql xyz
< dump) saying that /usr/lib/pgsql/plpgsql.so not found.
For what it's worth.
-dan
"David Lizano" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I have installed PostgreSQL v7.1 in RedHat from RPM's and I have find some
> bugs:
>
>
>
> Stopping the service:
> ===============
> When '/etc/rc.d/init.d/postgresql stop' try to stop 'postmaster' can't
find
> the 'postmaster.pid' file, and don't stop the postmaster daemon.
>
> Y think it try to get in from $PGDATA/postmaster.pid , and it is locate in
> '/var/run/postmaster.pid', so it don't works.
>
> In the stop zone add:
> killall -TERM postmaster
>
>
> logs
> ===
> The logs goes to /dev/null.
>
> change "pg_ctl > /dev/null"
>
> by
> "pg_ctl > var/log/postgresql"
>
>
> Access 'postmaster' through TCP/IP (it is not formerly a bug)
> ============================================
> By default yo can't acces through TCP/IP, add this:
> -o '-i'
> then:
>
> pg_ctl -o '-i'
>
>
> Starting "PostgreSQL" when the server does.
> ================================
> The installation script don't do this, you must do it if you wants that
> 'postmaster' starts when the server does.
>
>
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc3.d/S50postgresql
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc4.d/S50postgresql
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc5.d/S50postgresql
>
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc0.d/K25postgresql
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc1.d/K25postgresql
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc2.d/K25postgresql
> ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc6.d/K25postgresql
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> David Lizano - Director área técnica
> correo-e: [EMAIL PROTECTED]
>
> I Z A N E T - Servicios integrales de internet.
> web: http://www.izanet.com/
> Dirección: C/ Checa, 57-59, 3º D - 50.007 Zaragoza (España)
> Teléfono: +34 976 25 80 23 Fax: +34 976 25 80 24
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
