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

[Oscar B. <os...@el...>]

Hi Thomas,

No problem!

Grrrr.... Not there yet.
This mail is a bit long, but I thought it would be best to provide details.

Tried your start script.
The logfile then says:
[root@euro /root]# cat /home/oscar/postgres.log
postmaster does not find the database system.
         Expected to find it in the PGDATA directory "/var/lib/pgsql/data",
         but unable to open file 
"/var/lib/pgsql/data/global/pg_control": No such file or directory

[root@euro /root]#

locate pg-control says:

/var/lib/pgsql/data/pg_control
/usr/lib/pgsql/contrib/pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/README.pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata.c
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata.o
/usr/lib/pgsql/contrib/pg_controldata/pg_crc.o
/usr/lib/pgsql/contrib/pg_controldata/pg_crc.c

then:

[root@euro data]# cd /var/lib/pgsql/data/
[root@euro data]# ls -l
total 192
-rw-------    1 40       41              4 Jun 11 16:47 PG_VERSION
-rw-------    1 40       41           8192 Oct 30 05:09 pg_control
-rw-------    1 40       41           8192 Oct 30 17:04 pg_database
-r--------    1 40       41           3407 Jun 11 16:47 pg_geqo.sample
-rw-------    1 40       41           8192 Oct 30 18:28 pg_group
-rw-------    1 40       41      16384 Oct 28 18:01 pg_group_name_index
-rw-------    1 40       41      16384 Oct 28 18:01 pg_group_sysid_index
-r--------    1 40       41           5794 Jun 20 10:37 pg_hba.conf
-r--------    1 root     root         5827 Jun 20 10:25 pg_hba.conf~
-rw-------    1 40       41          65536 Oct 30 20:57 pg_log
-rwx------    1 root     root           44 Jun 20 11:32 pg_options~*
-rw-------    1 40       41             35 Oct 28 18:01 pg_pwd
-rw-------    1 40       41              0 Oct 28 18:01 pg_pwd.reload
-rw-------    1 40       41           8192 Oct 28 18:01 pg_shadow
-rw-------    1 40       41           8192 Oct 30 20:57 pg_variable
drwx------    2 40       41           4096 Jun 11 16:47 pg_xlog/
-rw-------    1 40       41             87 Oct 30 05:09 postmaster.opts
-r--------    1 40       41       1 Jun 11 16:47 postmaster.opts.default
-rw-------    1 root     root           84 Jun 20 11:15 postmaster.opts~
-rw-------    1 40       41              4 Oct 30 05:09 postmaster.pid

I used to have a subdirectory 'base' in there with all the databases...
No 'global' directory to find either.

Extract of: cat /etc/profile

export PGDATA=/var/lib/pgsql/data
export POSTGRES_INCLUDE=/usr/include/pgsql
export POSTGRES_LIB=/usr/lib/pgsql
export PGLIB=/usr/lib/pgsql/contrib

Which is based on: locate pgsql

