Re: Bugs in PostgreSQL v7.1 rpms for RedHat

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" <david(dot)lizano(at)izanet(dot)com> wrote in message
news:4(dot)3(dot)2(dot)7(dot)0(dot)20010418231401(dot)00bfbc10(at)mail(dot)izanet(dot)com(dot)(dot)(dot)
>
> 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 tcnica
> correo-e: david(dot)lizano(at)izanet(dot)com
>
> I Z A N E T - Servicios integrales de internet.
> web: http://www.izanet.com/
> Direccin: C/ Checa, 57-59, 3 D - 50.007 Zaragoza (Espaa)
> Telfono: +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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly