Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

[Thomas G. <to...@ad...>]

On Tue, 30 Oct 2001, Oscar Buijten wrote:

> Hi Thomas,
>=20
> So then I thought, maybe there is some perl pgsql driver of some sort=20
> missing. This is the result:
> rpm -i postgresql-perl-7.1.3-1mdk.i586.rpm
> error: failed dependencies:
>          postgresql =3D 7.1.3-1mdk is needed by postgresql-perl-7.1.3-1md=
k
>          libpq.so.2   is needed by postgresql-perl-7.1.3-1mdk
>=20
> Is that because of this?:
>   psql -V

Hi Oscar - yes.  You are trying to install an rpm for a diff version
of Pg.  That will cause problems and here is another issue:

So, we must get the version mismatch sorted and then install the
missing libraries.

>=20
> Could I then just install: postgresql-libs-7.1.3-1mdk RPM for i586 ??
Dude.  I would use rpm (run man rpm to see the various options) to remove
all 7.0 postgres stuff prior to installing any 7.1 rpms.  You want to
be sure that all of your Pg stuff is the same version.  I will look around
here - I have a shell script to remove rpms and install the new ones.

BTW, you definitely want to use pg_dump to protect any data before you
make any sweeping changes as you will need to do a reload into 7.1
when you upgrade.  Postgres has no upgrade path for jumps in major
version numbers, i.e, 7.0 -> 7.1.  :-(


> > On Mon, 29 Oct 2001, Oscar Buijten wrote:
> >=20
> >=20
> >>Hi!
> >>
> >>Yesterday I have upgraded perl 5.6.1 (installed from source).
> >>Since then I have problems to use SQL-ledger....
> >>
> >>It seemed that I had lost DBI and DBD.
> >>So I have re-installed them (how to check the correctness??)...
> >>
> >=20
> > Hi Oscar,
> >=20
> > If you don't have any DBI.pm somewhere in ../site_perl/
> > (locate DBI | grep site_perl)
> > simply reinstall your drivers:
> > DBI first, followed by DBD-Pg
> >=20
> > It shouldn't be too much of a hassle.
> > So how do you like 5.6.1?
> >=20
> > Cheers,
> > Tom
> >=20
> > --------------------------------------------------------------------
> >               Saint Vincent Catholic Medical Centers               =20
> > --------------------------------------------------------------------
> > Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst                              Phone:  718-818-5528=20
> > Behavioral Health Services                      Fax:    718-818-5056 =
=20
> > Residential Services                            Mobile: 917-282-7359 =
=20
> > --------------------------------------------------------------------
> > /*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
> > --------------------------------------------------------------------
> >=20
> >=20
>=20
>=20
> --=20
> _____________________________________________________________
>=20
> Oscar Buijten
>=20
> Tel: +33.4.67.57.97.45
> Fax: +33.4.67.57.97.46
> GSM: +33.6.20.84.15.22
>=20
> Email: os...@el...
>=20
> Web:   www.elbie.com
>=20
>=20
>=20
>=20


--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------