/etc/pgsql
/etc/pgsql/odbcinst.ini
/var/lib/pgsql
/var/lib/pgsql/backups
/var/lib/pgsql/data
/var/lib/pgsql/data/pg_xlog
/var/lib/pgsql/data/pg_control
/var/lib/pgsql/data/pg_variable
/var/lib/pgsql/data/pg_group
/var/lib/pgsql/data/pg_group_name_index
/var/lib/pgsql/data/pg_group_sysid_index
/var/lib/pgsql/data/pg_database
/var/lib/pgsql/data/pg_shadow
/var/lib/pgsql/data/pg_log
/var/lib/pgsql/data/PG_VERSION
/var/lib/pgsql/data/pg_hba.conf
/var/lib/pgsql/data/pg_geqo.sample
/var/lib/pgsql/data/postmaster.opts.default
/var/lib/pgsql/data/postmaster.pid
/var/lib/pgsql/data/postmaster.opts
/var/lib/pgsql/data/pg_hba.conf~
/var/lib/pgsql/data/pg_pwd
/var/lib/pgsql/data/pg_pwd.reload
/var/lib/pgsql/data/postmaster.opts~
/var/lib/pgsql/data/pg_options~
/var/lib/pgsql/.bashrc
/var/lib/pgsql/.bash_profile
/var/lib/pgsql/.bash_profile.rpmnew
/var/lib/pgsql/initdb.i18n
/var/log/pgsql
/usr/share/doc/postgresql-7.1.3/html/plpgsql-description.html
/usr/share/doc/postgresql-7.1.3/html/plpgsql-examples.html
/usr/share/doc/postgresql-7.1.3/html/plpgsql-porting.html
/usr/share/doc/postgresql-7.1.3/html/plpgsql-trigger.html
/usr/share/doc/postgresql-7.1.3/html/plpgsql.html
/usr/share/doc/php-pgsql-4.0.4pl1
/usr/share/doc/php-pgsql-4.0.4pl1/README
/usr/share/pgsql
/usr/share/pgsql/jdbc7.0-1.1.jar
/usr/share/pgsql/jdbc7.1-1.2.jar
/usr/share/pgsql/odbc.sql
/usr/share/pgsql/perl5
/usr/share/pgsql/perl5/test.pl
/usr/share/pgsql/backup
/usr/share/pgsql/backup/pg_dumpall_new
/usr/share/pgsql/global.bki
/usr/share/pgsql/global.description
/usr/share/pgsql/pg_hba.conf.sample
/usr/share/pgsql/pg_ident.conf.sample
/usr/share/pgsql/postgresql.conf.sample
/usr/share/pgsql/template1.bki
/usr/share/pgsql/template1.description
/usr/lib/pgsql
/usr/lib/pgsql/plpgsql.so
/usr/lib/pgsql/contrib
/usr/lib/pgsql/contrib/README
/usr/lib/pgsql/contrib/array
/usr/lib/pgsql/contrib/array/README.array_iterator
/usr/lib/pgsql/contrib/array/array_iterator.c
/usr/lib/pgsql/contrib/array/array_iterator.h
/usr/lib/pgsql/contrib/array/array_iterator.so
/usr/lib/pgsql/contrib/array/array_iterator.sql
/usr/lib/pgsql/contrib/array/array_iterator.sql.in
/usr/lib/pgsql/contrib/chkpass
/usr/lib/pgsql/contrib/chkpass/README.chkpass
/usr/lib/pgsql/contrib/chkpass/chkpass.c
/usr/lib/pgsql/contrib/chkpass/chkpass.sql
/usr/lib/pgsql/contrib/cube
/usr/lib/pgsql/contrib/cube/README.cube
/usr/lib/pgsql/contrib/cube/buffer.c
/usr/lib/pgsql/contrib/cube/buffer.h
/usr/lib/pgsql/contrib/cube/buffer.o
/usr/lib/pgsql/contrib/cube/cube.c
/usr/lib/pgsql/contrib/cube/cube.o
/usr/lib/pgsql/contrib/cube/cube.sql
/usr/lib/pgsql/contrib/cube/cube.sql.in
/usr/lib/pgsql/contrib/cube/cubedata.h
/usr/lib/pgsql/contrib/cube/cubeparse.c
/usr/lib/pgsql/contrib/cube/cubeparse.h
/usr/lib/pgsql/contrib/cube/cubeparse.o
/usr/lib/pgsql/contrib/cube/cubeparse.y
/usr/lib/pgsql/contrib/cube/cubescan.c
/usr/lib/pgsql/contrib/cube/cubescan.l
/usr/lib/pgsql/contrib/cube/cubescan.o
/usr/lib/pgsql/contrib/cube/data
/usr/lib/pgsql/contrib/cube/data/test_cube.data
/usr/lib/pgsql/contrib/cube/expected
/usr/lib/pgsql/contrib/cube/expected/cube.out
/usr/lib/pgsql/contrib/cube/libcube.a
/usr/lib/pgsql/contrib/cube/libcube.so
/usr/lib/pgsql/contrib/cube/libcube.so.1
/usr/lib/pgsql/contrib/cube/libcube.so.1.0
/usr/lib/pgsql/contrib/cube/sql
/usr/lib/pgsql/contrib/cube/sql/cube.sql
/usr/lib/pgsql/contrib/earthdistance
/usr/lib/pgsql/contrib/earthdistance/README.earthdistance
/usr/lib/pgsql/contrib/earthdistance/earthdistance.c
/usr/lib/pgsql/contrib/earthdistance/earthdistance.so
/usr/lib/pgsql/contrib/earthdistance/earthdistance.sql
/usr/lib/pgsql/contrib/earthdistance/earthdistance.sql.in
/usr/lib/pgsql/contrib/findoidjoins
/usr/lib/pgsql/contrib/findoidjoins/README.findoidjoins
/usr/lib/pgsql/contrib/findoidjoins/findoidjoins
/usr/lib/pgsql/contrib/findoidjoins/findoidjoins.c
/usr/lib/pgsql/contrib/findoidjoins/findoidjoins.o
/usr/lib/pgsql/contrib/findoidjoins/make_oidjoins_check
/usr/lib/pgsql/contrib/fulltextindex
/usr/lib/pgsql/contrib/fulltextindex/README.fti
/usr/lib/pgsql/contrib/fulltextindex/TODO
/usr/lib/pgsql/contrib/fulltextindex/fti.c
/usr/lib/pgsql/contrib/fulltextindex/fti.pl
/usr/lib/pgsql/contrib/fulltextindex/fti.so
/usr/lib/pgsql/contrib/fulltextindex/fti.sql
/usr/lib/pgsql/contrib/fulltextindex/fti.sql.in
/usr/lib/pgsql/contrib/fulltextindex/timings.sh
/usr/lib/pgsql/contrib/intarray
/usr/lib/pgsql/contrib/intarray/README.intarray
/usr/lib/pgsql/contrib/intarray/_int.c
/usr/lib/pgsql/contrib/intarray/_int.o
/usr/lib/pgsql/contrib/intarray/_int.sql
/usr/lib/pgsql/contrib/intarray/_int.sql.in
/usr/lib/pgsql/contrib/intarray/bench
/usr/lib/pgsql/contrib/intarray/bench/bench.pl
/usr/lib/pgsql/contrib/intarray/bench/create_test.pl
/usr/lib/pgsql/contrib/intarray/data
/usr/lib/pgsql/contrib/intarray/data/test__int.data
/usr/lib/pgsql/contrib/intarray/expected
/usr/lib/pgsql/contrib/intarray/expected/_int.out
/usr/lib/pgsql/contrib/intarray/lib_int.a
/usr/lib/pgsql/contrib/intarray/lib_int.so
/usr/lib/pgsql/contrib/intarray/lib_int.so.1
/usr/lib/pgsql/contrib/intarray/lib_int.so.1.0
/usr/lib/pgsql/contrib/intarray/sql
/usr/lib/pgsql/contrib/intarray/sql/_int.sql
/usr/lib/pgsql/contrib/ipc_check
/usr/lib/pgsql/contrib/ipc_check/README
/usr/lib/pgsql/contrib/ipc_check/ipc_check.pl
/usr/lib/pgsql/contrib/isbn_issn
/usr/lib/pgsql/contrib/isbn_issn/README.isbn_issn
/usr/lib/pgsql/contrib/isbn_issn/isbn_issn.c
/usr/lib/pgsql/contrib/isbn_issn/isbn_issn.so
/usr/lib/pgsql/contrib/isbn_issn/isbn_issn.sql
/usr/lib/pgsql/contrib/isbn_issn/isbn_issn.sql.in
/usr/lib/pgsql/contrib/lo
/usr/lib/pgsql/contrib/lo/README.lo
/usr/lib/pgsql/contrib/lo/lo.c
/usr/lib/pgsql/contrib/lo/lo.so
/usr/lib/pgsql/contrib/lo/lo.sql
/usr/lib/pgsql/contrib/lo/lo.sql.in
/usr/lib/pgsql/contrib/lo/lo_drop.sql
/usr/lib/pgsql/contrib/lo/lo_test.sql
/usr/lib/pgsql/contrib/mSQL-interface
/usr/lib/pgsql/contrib/mSQL-interface/README.mpgsql
/usr/lib/pgsql/contrib/mSQL-interface/mpgsql.c
/usr/lib/pgsql/contrib/mac
/usr/lib/pgsql/contrib/mac/README.mac
/usr/lib/pgsql/contrib/mac/createoui
/usr/lib/pgsql/contrib/mac/dropoui
/usr/lib/pgsql/contrib/mac/ouiparse.awk
/usr/lib/pgsql/contrib/mac/updateoui
/usr/lib/pgsql/contrib/miscutil
/usr/lib/pgsql/contrib/miscutil/README.misc_utils
/usr/lib/pgsql/contrib/miscutil/misc_utils.c
/usr/lib/pgsql/contrib/miscutil/misc_utils.h
/usr/lib/pgsql/contrib/miscutil/misc_utils.so
/usr/lib/pgsql/contrib/miscutil/misc_utils.sql
/usr/lib/pgsql/contrib/miscutil/misc_utils.sql.in
/usr/lib/pgsql/contrib/mysql
/usr/lib/pgsql/contrib/mysql/README
/usr/lib/pgsql/contrib/mysql/my2pg.pl
/usr/lib/pgsql/contrib/mysql/mysql2pgsql
/usr/lib/pgsql/contrib/noupdate
/usr/lib/pgsql/contrib/noupdate/README.noup
/usr/lib/pgsql/contrib/noupdate/noup.c
/usr/lib/pgsql/contrib/noupdate/noup.so
/usr/lib/pgsql/contrib/noupdate/noup.sql
/usr/lib/pgsql/contrib/noupdate/noup.sql.in
/usr/lib/pgsql/contrib/oid2name
/usr/lib/pgsql/contrib/oid2name/README.oid2name
/usr/lib/pgsql/contrib/oid2name/oid2name
/usr/lib/pgsql/contrib/oid2name/oid2name.c
/usr/lib/pgsql/contrib/oid2name/oid2name.o
/usr/lib/pgsql/contrib/pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/README.pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata.c
/usr/lib/pgsql/contrib/pg_controldata/pg_controldata.o
/usr/lib/pgsql/contrib/pg_controldata/pg_crc.o
/usr/lib/pgsql/contrib/pg_controldata/pg_crc.c
/usr/lib/pgsql/contrib/pg_dumplo
/usr/lib/pgsql/contrib/pg_dumplo/README.pg_dumplo
/usr/lib/pgsql/contrib/pg_dumplo/lo_export.c
/usr/lib/pgsql/contrib/pg_dumplo/lo_export.o
/usr/lib/pgsql/contrib/pg_dumplo/lo_import.c
/usr/lib/pgsql/contrib/pg_dumplo/lo_import.o
/usr/lib/pgsql/contrib/pg_dumplo/main.c
/usr/lib/pgsql/contrib/pg_dumplo/main.o
/usr/lib/pgsql/contrib/pg_dumplo/pg_dumplo
/usr/lib/pgsql/contrib/pg_dumplo/pg_dumplo.h
/usr/lib/pgsql/contrib/pg_dumplo/utils.c
/usr/lib/pgsql/contrib/pg_dumplo/utils.o
/usr/lib/pgsql/contrib/pg_logger
/usr/lib/pgsql/contrib/pg_logger/README.pg_logger
/usr/lib/pgsql/contrib/pg_logger/pg_logger
/usr/lib/pgsql/contrib/pg_logger/pg_logger.c
/usr/lib/pgsql/contrib/pg_logger/pg_logger.o
/usr/lib/pgsql/contrib/pg_resetxlog
/usr/lib/pgsql/contrib/pg_resetxlog/README.pg_resetxlog
/usr/lib/pgsql/contrib/pg_resetxlog/pg_crc.c
/usr/lib/pgsql/contrib/pg_resetxlog/pg_crc.o
/usr/lib/pgsql/contrib/pg_resetxlog/pg_resetxlog
/usr/lib/pgsql/contrib/pg_resetxlog/pg_resetxlog.c
/usr/lib/pgsql/contrib/pg_resetxlog/pg_resetxlog.o
/usr/lib/pgsql/contrib/pgbench
/usr/lib/pgsql/contrib/pgbench/README.pgbench
/usr/lib/pgsql/contrib/pgbench/README.pgbench_jis
/usr/lib/pgsql/contrib/pgbench/pgbench
/usr/lib/pgsql/contrib/pgbench/pgbench.c
/usr/lib/pgsql/contrib/pgbench/pgbench.o
/usr/lib/pgsql/contrib/pgcrypto
/usr/lib/pgsql/contrib/pgcrypto/README.pgcrypto
/usr/lib/pgsql/contrib/pgcrypto/encode.c
/usr/lib/pgsql/contrib/pgcrypto/encode.h
/usr/lib/pgsql/contrib/pgcrypto/encode.o
/usr/lib/pgsql/contrib/pgcrypto/internal.c
/usr/lib/pgsql/contrib/pgcrypto/internal.o
/usr/lib/pgsql/contrib/pgcrypto/krb.c
/usr/lib/pgsql/contrib/pgcrypto/libpgcrypto.a
/usr/lib/pgsql/contrib/pgcrypto/libpgcrypto.so
/usr/lib/pgsql/contrib/pgcrypto/libpgcrypto.so.0
/usr/lib/pgsql/contrib/pgcrypto/libpgcrypto.so.0.1
/usr/lib/pgsql/contrib/pgcrypto/md5.c
/usr/lib/pgsql/contrib/pgcrypto/md5.h
/usr/lib/pgsql/contrib/pgcrypto/md5.o
/usr/lib/pgsql/contrib/pgcrypto/mhash.c
/usr/lib/pgsql/contrib/pgcrypto/openssl.c
/usr/lib/pgsql/contrib/pgcrypto/pgcrypto.c
/usr/lib/pgsql/contrib/pgcrypto/pgcrypto.h
/usr/lib/pgsql/contrib/pgcrypto/pgcrypto.o
/usr/lib/pgsql/contrib/pgcrypto/pgcrypto.sql
/usr/lib/pgsql/contrib/pgcrypto/pgcrypto.sql.in
/usr/lib/pgsql/contrib/pgcrypto/sha1.c
/usr/lib/pgsql/contrib/pgcrypto/sha1.h
/usr/lib/pgsql/contrib/pgcrypto/sha1.o
/usr/lib/pgsql/contrib/retep
/usr/lib/pgsql/contrib/retep/CHANGELOG
/usr/lib/pgsql/contrib/retep/Implementation
/usr/lib/pgsql/contrib/retep/README
/usr/lib/pgsql/contrib/retep/build.xml
/usr/lib/pgsql/contrib/retep/data
/usr/lib/pgsql/contrib/retep/data/cds.dtd
/usr/lib/pgsql/contrib/retep/data/cds.xml
/usr/lib/pgsql/contrib/retep/retep.jpx
/usr/lib/pgsql/contrib/retep/uk
/usr/lib/pgsql/contrib/retep/uk/org
/usr/lib/pgsql/contrib/retep/uk/org/retep
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DCollection.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DConstants.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DElement.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DEnvironment.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DModule.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DModuleXML.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DNode.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DProcessor.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/dtu/DTransform.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/tools
/usr/lib/pgsql/contrib/retep/uk/org/retep/tools/Tool.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/tools.properties
/usr/lib/pgsql/contrib/retep/uk/org/retep/util
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/ExceptionDialog.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/Globals.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/Logger.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/Main.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/StandaloneApp.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/hba
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/hba/Editor.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/hba/Main.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/hba/Record.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/misc
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/misc/IPAddress.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/misc/PropertiesIO.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/misc/WStringTokenizer.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/models
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/models/HBATableModel.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/models/PropertiesTableModel.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/proped
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/proped/Main.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/util/proped/PropertyEditor.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/core
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/core/XMLFactory.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/core/XMLFactoryException.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/jdbc
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/jdbc/XMLDatabase.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/jdbc/XMLResultSet.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/parser
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/parser/TagHandler.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/parser/TagListener.java
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/test
/usr/lib/pgsql/contrib/retep/uk/org/retep/xml/test/XMLExport.java
/usr/lib/pgsql/contrib/rserv
/usr/lib/pgsql/contrib/rserv/ApplySnapshot
/usr/lib/pgsql/contrib/rserv/ApplySnapshot.in
/usr/lib/pgsql/contrib/rserv/CleanLog
/usr/lib/pgsql/contrib/rserv/CleanLog.in
/usr/lib/pgsql/contrib/rserv/GetSyncID
/usr/lib/pgsql/contrib/rserv/GetSyncID.in
/usr/lib/pgsql/contrib/rserv/InitRservTest
/usr/lib/pgsql/contrib/rserv/InitRservTest.in
/usr/lib/pgsql/contrib/rserv/MasterAddTable
/usr/lib/pgsql/contrib/rserv/MasterAddTable.in
/usr/lib/pgsql/contrib/rserv/MasterInit
/usr/lib/pgsql/contrib/rserv/MasterInit.in
/usr/lib/pgsql/contrib/rserv/MasterSync
/usr/lib/pgsql/contrib/rserv/MasterSync.in
/usr/lib/pgsql/contrib/rserv/PrepareSnapshot
/usr/lib/pgsql/contrib/rserv/PrepareSnapshot.in
/usr/lib/pgsql/contrib/rserv/README.rserv
/usr/lib/pgsql/contrib/rserv/RServ.pm
/usr/lib/pgsql/contrib/rserv/Replicate
/usr/lib/pgsql/contrib/rserv/Replicate.in
/usr/lib/pgsql/contrib/rserv/RservTest
/usr/lib/pgsql/contrib/rserv/RservTest.in
/usr/lib/pgsql/contrib/rserv/SlaveAddTable
/usr/lib/pgsql/contrib/rserv/SlaveAddTable.in
/usr/lib/pgsql/contrib/rserv/SlaveInit
/usr/lib/pgsql/contrib/rserv/SlaveInit.in
/usr/lib/pgsql/contrib/rserv/master.sql
/usr/lib/pgsql/contrib/rserv/master.sql.in
/usr/lib/pgsql/contrib/rserv/regress.sh
/usr/lib/pgsql/contrib/rserv/rserv.c
/usr/lib/pgsql/contrib/rserv/rserv.so
/usr/lib/pgsql/contrib/rserv/slave.sql
/usr/lib/pgsql/contrib/rserv/slave.sql.in
/usr/lib/pgsql/contrib/seg
/usr/lib/pgsql/contrib/seg/README.seg
/usr/lib/pgsql/contrib/seg/buffer.c
/usr/lib/pgsql/contrib/seg/buffer.h
/usr/lib/pgsql/contrib/seg/buffer.o
/usr/lib/pgsql/contrib/seg/data
/usr/lib/pgsql/contrib/seg/data/test_seg.data
/usr/lib/pgsql/contrib/seg/expected
/usr/lib/pgsql/contrib/seg/expected/seg.out
/usr/lib/pgsql/contrib/seg/libseg.a
/usr/lib/pgsql/contrib/seg/libseg.so
/usr/lib/pgsql/contrib/seg/libseg.so.1
/usr/lib/pgsql/contrib/seg/libseg.so.1.0
/usr/lib/pgsql/contrib/seg/seg-validate.pl
/usr/lib/pgsql/contrib/seg/seg.c
/usr/lib/pgsql/contrib/seg/seg.o
/usr/lib/pgsql/contrib/seg/seg.sql
/usr/lib/pgsql/contrib/seg/seg.sql.in
/usr/lib/pgsql/contrib/seg/segdata.h
/usr/lib/pgsql/contrib/seg/segparse.c
/usr/lib/pgsql/contrib/seg/segparse.h
/usr/lib/pgsql/contrib/seg/segparse.o
/usr/lib/pgsql/contrib/seg/segparse.y
/usr/lib/pgsql/contrib/seg/segscan.c
/usr/lib/pgsql/contrib/seg/segscan.l
/usr/lib/pgsql/contrib/seg/segscan.o
/usr/lib/pgsql/contrib/seg/sort-segments.pl
/usr/lib/pgsql/contrib/seg/sql
/usr/lib/pgsql/contrib/seg/sql/seg.sql
/usr/lib/pgsql/contrib/soundex
/usr/lib/pgsql/contrib/soundex/README.soundex
/usr/lib/pgsql/contrib/soundex/soundex.c
/usr/lib/pgsql/contrib/soundex/soundex.so
/usr/lib/pgsql/contrib/soundex/soundex.sql
/usr/lib/pgsql/contrib/soundex/soundex.sql.in
/usr/lib/pgsql/contrib/spi
/usr/lib/pgsql/contrib/spi/README.spi
/usr/lib/pgsql/contrib/spi/autoinc.c
/usr/lib/pgsql/contrib/spi/autoinc.example
/usr/lib/pgsql/contrib/spi/autoinc.so
/usr/lib/pgsql/contrib/spi/autoinc.sql
/usr/lib/pgsql/contrib/spi/autoinc.sql.in
/usr/lib/pgsql/contrib/spi/insert_username.c
/usr/lib/pgsql/contrib/spi/insert_username.example
/usr/lib/pgsql/contrib/spi/insert_username.so
/usr/lib/pgsql/contrib/spi/insert_username.sql
/usr/lib/pgsql/contrib/spi/insert_username.sql.in
/usr/lib/pgsql/contrib/spi/moddatetime.c
/usr/lib/pgsql/contrib/spi/moddatetime.example
/usr/lib/pgsql/contrib/spi/moddatetime.so
/usr/lib/pgsql/contrib/spi/moddatetime.sql
/usr/lib/pgsql/contrib/spi/moddatetime.sql.in
/usr/lib/pgsql/contrib/spi/preprocessor
/usr/lib/pgsql/contrib/spi/preprocessor/README.MAX
/usr/lib/pgsql/contrib/spi/preprocessor/example.sql
/usr/lib/pgsql/contrib/spi/preprocessor/step1.c
/usr/lib/pgsql/contrib/spi/preprocessor/step1.e
/usr/lib/pgsql/contrib/spi/preprocessor/step2.pl
/usr/lib/pgsql/contrib/spi/refint.c
/usr/lib/pgsql/contrib/spi/refint.example
/usr/lib/pgsql/contrib/spi/refint.so
/usr/lib/pgsql/contrib/spi/refint.sql
/usr/lib/pgsql/contrib/spi/refint.sql.in
/usr/lib/pgsql/contrib/spi/timetravel.c
/usr/lib/pgsql/contrib/spi/timetravel.example
/usr/lib/pgsql/contrib/spi/timetravel.so
/usr/lib/pgsql/contrib/spi/timetravel.sql
/usr/lib/pgsql/contrib/spi/timetravel.sql.in
/usr/lib/pgsql/contrib/start-scripts
/usr/lib/pgsql/contrib/start-scripts/freebsd
/usr/lib/pgsql/contrib/start-scripts/linux
/usr/lib/pgsql/contrib/string
/usr/lib/pgsql/contrib/string/README.string_io
/usr/lib/pgsql/contrib/string/string_io.c
/usr/lib/pgsql/contrib/string/string_io.h
/usr/lib/pgsql/contrib/string/string_io.so
/usr/lib/pgsql/contrib/string/string_io.sql
/usr/lib/pgsql/contrib/string/string_io.sql.in
/usr/lib/pgsql/contrib/tips
/usr/lib/pgsql/contrib/tips/README.apachelog
/usr/lib/pgsql/contrib/tools
/usr/lib/pgsql/contrib/tools/add-emacs-variables
/usr/lib/pgsql/contrib/tools/find-sources
/usr/lib/pgsql/contrib/tools/make-tags
/usr/lib/pgsql/contrib/unixdate
/usr/lib/pgsql/contrib/unixdate/unixdate.sql
/usr/lib/pgsql/contrib/userlock
/usr/lib/pgsql/contrib/userlock/README.user_locks
/usr/lib/pgsql/contrib/userlock/user_locks.c
/usr/lib/pgsql/contrib/userlock/user_locks.h
/usr/lib/pgsql/contrib/userlock/user_locks.so
/usr/lib/pgsql/contrib/userlock/user_locks.sql
/usr/lib/pgsql/contrib/userlock/user_locks.sql.in
/usr/lib/pgsql/contrib/vacuumlo
/usr/lib/pgsql/contrib/vacuumlo/README.vacuumlo
/usr/lib/pgsql/contrib/vacuumlo/vacuumlo
/usr/lib/pgsql/contrib/vacuumlo/vacuumlo.c
/usr/lib/pgsql/contrib/vacuumlo/vacuumlo.o
/usr/lib/php/extensions/pgsql.so
/usr/include/pgsql
/usr/include/pgsql/fe-auth.c
/usr/include/pgsql/fe-auth.h
/usr/include/pgsql/fe-connect.c
/usr/include/pgsql/fe-exec.c
/usr/include/pgsql/fe-lobj.c
/usr/include/pgsql/fe-misc.c
/usr/include/pgsql/fe-print.c
/usr/include/pgsql/libpqdll.c
/usr/include/pgsql/libpqdll.def
/usr/include/pgsql/libpq-fe.h
/usr/include/pgsql/libpq-int.h
/usr/include/pgsql/libpq.rc
/usr/include/pgsql/Makefile
/usr/include/pgsql/pqexpbuffer.c
/usr/include/pgsql/pqexpbuffer.h
/usr/include/pgsql/pqsignal.c
/usr/include/pgsql/pqsignal.h
/usr/include/pgsql/README
/usr/include/pgsql/win32.h
/usr/include/pgsql/win32.mak
/usr/include/pgsql/Changes
/usr/include/pgsql/GNUmakefile
/usr/include/pgsql/Makefile.PL
/usr/include/pgsql/MANIFEST
/usr/include/pgsql/Pg.pm
/usr/include/pgsql/Pg.xs
/usr/include/pgsql/ppport.h
/usr/include/pgsql/test.pl
/usr/include/pgsql/typemap

