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,

Hi Oscar - doing our monthly billing here so I apologise for not
getting back to you.

> [root@euro init.d]# psql -V
> psql (PostgreSQL) 7.1.3

Good.

> [root@euro init.d]# ./postgresql start
> Initializing database: [  OK  ]
> Starting postgresql service: [FAILED]
>=20
> Any good suggestions??

Ok, first off, the usual approach with the rpms is to disable logging.
That stinks as we have nothing to go by!  Usually you get an error=20
message sent to a log and that gives us somewhere to start.

Use this script to start up your database...but edit it to place
the logfile in a directory that exists on your system (doesn't matter
where as long as you know where it is.)

#!/bin/sh
#=20
# SQL Clinic --- Version 1.0.0
# Copyright(c) 2001 by Thomas Good <www.sqlclinic.net>
#
echo -n "Starting postgres service..."
# edit this next line:
echo "nohup postmaster -i > /home/postgres/postgres.log 2>&1 &" | su - post=
gres=20
sleep 1
pid=3D`pidof postmaster`
echo -e "postmaster: pid [$pid] started..."

Here is another script to shut down the db manually:

#!/bin/sh
#=20
# SQL Clinic --- Version 1.0.0
# Copyright(c) 2001 by Thomas Good <www.sqlclinic.net>
#=20
echo -n "Stopping postgres service..."
pid=3D`pidof postmaster`
if [ "$pid" !=3D "" ] ; then
=09echo -n "postmaster: pid [$pid] killed."
=09kill -TERM $pid
=09sleep 1
fi
echo


I also suggest you have a look at www.sqlclinic.net
and click on Documentation.  Check out chapter 2.
This is all about how I setup postgres.  Some of it doesn't
apply but things will be less mysterious after you read
through it.

Anyway, try the script (run it as root) and then have a look at
the log file.  Maybe it will shed some light!
--------------------------------------------------------------------
              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!           */
--------------------------------------------------------------------