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

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

Sorry Paulo,

Sounds like a bad idea. The following is in it.
[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 directory (in v7.0.3)
/var/lib/pgsql/data/base

I don't know if i is entirely correct, but I have changed the PGDATA env 
variable to: PGDATA=/var/lib/pgsql/data
I have run initdb and it seemed to do what it had to do.
Have strted the server with the scrpts of Thomas.
[root@euro /root]# ./pgstart.sh
Starting postgres service...postmaster: pid [2579] started...

This is what is in the log file:

  cat /home/oscar/postgres.log
DEBUG:  database system was shut down at 2001-11-02 15:32:29 CET
DEBUG:  CheckPoint record at (0, 1522080)
DEBUG:  Redo record at (0, 1522080); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 615; NextOid: 18720
DEBUG:  database system is in production state

I have restored the databases with:
postgres-# \i alldata.backup

That seems to have worked.

****************************************************************

So now I have tried to do the following:

[root@euro oscar]# rpm -i perl-DBI-1.14-4mdk.i586.rpm

[root@euro oscar]# rpm -i perl-DBD-Pg-0.91-2mdk.i586.rpm

[root@euro oscar]# perl testdbi.pl (your little test script Thomas)

install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC 
contains: /usr/local/lib/perl5/5.6.1/i686-linux 
/usr/local/lib/perl5/5.6.1 
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux 
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .) 
at (eval 1) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: ExampleP, Proxy.
  at testdbi.pl line 3

Looks like I am back to square 1....

Any suggestions???

Thanks,



Oscar



Paulo Rodrigues wrote:

> Oscar Buijten wrote:
> 
>>Hi Paulo,
>>
>>Thanks for your interest :-)
>>
>>I didn't yet.
>>This is the result:
>>
>>[root@euro conf]# su - postgres
>>[postgres@euro pgsql]$ initdb
>>This database system will be initialized with username "postgres".
>>This user will own all the data files and must also own the server process.
>>
>>initdb: The directory /var/lib/pgsql/data exists but is not empty.
>>If you want to create a new database system, either remove or empty
>>the directory /var/lib/pgsql/data or run initdb with
>>an argument other than /var/lib/pgsql/data.
>>
>>What do I do with that?
>>
>>Thanks,
>>
>>Oscar
>>
>>Paulo Rodrigues wrote:
>>
>>
>>>Oscar Buijten wrote:
>>>[HUGE SNIP]
>>>
>>>Hello Oscar,
>>>
>>>did you run initdb? Sorry I couldn't find a reference to it in your
>>>email.
>>>
>>>Paulo
>>>
>>>
>>>
>>--
>>_____________________________________________________________
>>
>>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
>>
> 
> Hi
> 
> you have no data in there, right? flush that dir: rm -rf
> /var/lib/pgsql/data and try again the initdb
> 
> good luck
> Paulo
> 
> 


-- 
_____________________________________________________________

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