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
> As  psql -V says:
> psql (PostgreSQL) 7.0.3
>=20
> Why then not just install: postgresql-perl-7.0.3-8 RPM for i386 ??
>=20
> from:=20
> http://rpmfind.net/linux/RPM/redhat/7.1/i386/postgresql-perl-7.0.3-8.i386=
=2Ehtml
>=20
> This woul save me the hassle of reinstalling, pg_dumping and whatever=20
> else....
>=20
> Is my assumption correct??

This will work but if we have to do the work why not upgrade?
7.1 sports outer joins and other new features but the most important
improvement for me (I recently upgraded) was the maximum size of a row
leapt from 8k to 1G!  This solved alot of problems for me.

Here is the upgrade path:

1.  pg_dump oscar > oscar.df  (where oscar is your db name)
2.  postgresql stop
3.  rm all the old rpms
4.  install the new ones
5.  postgresql start (it will run initdb and vacuum the new database)
6.  as the postgres user:  createuser nobody  (and whomever else you need)
7.  psql oscar < oscar.df

It is quite simple really and I will help you if you get stuck.
I think the upgrade is worth it and you won't regret knowing how to
do a dump and reload anyhow.  It is the best way to test that your
data backups are succeeding.  ;-)

The only hassle is recreating users but if you use a web interface
like sql ledger even this is no problem as the number of users is
generally limited (I have only nobody on pg and one or two on oracle.)

In any case, good luck!

--------------------------------------------------------------------
              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!           */
--------------------------------------------------------------------