Menu
▾
▴
Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available
|
From: Thomas G. <to...@ad...> - 2001-10-30 16:21:42
|
On Tue, 30 Oct 2001, Thomas Good wrote:
> be sure that all of your Pg stuff is the same version. I will look aroun=
d
> 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. :-(
Oscar - here is a script I used to go from 6.5 to 7.0
If you change the version numbers, collect all of the necessary
rpms and then run the script you should be fine. =20
Just remember to back up your data first!
#!/bin/sh
rm -ir /var/lib/pgsql/data/base
rpm -e postgresql-test-6.5.2-1
rpm -e postgresql-jdbc-6.5.2-1
rpm -e postgresql-odbc-6.5.2-1
rpm -e postgresql-perl-6.5.2-1
rpm -e postgresql-python-6.5.2-1
rpm -e postgresql-tcl-6.5.2-1
rpm -e postgresql-devel-6.5.2-1
rpm -e postgresql-server-6.5.2-1
rpm -e php-pgsql-3.0.12-6
rpm -e postgresql-6.5.2-1
rpm -i postgresql-7.0.3-2.i386.rpm
rpm -i postgresql-server-7.0.3-2.i386.rpm
rpm -i postgresql-devel-7.0.3-2.i386.rpm
rpm -i postgresql-test-7.0.3-2.i386.rpm
rpm -i postgresql-jdbc-7.0.3-2.i386.rpm
rpm -i postgresql-odbc-7.0.3-2.i386.rpm
rpm -i postgresql-perl-7.0.3-2.i386.rpm
rpm -i postgresql-python-7.0.3-2.i386.rpm
rpm -i postgresql-tcl-7.0.3-2.i386.rpm
rpm -i postgresql-tk-7.0.3-2.i386.rpm
/etc/rc.d/init.d/postgresql start
--------------------------------------------------------------------
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! */
--------------------------------------------------------------------
|