So I guess I would need to explain postmaster to find his 'pg_control' 
in /var/lib/pgsql/data/ , but I have no idea how to do that. Or is the 
problem already in:
postmaster does not find the database system.
         Expected to find it in the PGDATA directory "/var/lib/pgsql/data"?

MANY Thanks in advance!!

Regards,

Oscar


Thomas Good wrote:

> 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]
>>
>>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 
> 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
> # 
> # 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 - postgres 
> sleep 1
> pid=`pidof postmaster`
> echo -e "postmaster: pid [$pid] started..."
> 
> Here is another script to shut down the db manually:
> 
> #!/bin/sh
> # 
> # SQL Clinic --- Version 1.0.0
> # Copyright(c) 2001 by Thomas Good <www.sqlclinic.net>
> # 
> echo -n "Stopping postgres service..."
> pid=`pidof postmaster`
> if [ "$pid" != "" ] ; then
> 	echo -n "postmaster: pid [$pid] killed."
> 	kill -TERM $pid
> 	sleep 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                
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-818-5528 
> Behavioral Health Services                      Fax:    718-818-5056  
> Residential Services                            Mobile: 917-282-7359  
> --------------------------------------------------------------------
> /*         Rekordmeister ist nur der FC Bayern München!           */
> --------------------------------------------------------------------
> 
> 


-- 
_____________________________________________________________

Oscar Buijten

Tel: +33.4.67.57.97.45
Fax: +33.4.67.57.97.46
GSM: +33.6.20.84.15.22

Email: os...@el...

Web:   www.elbie.com