----- Original Message -----
From: "N@ta$" <[EMAIL PROTECTED]>
To: "Mike Slack" <[EMAIL PROTECTED]>; "DBI Users" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 10:03 PM
Subject: Re: CPAN Errors
> Well, that did get me past those errors.. Thanks so far ;-)
>
> Now, when I do install DBD::Pg, it goes through the install process and
then
> returns the following:
> DBI->connect(dbname=template1) failed: FATAL 1: SetUserId: user 'root' is
> not in 'pg_shadow' at test.pl line 59
It's trying to run the test and connect to the database as your username (in
this case, 'root'). If you want to run the test, you have to first run
'make clean' as root, then make the program again as the user 'postgres' (or
whatver usernames are valid postgres users. postgres is the default)
To summarize:
make clean (root) - this gets rid of the old, root-owned files
perl Makefile.PL (postgres)
make (postgres)
make test (postgres)
make install (root)
-Mike
